建立一张表: 表里面有多个字段,每一个字段对应一种数据类型 注意:表名,字段名都要起的有意义
通过win+R--cmd--mysql -uroot -p-------启动服务器
1、首先,创建名为“mydb”的数据库
mysql> CREATE DATABASE mydb;
2、切换到“mydb”数据库
mysql> USE mydb;
3、创建名为“user_info”的表,包含不同的字段和数据类型(这里包含了用户名、性别、年龄、电子邮件、注册日期)
mysql> CREATE TABLE user_info (
-> user_id INT AUTO_INCREMENT PRIMARY KEY,
-> username VARCHAR(30),
-> gender VARCHAR(10),
-> age INT,
-> email VARCHAR(100),
-> registration_date DATE
-> );
4、向表中插入数据
mysql> INSERT INTO mydb.user_info (username,gender,age,email,registration_date)
-> VALUES
-> ('xiaoming','nan',20,'xm666@qq.com','2023-08-05'),
-> ('xiaohong','nu',19,'xh888@qq.com','2023-08-05');
5*、可选用ENUM(枚举类型)来限制性别值
mysql> UPDATE mydb.user_info
-> SET gender = 'Male'
-> WHERE user_id = 1;
mysql> UPDATE mydb.user_info
-> SET gender = 'Female'
-> WHERE user_id = 2;
6、执行查询
mysql> SELECT * FROM mydb.user_info;
+---------+----------+--------+------+--------------+-------------------+
| user_id | username | gender | age | email | registration_date |
+---------+----------+--------+------+--------------+-------------------+
| 1 | xiaoming | Male | 20 | xm666@qq.com | 2023-08-05 |
| 2 | xiaohong | Female | 19 | xh888@qq.com | 2023-08-05 |
+---------+----------+--------+------+--------------+-------------------+
所有执行完毕!看到这里,相信你一定会有所收获!