Mysql操作
(注意:黑体为系统关键字部分,斜体为用户可变部分)
基本操作 | |
登陆 | Mysql –u root –p 123456 (在bin目录下执行命令,其中root为用户名,123456为密码) |
创建数据库 | create database dataBaseName; |
选择数据库 | Use dataBaseName |
删除数据库 | Drop database databaseName; |
创建表 | create table tableName ( ID int not null auto_increment, stuID int, courseID int , RMTime TIMESTAMP, primary key (ID), ); |
向表中插入信息 | INSERT INTO tableName VALUES (1,'admin','admin'); (注意字段类型为数字的就直接用数字,为字符的要加上单引号) |
选取信息 | 1、 select * from tableName; 2、 select itemName from tableName; 3、 select itemName1,itemName2 from tableName; |
4、 select * from tableName where itemName = name; (注意要是字段为字符则要加单引号) 5、 select * from tableName where itemName1 = name1 and itemName2 = name2; | |
6、 SELECT t1.name, t2.salary FROM tableName1 AS t1, tableName2 AS t2 WHERE t1.name = t2.name; 7、 SELECT t1.name, t2.salary FROM tableName1 t1, tableName2 t2 WHERE t1.name = t2.name; 8、 Select itemName as name from tableName;(将输出项更名) | |
9、 Select itemName from tableName having name;(选取的条件为是否存在指定字段) 10、Select itemName from tableName having name > 10;(选取条件为指定条件) | |
11、select itemName from tableName limit m; m(为返回记录的最大数目) 12、select itemName from tableName limit n,m;(n为要返回的记录的第一行的偏移量,m为返回记录的最大数目) | |
13、select * into Outfile ‘fileName.sql’ from tableName;(从数据库中导出信息到文件中) | |
修改表结构 |
|
删除表 | Drop table tableName; |
恢复数据 | 1、 load data infile ‘fileName.sql’ into table tableName;(从文件导入信息到数据库表中) 2、 mysqladmin –u root –p 123456 create dataBaseName |
另外,详细语法请参考:mysql语法手册.htm,
更多参考:http://www.moon-soft.com/program/book/mysql/index.html
http://www.linuxforum.net/books/mysqlmanual/manual_toc.html