MYSQL必讀
  mysql -h110.110.110.110 -u root -p 123;(注:u與root之間可以不用加空格,其它也一樣)

MYSQL必讀
mysqladmin -u root -password ab12

MYSQL必讀
mysqladmin -u root -p ab12 password djg345

MYSQL必讀
grant select,insert,update,delete on *.* to [email=test1@”%]test1@”%[/email]” Identified by “abc”;

MYSQL必讀
 grant select,insert,update,delete on mydb.* to [email=test2@localhost]test2@localhost[/email] identified by “abc”;

MYSQL必讀
 grant select,insert,update,delete on mydb.* to [email=test2@localhost]test2@localhost[/email] identified by “”;

MYSQL必讀
 mysql> create database xhkdb;

MYSQL必讀
mysql> show databases;

MYSQL必讀
mysql> drop database xhkdb;

MYSQL必讀
  mysql> drop database drop_database;
  Query OK, 0 rows affected (0.00 sec)

MYSQL必讀
 mysql> drop database drop_database;
  ERROR 1008 (HY000): Can't drop database 'drop_database'; database doesn't exist
   //發生錯誤,不能刪除'drop_database'數據庫,該數據庫不存在.
  mysql> drop database if exists drop_database;
  Query OK, 0 rows affected, 1 warning (0.00 sec)//產生一個警告說明此數據庫不存在
  mysql> create database drop_database;
  Query OK, 1 row affected (0.00 sec)
  mysql> drop database if exists drop_database;//if exists 判斷數據庫是否存在,不存在也不產生錯誤
  Query OK, 0 rows affected (0.00 sec)

MYSQL必讀
mysql> use xhkdb;

MYSQL必讀
  mysql> USE db1;
  mysql> SELECT COUNT(*) FROM mytable;  # selects from db1.mytable
  mysql> USE db2;
  mysql> SELECT COUNT(*) FROM mytable;  # selects from db2.mytable

MYSQL必讀
  mysql> USE db1;
  mysql> SELECT author_name,editor_name FROM author,db2.editor
    ->    WHERE author.editor_id = db2.editor.editor_id;

MYSQL必讀
mysql> select database();

MYSQL必讀
mysql> select version(); 
+-----------------------+ 
| version()       | 
+-----------------------+ 
| 6.0.4-alpha-community | 
+-----------------------+ 
1 row in set (0.02 sec)

MYSQL必讀
mysql> select now(); 
+---------------------+ 
| now()        | 
+---------------------+ 
| 2009-09-15 22:35:32 | 
+---------------------+ 
1 row in set (0.04 sec)

MYSQL必讀
SELECT DAYOFMONTH(CURRENT_DATE); 
+--------------------------+ 
| DAYOFMONTH(CURRENT_DATE) | 
+--------------------------+ 
|            15 | 
+--------------------------+ 
1 row in set (0.01 sec) 
 
SELECT MONTH(CURRENT_DATE); 
+---------------------+ 
| MONTH(CURRENT_DATE) | 
+---------------------+ 
|          9 | 
+---------------------+ 
1 row in set (0.00 sec) 
 
SELECT YEAR(CURRENT_DATE); 
+--------------------+ 
| YEAR(CURRENT_DATE) | 
+--------------------+ 
|        2009 | 
+--------------------+ 
1 row in set (0.00 sec)

MYSQL必讀
mysql> SELECT "welecome to my blog!"; 
+----------------------+ 
| welecome to my blog! | 
+----------------------+ 
| welecome to my blog! | 
+----------------------+ 
1 row in set (0.00 sec)

MYSQL必讀
select ((4 * 4) / 10 ) + 25; 
+----------------------+ 
| ((4 * 4) / 10 ) + 25 | 
+----------------------+ 
|        26.60 | 
+----------------------+ 
1 row in set (0.00 sec)

MYSQL必讀
select CONCAT(f_name, " ", l_name) 
AS Name 
from employee_data 
where title = 'Marketing Executive'; 
+---------------+ 
| Name     | 
+---------------+ 
| Monica Sehgal | 
| Hal Simlai  | 
| Joseph Irvine | 
+---------------+ 
3 rows in set (0.00 sec) 

