mysql 学习记录（一）--建表，增加，删除，修改，基本查询

最新推荐文章于 2023-10-09 22:14:26 发布
最新推荐文章于 2023-10-09 22:14:26 发布
阅读量1.4k 收藏 4
点赞数 1
分类专栏： mysql mysql学习 文章标签： mysql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/bwshqh/article/details/48844723
版权 
1.建立数据库
mysql> create database test1;
Query OK, 1 row affected (0.02 sec)

2.建立了数据再建立，则：
mysql> create database test1;
ERROR 1007 (HY000): Can't create database 'test1'; database exists

3.显示数据库信息：
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
| test1              |
+--------------------+
5 rows in set (0.05 sec)

4.进入数据库
mysql> use test1;
Database changed

5.显示表中的数据库：
mysql> show tables;
Empty set (0.00 sec)

6.删除数据库：
mysql> drop database test1;
Query OK, 0 rows affected (0.07 sec)

7.建立表：
mysql> create database test1;
Query OK, 1 row affected (0.01 sec)
mysql> use test1;
Database changed
mysql> create table emp(ename varchar(10), hiredate date , sal decimal(10,2), deptno int(2));
Query OK, 0 rows affected (0.05 sec)
mysql> desc emp;
+----------+---------------+------+-----+---------+-------+
| Field    | Type          | Null | Key | Default | Extra |
+----------+---------------+------+-----+---------+-------+
| ename    | varchar(10)   | YES  |     | NULL    |       |
| hiredate | date          | YES  |     | NULL    |       |
| sal      | decimal(10,2) | YES  |     | NULL    |       |
| deptno   | int(2)        | YES  |     | NULL    |       |
+----------+---------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

8.显示DDL语句：
mysql> show create table emp \G;
*************************** 1. row ***************************
       Table: emp
