mysql语法
创建数据库
mysql> create database scholl;
Query OK, 1 row affected (0.00 sec)
查看数据库
show databases;
进入数据库
mysql> use scholl;
Database changed
创建表,字段类型,字段名
mysql> create table ?sjf(id int primary key ?auto_increment, name varchar (20));
Query OK, 0 rows affected (0.40 sec)
查看所在数据库
mysql> select database();
查看表结构
mysql> desc sjf;
+-------+-------------+------+-----+---------+----------------+
| Field | Type ? ? ? ?| Null | Key | Default | Extra ? ? ? ? ?|
+-------+-------------+------+-----+---------+----------------+
| id ? ?| int ? ? ? ? | NO ? | PRI | NULL ? ?| auto_increment |
| name ?| varchar(20) | YES ?| ? ? | NULL ? ?| ? ? ? ? ? ? ? ?|
+-------+-------------+------+-----+---------+----------------+
2 rows in set (0.10 sec)
查看表的语法
mysql> show create table sjf;
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?|
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| sjf ? | CREATE TABLE `sjf` (
? `id` int NOT NULL AUTO_INCREMENT,
? `name` varchar(20) DEFAULT NULL,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.02 sec)
插入数据
mysql> INSERT INTO sjf (name) VALUES ('张三');
Query OK, 1 row affected (0.00 sec)
?
mysql> INSERT INTO sjf (name) VALUES ('张无忌');
Query OK, 1 row affected (0.01 sec)
查看插入的数据
mysql> select * from sjf ;
+----+-----------+
| id | name ? ? ?|
+----+-----------+
| ?1 | 张三 ? ? ?|
| ?2 | 张无忌 ? ?|
+----+-----------+
2 rows in set (0.00 sec)
?