mysql学习记录（五）数据操作

快来打我* 2023-06-16 02:22 8阅读 0赞

### mysql学习记录（五）数据操作 ###

*   *   *  表的结构
         *  数据产生
         *  插入数据
         *  数据删除
         *  数据修改

### 表的结构 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70]

### 数据产生 ###

利用[Mockaroo][]产生随机数据  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70 1]

### 插入数据 ###

insert into 基本表名 [(列名表)] values (元组值);//单个元组值
    insert into  基本表名 [(列名表)]values (元组值) ……， (元组值);//多个元组值

利用上面网站产生的随机数据

insert into tb_student (id, username, password, name, sex, email, phone, birthday) values (1, 'Bryanty', 'zWiXvOHhu1yD', '远帆', '女', 'bbrennans0@miitbeian.gov.cn', '521-134-5049', '1984-07-08 15:36:56');
    insert into tb_student (id, username, password, name, sex, email, phone, birthday) values (2, 'Casi', 'dH3zoN', '博裕', '男', 'ctracey1@linkedin.com', '327-407-0719', '1981-04-10 23:47:48');
    insert into tb_student (id, username, password, name, sex, email, phone, birthday) values (3, 'Marmaduke', 'e0CvL3vS5', '韵寒', '男', 'mstonard2@g.co', '930-650-1546', '1998-07-08 16:33:07');
    insert into tb_student (id, username, password, name, sex, email, phone, birthday) values (4, 'Nickolas', 'uvb6j2C7GAs', '惠茜', '男', 'npensom3@jalbum.net', '586-768-9745', '1990-07-09 16:20:57');
    insert into tb_student (id, username, password, name, sex, email, phone, birthday) values (5, 'Karolina', '9HL3jRh2', '梓彤', '男', 'kcoulston4@npr.org', '344-327-9276', '1999-11-25 02:34:35');
    insert into tb_student (id, username, password, name, sex, email, phone, birthday) values (6, 'Tabbitha', 'l5aqtiv53', '宸瑜', '女', 'tnewcombe5@vistaprint.com', '541-888-7443', '1998-12-02 11:24:12');
    insert into tb_student (id, username, password, name, sex, email, phone, birthday) values (7, 'Kriste', '9miLwuviO6i', '美莲', '男', 'kswinburn6@geocities.com', '630-206-1312', '1983-12-05 06:19:06');
    insert into tb_student (id, username, password, name, sex, email, phone, birthday) values (8, 'Morty', 'k5UCSzV', '婧涵', '女', 'mcain7@bing.com', '214-735-8336', '2002-12-22 06:23:49');
    insert into tb_student (id, username, password, name, sex, email, phone, birthday) values (9, 'Gavin', 'nqF1r3BJBrP', '博裕', '男', 'gluker8@mozilla.com', '697-547-6799', '1998-05-04 00:57:27');
    insert into tb_student (id, username, password, name, sex, email, phone, birthday) values (10, 'Adolph', 'eR8OUTk', '永鑫', '男', 'amcgougan9@toplist.cz', '462-360-3685', '1983-08-26 01:01:08');

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70 2]

### 数据删除 ###

delete  from  基本表名[WHERE 条件表达式];//

### 数据修改 ###

update 基本表名
    set 列名=值表达式[,列名=值表达式…]│row=(元组)
    [where 条件表达式];

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191123203312195.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw,size_16,color_FFFFFF,t_70
[Mockaroo]: https://www.mockaroo.com
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191123202806679.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20191123203322673.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw,size_16,color_FFFFFF,t_70