MySQL基本简单操作

 

 

itnetcn@SL400:~$ mysql -u root -p  #登录数据库

 

mysql> CREATE DATABASE ApingDB; #创建数据库

 

mysql> show databases;  #查看数据库

+--------------------+

| Database           |

+--------------------+

| ApingDB            |

+--------------------+

 

mysql> use itnetcnDB;     #选中数据库

 

mysql> CREATE TABLE Nikon (time DATE,PriceA INT,PriceB INT);  #创建表与字段

 

mysql> INSERT INTO Nikon values("2013-10-10","3199","3988");  #增加数据

mysql> INSERT INTO Nikon values("2013-10-09","3199","3988");  #增加数据

 

mysql> SELECT * FROM Nikon;   #查询表中数据

+------------+--------+--------+

| time       | PriceA | PriceB |

+------------+--------+--------+

| 2013-10-10 |   3199 |   3988 |

| 2013-10-09 |   3199 |   3988 |

+------------+--------+--------+

 

mysql> UPDATE Nikon set PriceB="4000" where time="2013-10-10";  #更改数据(将2013-1010的PriceB数据更改4000)

 

mysql> DELETE FROM Nikon WHERE time="2013-10-10";  #删除数据 (删除2013-10-10的一条数据)