Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All 
rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or 
its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current 
input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| hwgk_db            |
| mysql              |
| zrcx_db            |
+--------------------+
4 rows in set (0.00 sec)

mysql> user zrcx_db;
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 'user
zrcx_db' at line 1
mysql> use zrcx_db;
Database changed
mysql> selet * from tb_test;
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 'selet
 * from tb_test' at line 1
mysql> select * from tb_test;
Empty set (0.04 sec)

mysql> insert into tb_test(id,firstname,lastname,email,phone) 
values(id,'lining'
,'aa','aa@qq.com','123353');
Query OK, 1 row affected (0.00 sec)

mysql> select * from tb_test;
+----+-----------+----------+-----------+--------+
| id | firstname | lastname | email     | phone  |
+----+-----------+----------+-----------+--------+
|  1 | lining    | aa       | aa@qq.com | 123353 |
+----+-----------+----------+-----------+--------+
1 row in set (0.00 sec)

mysql> insert into tb_test(id,firstname,lastname,email,phone) 
values(id,'lining'
,'aa','aa@qq.com','123353');
Query OK, 1 row affected (0.01 sec)

mysql> select * from tb_test;
+----+-----------+----------+-----------+--------+
| id | firstname | lastname | email     | phone  |
+----+-----------+----------+-----------+--------+
|  1 | lining    | aa       | aa@qq.com | 123353 |
|  2 | lining    | aa       | aa@qq.com | 123353 |
+----+-----------+----------+-----------+--------+
2 rows in set (0.00 sec)

mysql> delete from tb_test where id=2;
Query OK, 1 row affected (0.10 sec)

mysql> select * from tb_test;
+----+-----------+----------+-----------+--------+
| id | firstname | lastname | email     | phone  |
+----+-----------+----------+-----------+--------+
|  1 | lining    | aa       | aa@qq.com | 123353 |
+----+-----------+----------+-----------+--------+
1 row in set (0.00 sec)
 

  • 3
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值