DB研討會 : [轉貼]幾個有關 MySQL 資料庫的操作小技巧

$tbchk = "SHOW TABLES LIKE '$table' ";
$tbchkres = mysql_query($tbchk);

CREATE TABLE 'new_table' LIKE 'old_table';

mysqldump --user=username --password --default-character-set=latin1 database 〉 dump.sql

# mysqld_safe --skip-grant-tables &

# mysql -u root mysql

mysql> UPDATE user SET password=PASSWORD('newpassword') WHERE user='root';
mysql> flush privileges;

SHOW FULL FIELDS FROM database.table

SHOW FULL FIELDS FROM table FROM database