SQL的学习 し

上篇文章说明了怎样创建数据库，当一个数据库建立好之后，往数据库里面添加数据也是必要的。

下面就说明了怎样往数据库里面添加数据。

这一开始的在5.0版本下全报错了。

mysql> insert int vipmessages(name,pwd,Email,Age,Birthday,Sex) values
    -> ('kresnik','123456','kresnik.jun@163.com',20,19910801,0);
ERROR 1064 (42000): You have an error in your SQL syntax; check the 

manual that
corresponds to your MySQL server version for the right syntax to use 

near 'int vipmessages(name,pwd,Email,Age,Birthday,Sex) values
('kresnik','123456','kre' at line 1

//引号问题
mysql> insert int vipmessages(name,pwd,Email,Age,Birthday,Sex) values
    -> ('kresnik','123456','kresnik.jun@163.com','20','19910801','0');
ERROR 1064 (42000): You have an error in your SQL syntax; check the 

manual that
corresponds to your MySQL server version for the right syntax to use 

near 'int vipmessages(name,pwd,Email,Age,Birthday,Sex) values
('kresnik','123456','kre' at line 1

//引号问题
mysql> insert int vipmessages(name,pwd,Email,Age,Birthday,Sex) values
    -> (kresnik,123456,kresnik.jun@163.com,20,19910801,0);
ERROR 1064 (42000): You have an error in your SQL syntax; check the 
manual tha corresponds to your MySQL server version for the right syntax to use 

near 'int vipmessages(name,pwd,Email,Age,Birthday,Sex) values
(kresnik,123456,kresnik.' at line 1

 

到了这里，往数据库里面插入数据的任务也就圆满完成了。

mysql> insert into vipmessages(name,pwd,Email,Age,Birthday,Sex) 
values
    -> ('kresnik','123456','kresnik.jun@163.com',20,19910801,0);
Query OK, 1 row affected (0.15 sec)

mysql> insert into vipmessage(name,pwd,Email) values
    -> ('D','123','123456@gmail.com');
ERROR 1146 (42S02): Table 'sjpractice.vipmessage' doesn't exist
mysql> insert into vipmessages(name,pwd,Email) values
    -> ('D','123','123456@gmail.com');
Query OK, 1 row affected (0.00 sec)

 

然后查看表格就见附件。