到mysql的目录
首先启动mysql服务器
cd mysql
cd bin
mysql
>use mysql
>select * from users;
>create database myd;
>use myd;
>create table test (.....);
>select * from test;
>quit;
exit
首先启动mysql服务器
cd mysql
cd bin
mysql
>use mysql
>select * from users;
>create database myd;
>use myd;
>create table test (.....);
>select * from test;
>quit;
exit
delete from table_name where filds_name=''
修改某一行
update table_name set filds_name='',filds_name='',.... where 条件(如:name='XXX')
修改密码
update user set password=PASSWORD('new_pass') where username='XXX'
上面一行修改了用户名为XXX的连接密码
备份:
mysqldump -u root -p 库名>自定义文件名.sql
会要求输入密码的。
还是好好学学!!
http://21van.51.net/teach/mysql.chm
http://linuxaid.com.cn/download/support/mysql/manual_toc.html http://linuxaid.com.cn/download/support/Manual_MySQL.zip