mysql创建新的数据库命令有哪些内容呢
网站编辑2023-06-23 10:05:16515
- CREATE DATABASE语句：
CREATE DATABASE shili -m "%shili%" % database;
- SHOW DATABASES语句：
mysql -u 用户名 -p 密码；
- MYSQL -J 连接到数据库：
MYSQL -u 用户名 -p 密码 -c 连接数据库；
- 创建表格：
CREATE TABLE student
(
id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
age INT(25) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
gender VARCHAR(20) NOT NULL,
address VARCHAR(20) NOT NULL
);
- 创建表格：
CREATE TABLE student
(
name VARCHAR(50) NOT NULL,
age INT(25) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
gender VARCHAR(20) NOT NULL,
address VARCHAR(20) NOT NULL
);
- 插入数据：
INSERT INTO students (name, age, gender) VALUES (1, "Tom", 25, "Male");
- 删除数据：
DELETE FROM students
WHERE id = 1;
- 查询数据：
SELECT name, age, gender, address
FROM students
GROUP BY name, age, gender;
- 更新数据：
UPDATE students
SET age = 25
WHERE id = 1;
- 删除数据：
DELETE FROM students
WHERE id = 1;
