Database changed MariaDB[lyshark]>create table tb_user->(->idint(11),->namevarchar(25),->deptIdint(11),->salary float->);QueryOK,0rowsaffected(0.01sec) 3.查看这个数据表,已经创建成功啦. 代码语言:javascript 代码运行次数:0 运行 AI代
MariaDB [westos]> DROP TABLE messages; ##删除表格; Query OK, 0 rows affected (0.03 sec) MariaDB [westos]> DROP DATABASE westos; ##删除数据库 Query OK, 0 rows affected (0.00 sec) 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22...
create database db_name default character SET utf8 collate utf8_general_ci; #创建数据库并设置中文字符集 1. 2. collate:校对集。制定数据集如何排列,按照二进制编码比较排序,主要是对字符集之间的比较和排序,collate为数据表的校对规则可以通过show collation查看所有的校对集 修改数据库默认字符集 alter data...
3、新建一个库,名字叫my。 MariaDB [test]>create database my;Database changed 4、可以再次通过show databases查看新建的库 5、使用库:use my 6、新建一个表单:sql语句如下 MariaDB [my]>create table my.student(->id int(4) primary key,->name varchar(4) not null,->ageint(2) notnull->); ...
SHOW TABLES WHERE Tables_in_test LIKE 'a%'; +---+ | Tables_in_test | +---+ | animal_count | | animals | | are_the_mooses_loose | | aria_test2 | +---+ Showing tables and table types: SHOW FULL TABLES; +---+---+ | Tables_in_test | Table_type | +---+---+ | ...
查看所有的已启用的存储引擎简单介绍几个 MariaDB 的存储引擎 1、InnoDB/XtraDB XtraDB 属于 InnoDB 分支( Percona 负责维护),针对“效能与监控”进行强化,...Facebook 所发展的数据储存技术 MyRocks 是将 RocksDB 数据库添加到 MariaDB 的存储引擎。...定义 Wrapper Table 提供 Client 存取按用途选择存储引擎 ...
MariaDB [(none)]> SHOW CREATE DATABASE yinzhengjie2019; 13>.查看表创建命令 MariaDB [yinzhengjie]> SHOW CREATE TABLE students; MariaDB [yinzhengjie]> SHOW CREATE TABLE students\G 14>.查看表状态 MariaDB [yinzhengjie]> SHOW TABLE STATUS LIKE 'students'; MariaDB [yinzhengjie]> SHOW TABLE ...
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 MariaDB [linux]> show tables; +---+ | Tables_in_linux | +---+ | test | +---+ 1 row in set (0.00 ...
log_error = /mydata/log/error.log slow_query_log = 1 long_query_time = 1 slow_query_log_file = /mydata/log/slow.log performance_schema = 0 explicit_defaults_for_timestamp skip-external-locking default-storage-engine = InnoDB innodb_file_per_table = 1 ...
1 row in set (0.002 sec)第三部分 普通表增减系统版本信息mariadb [wuhan]> create table wuhan.t2(id int not null,keyname varchar(20));query ok, 0 rows affected (0.006 sec)添加版本信息:mariadb [wuhan]> show create table wuhan.t2\g...