摘要：Intergrity ConstraitsSet table's foreign keypurpose:establish links with the parent table(建立于父表的联系) mysql>create table student3( >id int primary key, >course_id int, >teacher varchar(20), >constraint fk foreign key(id.course_id) >references student2(id,course_id) >); Set tab 阅读全文

摘要：Intergrity Constrait (完整性约束)Set table key‘s primary key mysql>create table student( >id int primary key, >name varchar(40), >sex boolean, >); Multiple-field primary key---consists of more than one property mysql>create table student2( >id int, >course_id int, >score f... 阅读全文

摘要：login: mysql -u root -p mysql -h xxxx -u root -pcreate database: mysgl>create database cat; mysql>show database cat;delete database: mysql>drop database cat;table basics: 1.choose a database mysql>use cat; mysql>create table workers( > id int; >name varchar(10); ... 阅读全文

摘要：今天是3月28号了哦，开始我的MySQL和Linux学习之旅了哦 阅读全文