You can use \G instead of ; for tables with lots of fields.
mysql> SHOW STATUS LIKE ‘Qcache%’;
+————————-+———–+
| Variable_name | Value |
+————————-+———–+
| Qcache_queries_in_cache | 6990 |
| Qcache_inserts | 6990 |
| Qcache_hits | 3987 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 621 |
| Qcache_free_memory | 176329432 |
| Qcache_free_blocks | 1 (more…)
I have a database called sinistermusic.
in that database there are 2 tables:
bands & bandsinfo.
The table bands contains only bandid and bandname.
The table bandsinfo contains only infoid, bandname, genre, albums,bio.
I want to make a page called "bands". which displays all the bands.
When you click on the band you will go the a more detailed page of that band,
with their biography and albums.
Can someone tell me how I do that or point me to a detailed tuto (more…)
Hi,
I’m trying to group a sort of images by their same date with timestamp (2006-06-16 11:09:44), so, they can show grouped by the day added.
Database Example:
————
Id Album Date |
————
1 458 2006-06-16 11:09:44
2 458 2006-06-16 11:09:44
3 458 2006-06-16 11:09:44
4 458 2007-08-10 15:45:00
5 458 2007-08-10 15:45:00
6 458 2007-08-10 15:45:00
7 458 2008-01-01 12:00:01
Resul (more…)
You can use \G instead of ; for tables with lots of fields.
mysql> SHOW STATUS LIKE ‘Qcache%’;
+————————-+———–+
| Variable_name | Value |
+————————-+———–+
| Qcache_queries_in_cache | 6990 |
| Qcache_inserts | 6990 |
| Qcache_hits | 3987 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 621 |
| Qcache_free_memory | 176329432 |
| Qcache_free_blocks | 1 (more…)
Ok. I’m getting this error when I try connecting from php scripts to mysql:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘root’@'localhost’ (using password: YES) in /home2/challeng/public_html/register.php on line 47
Access denied for user ‘root’@'localhost’ (using password: YES)
And here is the php code:
<?php
// Connects to your Database
mysql_connect("localhost", "root", "mitch") or die(mysql_error()); (more…)