摘要：#创建视图create view vw_stu as SELECT order_no,shipping_id,payment,product_name FROM mmall_order INNER JOIN mmall_order_item USING(order_no); #查看视图SELECT 阅读全文

摘要：1.查看当前默认存储引擎 SHOW VARIABLES LIKE 'storage_engine%' 2.设置表的存储引擎 CREATE TABLE 表名( #省略代码 )ENGINE=存储引擎; 阅读全文

摘要：CREATE TABLE `student`( 'studentNo' INT(4) NOT NULL COMMENT '学号' PRIMARY KEY, #非空，主键 ‘loginPwd’ VARCHAR(20) NOT NULL COMMENT ‘密码', 'studentName' VARCH 阅读全文

摘要：1.查看表定义 DESCRIBE 'student' 2.设置编码格式 SET NAMES gbk;等同于 SET character_set_client = gbk; SET character_set_results = gbk; SET character_set_connection = 阅读全文