SQL的学习 し

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

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

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

mysql> insert int vipmessages(name,pwd,Email,Age,Birthday,Sex) values
    -> ('kresnik','123456','[e-mail]',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','[e-mail]','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,[e-mail],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','[e-mail]',20,19910801,0);
Query OK, 1 row affected (0.15 sec)

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

 

然后查看表格就见附件。

评论

2 楼 吸血鬼猎人 2011-03-12  

贾懂凯 写道

你可以直接将图片插入文章主体中！

小懂啊！我宿舍网速不给力……所以直接粘贴过来了……

1 楼 贾懂凯 2011-03-10  

你可以直接将图片插入文章主体中！