以升序或降序显示选定的记录。
|
mysql> SELECT [col1],[col2] FROM [table name] ORDER BY [col2] DESC;
|
返回行数。
|
mysql> SELECT COUNT(*) FROM [table name];
|
统计指定列值的总和。
|
mysql> SELECT SUM(*) FROM [table name];
|
联结表。
|
mysql> select lookup.illustrationid, lookup.personid,person.birthday from lookup left join person on lookup.personid=person.personid=statement to join birthday in person table with primary illustration id;
|
新建一个用户。以root登录。切换到mysql数据库，创建用户，刷新权限。
|
# mysql -u root -p
mysql> use mysql;
mysql> INSERT INTO user (Host,User,Password) VALUES('%','username',PASSWORD('password'));
mysql> flush privileges;
|
从unix命令行更改用户密码。
|
# [mysql dir]/bin/mysqladmin -u username -h hostname.blah.org -p password 'new-password'
|
从mysql命令行更改用户密码。以root登录，设置密码，更新权限。
|
# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables &
# mysql -u root
|
|
mysql> use mysql;
mysql> update user set password=PASSWORD("newrootpassword") where User='root';
mysql> flush privileges;
mysql> quit
|
|
# /etc/init.d/mysql stop
# /etc/init.d/mysql start
|
|
# mysqladmin -u root password newpassword
|
|
# mysqladmin -u root -p oldpassword newpassword
|
允许用户“bob”从localhost以密码“passwd”连接服务器。以root登录，切换mysql数据库。设置权限，更新权限。
|
mysql> use mysql;
mysql> grant usage on *.* to bob@localhost identified by 'passwd';
mysql> flush privileges;
|
如果不想手工输入密码 请使用--password 参数
|
mysqldump -h database_ip -u Username --password=123456 --opt databasename > backup-file.sql
mysqldump -h database_ip -d -u Username --password=123456 databasename >database_structure.sql
|
为数据库db设置权限。以root登录，切换到mysql数据库，授予权限，更新权限。
|
mysql> use mysql;
mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) VALUES ('%','databasename','username','Y','Y','Y','Y','Y','N');
mysql> flush privileges;
|
