MySql 常用Sql语句
来源:互联网 发布:资源均衡优化的步骤 编辑:程序博客网 时间:2024/04/29 19:38
create database kali;
use kali;
show tables;
create table students (
SNO varchar(10) primary key,
SNAME varchar(10) not null,
SEX varchar(2) check(sex in('男','女')),
AGE varchar(3)
);
insert into students values ('1','xiaoming','男','23');
insert into students values ('2','xiaoli','女','43');
insert into students values ('3','xiaohua','男','34');
insert into students values ('4','xiaoxin','男','6');
insert into students values ('5','xiaoma','女','77');
insert into students values ('6','xiaowang','男','54');
use kali;
show tables;
create table students (
SNO varchar(10) primary key,
SNAME varchar(10) not null,
SEX varchar(2) check(sex in('男','女')),
AGE varchar(3)
);
insert into students values ('1','xiaoming','男','23');
insert into students values ('2','xiaoli','女','43');
insert into students values ('3','xiaohua','男','34');
insert into students values ('4','xiaoxin','男','6');
insert into students values ('5','xiaoma','女','77');
insert into students values ('6','xiaowang','男','54');
- mysql常用SQL语句
- mysql常用SQL语句
- MySQL常用SQL语句
- MySql 常用Sql语句
- MySql 常用Sql语句
- MySql 常用SQL语句
- MySQL常用SQL语句
- Mysql 常用sql语句
- mysql 常用sql语句
- MySQL 常用SQL语句
- MySQL 常用sql语句
- Mysql 常用sql语句
- MySQL常用SQL语句
- MySQL常用SQL语句
- Mysql常用SQL语句
- MySQL常用sql语句
- MySQL常用SQL语句
- mysql常用sql语句
- 适配器模式(Adapter Pattern)
- Perl基本技二:吹姆 —— 去掉前后空格
- VS使用经验
- Vs下 CCriticalSection::Lock 异常错误的发生
- MySql 常用Sql语句
- MySql 常用Sql语句
- 享元模式(Flyweight Pattern)
- 原型模式(Prototype Pattern)
- qt 拖动子窗体,父窗体同时移动
- 让DOS显示中文
- 外观模式/ 门面模式(Facade Pattern)
- Dynamics CRM 2011 表单Debug常用命令
- 职责链模式(Chain of Responsibility Pattern)
- 中介者模式(调停者模式)