DDL中的数据表操作以及DML部分表内容增删;
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mydb1 |
| mysql |
| performance_schema |
| sys |
| test |
| test_gbk |
+--------------------+
7 rows in set (0.01 sec)
mysql> DROP DATABASE mydb1;
Query OK, 1 row affected (0.03 sec)
mysql> Terminal close -- exit!
mysql> **#DDL中的数据表操作以及DML部分表内容增删;**
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test |
| test_gbk |
+--------------------+
6 rows in set (0.01 sec)
mysql> CREATE DATABASE mydb1;#创建mydb1数据库;
Query OK, 1 row affected (0.00 sec)
mysql> SHOW CREATE DATABASE mydb1;#查看已创建mydb1数据库的编码方式;
+----------+----------------------------------------------------------------+
| Database | Create Database |
+----------+----------------------------------------------------------------+
| mydb1 | CREATE DATABASE `mydb1` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+----------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> #utf8支持中文;
mysql> USE mydb1;#打开需要使用的数据库;
Database changed
mysql> SELECT DATABASE;#得到当前打开的数据库;
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 '' at line 1
mysql> SELECT DATABASE mydb1;#得到当前打开的数据库;
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 'mydb1' at line 1
mysql> SELECT DATABASE ();#得到/查看当前打开的数据库;
+-------------+
| DATABASE () |
+-------------+
| mydb1 |
+-------------+
1 row in set (0.00 sec)
mysql> SHOW TABLES;#查看当前数据库中已有的数据表;
Empty set (0.00 sec)
mysql> #创建st表;
mysql> CREATE TABLE IF NOT EXISTS st(
-> id VARCHAR(20),#字符串型id字段
-> name VARCHAR(20) not null,#字符串型name字段
-> age INT(3) not null#整数型age字段
-> );
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 ',
name VARCHAR(20) not null,
age INT(3) not null
)' at line 2
mysql> CREATE TABLE IF NOT EXISTS st(
-> id VARCHAR(20),
-> name VARCHAR(20) not null,
-> age INT(3) not null
-> );
Query OK, 0 rows affected (0.05 sec)
mysql> #括号内为同一命令行,不能插入注释;
mysql> SHOW TABLES;#查看当前数据库中已有的数据表,应该已经有st数据库;
+-----------------+
| Tables_in_mydb1 |
+-----------------+
| st |
+-----------------+
1 row in set (0.00 sec)
mysql> #表中插入数据;
mysql> INSERT INTO st VALUES('1','王',12);#插入一行;
Query OK, 1 row affected (0.01 sec)
mysql> SELECT * FROM st;#查看表中记录;
+------+------+-----+
| id | name | age |
+------+------+-----+
| 1 | 王 | 12 |
+------+------+-----+
1 row in set (0.00 sec)
mysql> INSERT INTO st VALUES('2','