MYSQL必讀
mysql> create table MyClass(
> id int(4) not null primary key auto_increment,
> name char(20) not null,
> sex int(4) not null default '0',
> degree double(16,2));

MYSQL必讀
  mysql> drop table MyClass;

MYSQL必讀
 mysql> insert into MyClass values(1,'Tom',96.45),(2,'Joan',82.99), (2,'Wang', 96.59);

MYSQL必讀
  mysql> select * from MyClass;

MYSQL必讀
mysql> select * from MyClass order by id limit 0,2;

MYSQL必讀
mysql> delete from MyClass where id=1;

MYSQL必讀
<?php 
  $con = mysql_connect("localhost","peter","abc123"); 
  if (!$con) 
  {
   die('Could not connect: ' . mysql_error()); 
  } 
  mysql_select_db("my_db", $con); 
  mysql_query("DELETE FROM Persons WHERE LastName='Griffin'"); mysql_close($con); 
?>

MYSQL必讀
mysql> update MyClass set name='Mary' where id=1;

MYSQL必讀
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1 [, col_name2=expr2 ...] [WHERE where_definition] [ORDER BY ...] [LIMIT row_count]

MYSQL必讀
UPDATE [LOW_PRIORITY] [IGNORE] table_references SET col_name1=expr1 [, col_name2=expr2 ...] [WHERE where_definition]

MYSQL必讀
mysql> alter table MyClass add passtest int(4) default '0'

MYSQL必讀
mysql> alter table employee add index emp_name (name);

MYSQL必讀
mysql> alter table employee add primary key(id);

MYSQL必讀
mysql> alter table employee add unique emp_name2(cardnumber);

MYSQL必讀
mysql>alter table employee drop index emp_name;

MYSQL必讀
mysql> ALTER TABLE table_name ADD field_name field_type;

MYSQL必讀
mysql> ALTER TABLE table_name CHANGE old_field_name new_field_name field_type;

MYSQL必讀
MySQL ALTER TABLE table_name DROP field_name;

MYSQL必讀
 mysql> rename table MyClass to YouClass;

MYSQL必讀
  mysqldump -u user_name -p123456 database_name > outfile_name.sql

MYSQL必讀
  mysqldump -u user_name -p database_name table_name > outfile_name.sql

MYSQL必讀
mysqldump -u user_name -p -d Cadd-drop-table database_name > outfile_name.sql

MYSQL必讀
mysqldump -uroot -p Cdefault-character-set=latin1 Cset-charset=gbk Cskip-opt database_name > outfile_name.sql

MYSQL必讀
[root@test1 root]# cd　/home/data/mysql
　　[root@test1 mysql]# mysqldump -u root -p --opt aaa > back_aaa

MYSQL必讀
drop database if exists school; //如果存在SCHOOL則刪除
create database school; //建立庫SCHOOL
use school; //打開庫SCHOOL
create table teacher //建立表TEACHER
(
  id int(3) auto_increment not null primary key,
  name char(10) not null,
  address varchar(50) default ‘深圳',
  year date
); //建表結束
//以下為插入字段
insert into teacher values(”,'allen','大連一中','1976-10-10′);
insert into teacher values(”,'jack','大連二中','1975-12-23′);

MYSQL必讀
  mysql -uroot -p暗碼 < c:\\school.sql

MYSQL必讀
drop database if exists school; //如果存在SCHOOL則刪除
create database school; //建立庫SCHOOL
use school; //打開庫SCHOOL
create table teacher //建立表TEACHER
(
  id int(3) auto_increment not null primary key,
  name char(10) not null,
  address varchar(50) default ''深圳'',
  year date
); //建表結束
//以下為插入字段
insert into teacher values('''',''glchengang'',''深圳一中'',''1976-10-10'');
insert into teacher values('''',''jack'',''深圳一中'',''1975-12-23'');