mysql基本操作（学习笔记。。持续更新）
查看库：show databases;MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| binben |
| binben_mc |
| db1 |
| db2 |
| mysql |
| performance_schema |
| test |
+--------------------+
8 rows in set (0.03 sec
转换库：use <库名>
MariaDB [(none)]> use db1
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
查看库中的表：show tables;
MariaDB > show tables;
+---------------+
| Tables_in_db1 |
+---------------+
| t2 |
| t3 |
+---------------+
2 rows in set (0.00 sec)
查看库中表的信息：select * from <表名>;
MariaDB > select * from t3;
Empty set (0.00 sec)
查看表结构信息：desc <表名>；
MariaDB > desc t3;
+--------+-------------+------+-----+---------+-------+
| Field| Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| uid | int(11) | NO | PRI | 0 | |
| certid | int(11) | NO | PRI | 0 | |
| name | varchar(10) | YES| | NULL | |
+--------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
建库：create database <库名>;
MariaDB > create database aaa;
Query OK, 1 row affected (0.00 sec)
建表：create table <表名>(表格信息);
MariaDB > create table bbb(
-> age tinyint,
-> name varchar(10)
-> );
Query OK, 0 rows affected (0.53 sec)
页:
[1]