建筑工程网上竣工验收入口_下面不属于网络推广方法_多地优化完善疫情防控措施_商城推广

 库

CREATE DATABASE IF NOT EXISTS blog_platform CHARACTER SET utf8mb4;USE  blog_platform;SHOW VARIABLES LIKE 'character_set_database';
SHOW VARIABLES LIKE 'collation_database';ALTER DATABASE blog_platform COLLATE utf8mb4_0900_as_cs;DROP DATABASE IF EXISTS  blog_platform ;SHOW DATABASES;

 CREATE DATABASE IF NOT EXISTS blog_platform CHARACTER SET utf8mb4;

 1 queries executed, 1 success, 0 errors, 0 warnings

查询：CREATE DATABASE IF NOT EXISTS blog_platform CHARACTER SET utf8mb4

共 1 行受到影响

执行耗时   : 0.002 sec
传送时间   : 0 sec
总耗时      : 0.002 sec

 USE  blog_platform;

 1 queries executed, 1 success, 0 errors, 0 warnings

查询：USE blog_platform

共 0 行受到影响

执行耗时   : 0 sec
传送时间   : 0.001 sec
总耗时      : 0.001 sec

 SHOW VARIABLES LIKE 'character_set_database';
SHOW VARIABLES LIKE 'collation_database';

 

 
ALTER DATABASE blog_platform COLLATE utf8mb4_0900_as_cs;

 1 queries executed, 1 success, 0 errors, 0 warnings

查询：ALTER DATABASE blog_platform COLLATE utf8mb4_0900_as_cs

共 1 行受到影响

执行耗时   : 0.009 sec
传送时间   : 0 sec
总耗时      : 0.009 sec

 SHOW VARIABLES LIKE 'collation_database';

 

 DROP DATABASE IF EXISTS  blog_platform ;

 SHOW DATABASES;

 

表

CREATE DATABASE IF NOT EXISTS book_libs CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_as_cs;USE book_libs;CREATE TABLE IF NOT EXISTS books (book_name VARCHAR(20) COMMENT '图书名',book_price DOUBLE COMMENT '图书价格',book_num INT COMMENT '图书数量'
) CHARSET=utf8mb4 COMMENT='图书表';SHOW TABLES;
DROP DATABASE IF EXISTS   book_libs ;

 CREATE DATABASE IF NOT EXISTS book_libs CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_as_cs;

1 queries executed, 1 success, 0 errors, 0 warnings

查询：CREATE DATABASE IF NOT EXISTS book_libs CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_as_cs

共 1 行受到影响

执行耗时   : 0.002 sec
传送时间   : 0.002 sec
总耗时      : 0.005 sec
 

 USE book_libs;

1 queries executed, 1 success, 0 errors, 0 warnings

查询：USE book_libs

共 0 行受到影响

执行耗时   : 0 sec
传送时间   : 0.002 sec
总耗时      : 0.003 sec
 

 CREATE TABLE IF NOT EXISTS books (
  book_name VARCHAR(20) COMMENT '图书名',
  book_price DOUBLE COMMENT '图书价格',
  book_num INT COMMENT '图书数量'
) CHARSET=utf8mb4 COMMENT='图书表';

1 queries executed, 1 success, 0 errors, 0 warnings

查询：CREATE TABLE IF NOT EXISTS books ( book_name VARCHAR(20) COMMENT '图书名', book_price DOUBLE COMMENT '图书价格', book_num...

共 0 行受到影响

执行耗时   : 0.012 sec
传送时间   : 0 sec
总耗时      : 0.013 sec
 

SHOW TABLES;

 DROP DATABASE IF EXISTS   book_libs ;

1 queries executed, 1 success, 0 errors, 0 warnings

查询：DROP DATABASE IF EXISTS book_libs

共 1 行受到影响

执行耗时   : 0.007 sec
传送时间   : 0 sec
总耗时      : 0.007 sec