Create Table: CREATE TABLE `emp` (
  `ename` varchar(10) DEFAULT NULL,
  `hiredate` date DEFAULT NULL,
  `sal` decimal(10,2) DEFAULT NULL,
  `deptno` int(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

ERROR: 
No query specified

9.删除表：
mysql> drop table emp;
Query OK, 0 rows affected (0.01 sec)

10.修改表字段名称，删除表字段
mysql> create table emp(ename varchar(10), hiredate date , sal decimal(10,2), deptno int(2));\
Query OK, 0 rows affected (0.03 sec)

mysql> desc emp;
+----------+---------------+------+-----+---------+-------+
| Field    | Type          | Null | Key | Default | Extra |
+----------+---------------+------+-----+---------+-------+
| ename    | varchar(10)   | YES  |     | NULL    |       |
| hiredate | date          | YES  |     | NULL    |       |
| sal      | decimal(10,2) | YES  |     | NULL    |       |
| deptno   | int(2)        | YES  |     | NULL    |       |
+----------+---------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> alter table emp modify ename varchar(20);
Query OK, 0 rows affected (0.05 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc emp;
+----------+---------------+------+-----+---------+-------+
| Field    | Type          | Null | Key | Default | Extra |
+----------+---------------+------+-----+---------+-------+
| ename    | varchar(20)   | YES  |     | NULL    |       |
| hiredate | date          | YES  |     | NULL    |       |
| sal      | decimal(10,2) | YES  |     | NULL    |       |
| deptno   | int(2)        | YES  |     | NULL    |       |
+----------+---------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> alter table emp add column age int(3);
Query OK, 0 rows affected (0.06 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc emp;
+----------+---------------+------+-----+---------+-------+
| Field    | Type          | Null | Key | Default | Extra |
+----------+---------------+------+-----+---------+-------+
| ename    | varchar(20)   | YES  |     | NULL    |       |
| hiredate | date          | YES  |     | NULL    |       |
| sal      | decimal(10,2) | YES  |     | NULL    |       |
| deptno   | int(2)        | YES  |     | NULL    |       |
| age      | int(3)        | YES  |     | NULL    |       |
+----------+---------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> alter table emp drop column age;
Query OK, 0 rows affected (0.06 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc emp;
+----------+---------------+------+-----+---------+-------+
| Field    | Type          | Null | Key | Default | Extra |
+----------+---------------+------+-----+---------+-------+
| ename    | varchar(20)   | YES  |     | NULL    |       |
| hiredate | date          | YES  |     | NULL    |       |
| sal      | decimal(10,2) | YES  |     | NULL    |       |
+----------+---------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> alter table emp change age age1 int(4);
ERROR 1054 (42S22): Unknown column 'age' in 'emp'
mysql> alter table emp change sal sal_salart int(4);
Query OK, 0 rows affected (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc emp;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| ename      | varchar(20) | YES  |     | NULL    |       |
| hiredate   | date        | YES  |     | NULL    |       |
| sal_salart | int(4)      | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

11.修改表字段顺序：
mysql> alter table emp add birth date after ename;
Query OK, 0 rows affected (0.05 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table emp add testColumn date after ename;
Query OK, 0 rows affected (0.08 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc emp;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| ename      | varchar(20) | YES  |     | NULL    |       |
| testColumn | date        | YES  |     | NULL    |       |
| birth      | date        | YES  |     | NULL    |       |
| hiredate   | date        | YES  |     | NULL    |       |
| sal_salart | int(4)      | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> alter table emp modify sal_salart int(5) first;
Query OK, 0 rows affected (0.06 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc emp;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| sal_salart | int(5)      | YES  |     | NULL    |       |
| ename      | varchar(20) | YES  |     | NULL    |       |
| testColumn | date        | YES  |     | NULL    |       |
| birth      | date        | YES  |     | NULL    |       |
| hiredate   | date        | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> alter table emp rename emp_test;
Query OK, 0 rows affected (0.01 sec)

12.增加字段：
mysql> alter table emp_test add column age int(3);
Query OK, 0 rows affected (0.05 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc emp_test;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| sal_salart | int(5)      | YES  |     | NULL    |       |
| ename      | varchar(20) | YES  |     | NULL    |       |
| testColumn | date        | YES  |     | NULL    |       |
| birth      | date        | YES  |     | NULL    |       |
| hiredate   | date        | YES  |     | NULL    |       |
| age        | int(3)      | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> alter table emp_test rename test;
Query OK, 0 rows affected (0.01 sec)

13.插入数据：
mysql> use test1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> insert into test(ename,age) values('abc',3);
Query OK, 1 row affected (0.01 sec)

mysql> select * from test;
+------------+-------+------------+-------+----------+------+
| sal_salart | ename | testColumn | birth | hiredate | age  |
+------------+-------+------------+-------+----------+------+
|       NULL | abc   | NULL       | NULL  | NULL     |    3 |
+------------+-------+------------+-------+----------+------+
1 row in set (0.00 sec)

mysql> insert into test(ename,age) values('abc',3),('def',9);
Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select * from test;
+------------+-------+------------+-------+----------+------+
| sal_salart | ename | testColumn | birth | hiredate | age  |
+------------+-------+------------+-------+----------+------+
|       NULL | abc   | NULL       | NULL  | NULL     |    3 |
|       NULL | abc   | NULL       | NULL  | NULL     |    3 |
|       NULL | def   | NULL       | NULL  | NULL     |    9 |
+------------+-------+------------+-------+----------+------+
3 rows in set (0.00 sec)

14.修改数据：
mysql> update test set age = 8 where ename = 'def';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from test;
+------------+-------+------------+-------+----------+------+
| sal_salart | ename | testColumn | birth | hiredate | age  |
+------------+-------+------------+-------+----------+------+
|       NULL | abc   | NULL       | NULL  | NULL     |    3 |
|       NULL | abc   | NULL       | NULL  | NULL     |    3 |
|       NULL | def   | NULL       | NULL  | NULL     |    8 |
+------------+-------+------------+-------+----------+------+
3 rows in set (0.00 sec)

mysql> update test set age = 8 where ename = 'def22222222';
Query OK, 0 rows affected (0.01 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> select * from test;
+------------+-------+------------+-------+----------+------+
| sal_salart | ename | testColumn | birth | hiredate | age  |
+------------+-------+------------+-------+----------+------+
|       NULL | abc   | NULL       | NULL  | NULL     |    3 |
|       NULL | abc   | NULL       | NULL  | NULL     |    3 |
|       NULL | def   | NULL       | NULL  | NULL     |    8 |
+------------+-------+------------+-------+----------+------+
3 rows in set (0.00 sec)

mysql> update test set age = 81 where ename = 'def22222222';
Query OK, 0 rows affected (0.01 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> select * from test;
+------------+-------+------------+-------+----------+------+
| sal_salart | ename | testColumn | birth | hiredate | age  |
+------------+-------+------------+-------+----------+------+
|       NULL | abc   | NULL       | NULL  | NULL     |    3 |
|       NULL | abc   | NULL       | NULL  | NULL     |    3 |
|       NULL | def   | NULL       | NULL  | NULL     |    8 |
+------------+-------+------------+-------+----------+------+
3 rows in set (0.00 sec)

mysql> update test set age = 81 where ename = 'def';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from test;
+------------+-------+------------+-------+----------+------+
| sal_salart | ename | testColumn | birth | hiredate | age  |
+------------+-------+------------+-------+----------+------+
|       NULL | abc   | NULL       | NULL  | NULL     |    3 |
|       NULL | abc   | NULL       | NULL  | NULL     |    3 |
|       NULL | def   | NULL       | NULL  | NULL     |   81 |
+------------+-------+------------+-------+----------+------+
3 rows in set (0.00 sec)

15.删除数据
mysql> delete from test where age = 3;
Query OK, 2 rows affected (0.00 sec)

mysql> select * from test;
+------------+-------+------------+-------+----------+------+
| sal_salart | ename | testColumn | birth | hiredate | age  |
+------------+-------+------------+-------+----------+------+
|       NULL | def   | NULL       | NULL  | NULL     |   81 |
+------------+-------+------------+-------+----------+------+
1 row in set (0.00 sec)

mysql> insert test(ename,age) values ('aaaaa',3),('aaaaa',5),('ccccc',3), ('aaaaa',9), ('ttttt',2);
Query OK, 5 rows affected (0.01 sec)
Records: 5  Duplicates: 0  Warnings: 0

mysql> select * from test;
+------------+-------+------------+-------+----------+------+
| sal_salart | ename | testColumn | birth | hiredate | age  |
+------------+-------+------------+-------+----------+------+
|       NULL | def   | NULL       | NULL  | NULL     |   81 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    3 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    5 |
|       NULL | ccccc | NULL       | NULL  | NULL     |    3 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    9 |
|       NULL | ttttt | NULL       | NULL  | NULL     |    2 |
+------------+-------+------------+-------+----------+------+
6 rows in set (0.00 sec)

16.查询数据：
mysql> alter table test rename test_col;
Query OK, 0 rows affected (0.01 sec)

mysql> select * from test_col;
+------------+-------+------------+-------+----------+------+
| sal_salart | ename | testColumn | birth | hiredate | age  |
+------------+-------+------------+-------+----------+------+
|       NULL | def   | NULL       | NULL  | NULL     |   81 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    3 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    5 |
|       NULL | ccccc | NULL       | NULL  | NULL     |    3 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    9 |
|       NULL | ttttt | NULL       | NULL  | NULL     |    2 |
+------------+-------+------------+-------+----------+------+
6 rows in set (0.00 sec)

mysql> alter table test_col rename test;
Query OK, 0 rows affected (0.01 sec)

mysql> select * from test;
+------------+-------+------------+-------+----------+------+
| sal_salart | ename | testColumn | birth | hiredate | age  |
+------------+-------+------------+-------+----------+------+
|       NULL | def   | NULL       | NULL  | NULL     |   81 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    3 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    5 |
|       NULL | ccccc | NULL       | NULL  | NULL     |    3 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    9 |
|       NULL | ttttt | NULL       | NULL  | NULL     |    2 |
+------------+-------+------------+-------+----------+------+
6 rows in set (0.00 sec)

mysql> selecdt distinct ename from test;
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 'selecdt distinct ename from test' at line 1
mysql> select distinct ename from test;
+-------+
| ename |
+-------+
| def   |
| aaaaa |
| ccccc |
| ttttt |
+-------+
4 rows in set (0.00 sec)

mysql> select * from test where ename = 'aaaaa';
+------------+-------+------------+-------+----------+------+
| sal_salart | ename | testColumn | birth | hiredate | age  |
+------------+-------+------------+-------+----------+------+
|       NULL | aaaaa | NULL       | NULL  | NULL     |    3 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    5 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    9 |
+------------+-------+------------+-------+----------+------+
3 rows in set (0.00 sec)

mysql> select * from test where age < 8;
+------------+-------+------------+-------+----------+------+
| sal_salart | ename | testColumn | birth | hiredate | age  |
+------------+-------+------------+-------+----------+------+
|       NULL | aaaaa | NULL       | NULL  | NULL     |    3 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    5 |
|       NULL | ccccc | NULL       | NULL  | NULL     |    3 |
|       NULL | ttttt | NULL       | NULL  | NULL     |    2 |
+------------+-------+------------+-------+----------+------+
4 rows in set (0.00 sec)

mysql> select * from test order by age;
+------------+-------+------------+-------+----------+------+
| sal_salart | ename | testColumn | birth | hiredate | age  |
+------------+-------+------------+-------+----------+------+
|       NULL | ttttt | NULL       | NULL  | NULL     |    2 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    3 |
|       NULL | ccccc | NULL       | NULL  | NULL     |    3 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    5 |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    9 |
|       NULL | def   | NULL       | NULL  | NULL     |   81 |
+------------+-------+------------+-------+----------+------+
6 rows in set (0.00 sec)

mysql> alter table test add column salart int (11);
Query OK, 6 rows affected (0.06 sec)
Records: 6  Duplicates: 0  Warnings: 0

mysql> alter table test change salart salary int (11);
Query OK, 6 rows affected (0.05 sec)
Records: 6  Duplicates: 0  Warnings: 0

mysql> select * from test;
+------------+-------+------------+-------+----------+------+--------+
| sal_salart | ename | testColumn | birth | hiredate | age  | salary |
+------------+-------+------------+-------+----------+------+--------+
|       NULL | def   | NULL       | NULL  | NULL     |   81 |   NULL |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    3 |   NULL |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    5 |   NULL |
|       NULL | ccccc | NULL       | NULL  | NULL     |    3 |   NULL |
|       NULL | aaaaa | NULL       | NULL  | NULL     |    9 |   NULL |
|       NULL | ttttt | NULL       | NULL  | NULL     |    2 |   NULL |
+------------+-------+------------+-------+----------+------+--------+
6 rows in set (0.00 sec)

mysql> insert into test(ename,age,salary) values  ('newNane1',1,100),
    -> ('newName2',3,80),
    -> ('newName3',5,10);
Query OK, 3 rows affected (0.01 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> select * from test;
+------------+----------+------------+-------+----------+------+--------+
| sal_salart | ename    | testColumn | birth | hiredate | age  | salary |
+------------+----------+------------+-------+----------+------+--------+
|       NULL | def      | NULL       | NULL  | NULL     |   81 |   NULL |
|       NULL | aaaaa    | NULL       | NULL  | NULL     |    3 |   NULL |
|       NULL | aaaaa    | NULL       | NULL  | NULL     |    5 |   NULL |
|       NULL | ccccc    | NULL       | NULL  | NULL     |    3 |   NULL |
|       NULL | aaaaa    | NULL       | NULL  | NULL     |    9 |   NULL |
|       NULL | ttttt    | NULL       | NULL  | NULL     |    2 |   NULL |
|       NULL | newNane1 | NULL       | NULL  | NULL     |    1 |    100 |
|       NULL | newName2 | NULL       | NULL  | NULL     |    3 |     80 |
|       NULL | newName3 | NULL       | NULL  | NULL     |    5 |     10 |
+------------+----------+------------+-------+----------+------+--------+
9 rows in set (0.00 sec)

mysql> select * from test order by salary;
+------------+----------+------------+-------+----------+------+--------+
| sal_salart | ename    | testColumn | birth | hiredate | age  | salary |
+------------+----------+------------+-------+----------+------+--------+
|       NULL | def      | NULL       | NULL  | NULL     |   81 |   NULL |
|       NULL | aaaaa    | NULL       | NULL  | NULL     |    3 |   NULL |
|       NULL | aaaaa    | NULL       | NULL  | NULL     |    5 |   NULL |
|       NULL | ccccc    | NULL       | NULL  | NULL     |    3 |   NULL |
|       NULL | aaaaa    | NULL       | NULL  | NULL     |    9 |   NULL |
|       NULL | ttttt    | NULL       | NULL  | NULL     |    2 |   NULL |
|       NULL | newName3 | NULL       | NULL  | NULL     |    5 |     10 |
|       NULL | newName2 | NULL       | NULL  | NULL     |    3 |     80 |
|       NULL | newNane1 | NULL       | NULL  | NULL     |    1 |    100 |
+------------+----------+------------+-------+----------+------+--------+
9 rows in set (0.00 sec)

mysql> select * from test order by salary limit 6,3;
+------------+----------+------------+-------+----------+------+--------+
| sal_salart | ename    | testColumn | birth | hiredate | age  | salary |
+------------+----------+------------+-------+----------+------+--------+
|       NULL | newName3 | NULL       | NULL  | NULL     |    5 |     10 |
|       NULL | newName2 | NULL       | NULL  | NULL     |    3 |     80 |
|       NULL | newNane1 | NULL       | NULL  | NULL     |    1 |    100 |
+------------+----------+------------+-------+----------+------+--------+
3 rows in set (0.00 sec)

bwshqh
关注
专栏目录
关于MySQL数据库常用SQL语句操作增、删、改、查，注释，模糊查询，多表联动，正则表达式
mengjie1016的博客
05-16 446
详解MySQL数据库常用sql语句操作增、删、改、查，注释，模糊查询，多表联动，正则表达式等 1.sql语句中的单行注释 2.多行注释 3. 新建数据库 4.删除数据库 5. 创建表 6.MySQL 删除数据表 7.MySQL 插入数据 8.MySQL 查询数据 9.MySQL UPDATE 更新记录 10.MySQL DELETE 语句删除记录 11.MySQL LIKE 子句 模糊查询 12.MySQL UNION 操作符  联合查询 13.MySQL 排序 14.MySQL GROUP BY 语句 1
用php在mysql的建库建表,使用phpStudy自带的mysql-front学习建库建表以及基本的mysql语句...
weixin_34660766的博客
03-29 1087
1、鼠标左键phpStudy图标，点击mysql管理器，如下图2、选择Mysql-Front，选择localhost进入，可以看到本地建立的数据库。然后新建一个数据库，如下图：3、在新建的数据库上鼠标右键->新建->表格，如下图4、新增字段，如下图5、建好表之后就是添加数据，添加是在每一栏上右键->插入记录6、数据库的一些基本语法：(1)增,在lqf_admin表中插入记录，可以...
MYSQL数据库的建表以及增删改查操作（更新ing）
liuzhenghui666666的博客
06-19 785
建表： 1.创建表 create table salary(id varchar(20),money int); 2.设置主键 alter table salary add primary key(id); 3.显示列名 desc salary; 4.显示列明更详细 show create table 表名; 5.更改表中某列的默认值 alter table salary alter mone...
MySQL中创建、删除表和库，添加、删除记录
weixin_34056162的博客
09-06 129
1.查看服务器中有哪些库mysql>show databases;初始化的MySQL服务器，默认包含了三个库：test,mysql和information_schema(其中mysql库中包含了用户认证相关的表)。2.查看库中有哪些表mysql>use mysql;mysql>show tables;MySQL数据库的数据文件默认存放在/usr/local/...
简单的建数据库以及建表
weixin_30469895的博客
07-09 122
首先在命令行下进入mysql，输入用户名和密码——：mysql -u用户名 -p密码 然后我们就可以建数据库了 首先看看你mysql中有没有数据库表——：show databases; 创建一个我们需要的数据库(例如数据库db) 现在我们继续在数据库中创建表 此时我们的数据库，表都创建成功了 《《以上就是数据库以及表的建立等，还有其它sql语句操作MySQ...
MySQL基础语句
code_peak
11-21 301
SQL 是 Structure Query Language（结构化查询语言）的缩写，它是使用关系模型的数据库应用语言，由 IBM 在 20 世纪 70 年代开发出来，作为 IBM 关系数据库原型 System R 的原型关系语言，实现了关系数据库中的信息检索。
mysql代码-建库建表语句
07-14
最后，`DELETE FROM` 语句用于删除记录，例如解雇员工： ```sql DELETE FROM employees WHERE name = '张三'; ``` 以上就是关于MySQL中创建数据库和表格的基本操作。在实际开发中，还需要了解更多的SQL语法，如...
AI提示词从小白到专家系列-批量生成建表语句
最新发布
matlab5186688的专栏
10-09 114
AI提示词从小白到专家系列
linux mysql 创建表_Linux下，MySQL-安装，登录和建表
weixin_36400198的博客
02-26 2824
一、安装1、首先检查机器是否已经安装MySQL输入：rpm -qa | grep mysql2、去官网下载相应的rpm包下载：mysql-community-libs-5.7.23-1.el7.x86_64.rpmmysql-community-server-5.7.23-1.el7.x86_64.rpmmysql-community-common-5.7.23-1.el7.x86_64.rpmm...
egg mysql 连表查询,使用egg-mysql操作mysql数据库
weixin_42433737的博客
03-19 1384
1、安装mysqlnpm i egg-mysql -S2、在config/plugin.js里声明改插件exports.mysql = {enable: true,package: 'egg-mysql',};3、在config/config.default.js里配置config.mysql = {// 单数据库信息配置client: {// hosthost: 'localhost',// 端...
数据库设计（二）——简单设计实例
zam183的博客
02-25 4万+
Mysql设计步骤 一、设计一套系统数据库的步骤         1、实现什么样的功能（保证项目功能的完整性，列出所有模块）。         2、通过思维导图将每个功能模块串联起来（放射状，细节可以用文字描述）。         3、数据库需求分析                 1）、内容要求：调查应用系统用户所需要操作的数据，在数据库中该存储什么数据。                 2...
错误代码： 1007 Can't create database 'test'; database exists
热门推荐
游海东的技术专栏
09-16 6万+
1、错误描述1 queries executed, 0 success, 1 errors, 0 warnings 查询：create database test 错误代码： 1007 Can't create database 'test'; database exists 执行耗时 : 0 sec 传送时间 : 0 sec2、错误原因    执行创建数据库时，两次执行了同一SQL
mysql错误：ERROR 1007 (HY000): Can‘t create database ‘test‘； database exists
le_slie__的博客
12-29 4万+
mysql错误：ERROR 1007 (HY000): Can’t create database ‘test’; database exists 1 错误描述： 创建数据库时： create database test; 出现： ERROR 1007 (HY000): Can’t create database ‘test’; database exists 2 错误原因： 执行创建数据库时，两次执行了同一SQL语句，导致重复创建数据库 3 解决办法： 不执行该语句 如果test创建错误，
[Err] 1007 - Can‘t create database ‘bug‘； database exists！
qq_52060364的博客
06-08 1万+
首先，写SQL语句的第一步是创建数据库
mysql+add+column+int_MySQL添加列
weixin_36400833的博客
02-07 706
在本教程中，我们将向您展示如何使用MySQL ADD COLUMN语句将列添加到表中。MySQL ADD COLUMN语句简介要向现有表添加新列，请按如下所示使用ALTER TABLE ADD COLUMN语句：首先，在ALTER TABLE子句之后指定表名。其次，将新列及其定义放在ADD COLUMN子句之后。 请注意，COLUMN关键字是可选的，因此可以省略它。第三，MySQL允许通过指定FI...
MySQL: 1006 - Can't create database '***' (errno: 13) 错误
东子的博客
10-07 1万+
1.新建数据库时,提示一下错误 1006 - Can't create database '***' (errno: 13) 执行 chown -R mysql:mysql /var/lib/mysql /var/lib/mysql 为mysql的数据库存储的所在目录. 2.若提示 #1006 - Can't create database 'shopper'
mysql修改、删除数据记录
cquredstar的专栏
07-29 767
mysql数据库相信很多人都接触过，在进行mysql数据库的操作的时候，有人就希望删除或者修改mysql数据库中的一些数据记录。DELETE 和UPDATE 语句令我们能做到这一点。 用update修改记录 UPDATE tbl_name SET 要更改的列 WHERE 要更新的记录 这里的 WHERE 子句是可选的，因此如果不指定的话，表中的每个记录都被更新。 例如，在pet表中，我们
mysql基础知识之创建数据库，表操作，增加数据，更新数据，删除数据，查询数据
yizhangzzzz的博客
10-27 496
MySQL基础知识 一.数据库操作 1.数据库创建 命令行创建 mysql>create database 数据库名称 使用navicat 2.查看当前都有哪些数据库 show databases; 3.删除数据库 drop database 数据库名 二.表操作 1.创建表 create table 表名 创建一个空表格 create table students( class varchar(50), name varchar(50) ); 创建检查表 create table che
sqlserver 基础（增、删、改、查、链表查询、建立聚焦索引、主键、创建约束、创建外键）、触发器、存储过程
XPY567
11-14 3377
初中学历 + 记忆力差的我只能去点点滴滴的记录着开发中遇到的问题！
MYSQL数据库入门教程：建表与查询操作
"这份文档是关于嵌入式数据库的基础知识，特别针对MySQL数据库...这个文档为初学者提供了一个基础的MySQL数据库操作教程，涵盖了创建表、插入和查询数据的基本操作，以及简单的条件查询，是学习数据库管理的良好起点。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值