slb18220570825的博客

(1)首先创建数据库schoolCREATE DATABASE school;(2)创建teacher表CREATE TABLE teacher(id INT(4) NOT NULL UNIQUE PRIMARY KEY AUTO_INCREMENT,                     num INT(10) NOT NULL UNIQUE,                     NAME...

(1)创建job数据库CREATE DATABASE job;(2)使用job数据库，创建user表和information表USE job;CREATE TABLE USER(userid INT(10) NOT NULL UNIQUE PRIMARY KEY AUTO_INCREMENT,                  username VARCHAR(20) NOT NULL,  p...

(1)创建product表和operate表CREATE TABLE product(id INT(10) NOT NULL UNIQUE PRIMARY KEY,     NAME VARCHAR(20) NOT NULL,     FUNCTION VARCHAR(50),     company VARCHAR(20) NOT NULL,     address VARCHA...

(1)生成3个1~100之间的随机整数SELECT ROUND(RAND()*1000),FLOOR(RAND()*100),CEILING(RAND()*100); (2)计算pi（圆周率）的余弦值和自然对数值 SELECT PI(),COS(PI()),LOG(PI()); (3)创建str_date表CREATE TABLE str_date(id INT AUTO_INCREMENT PR...

(1)创建student表和score表CREATE TABLE student(id INT(10) NOT NULL UNIQUE PRIMARY KEY,     NAME VARCHAR(20) NOT NULL,     sex VARCHAR(4),     birth YEAR,     department VARCHAR(20),     address VA...

(1)创建food表CREATE TABLE food(id INT(10) NOT NULL UNIQUE PRIMARY KEY AUTO_INCREMENT,  NAME VARCHAR(20) NOT NULL,  company VARCHAR(30) NOT NULL,  price FLOAT,  produce_time YEAR,  validity_time...

(1)创建food表CREATE TABLE food(id INT(10) NOT NULL UNIQUE PRIMARY KEY AUTO_INCREMENT,  NAME VARCHAR(20) NOT NULL,  company VARCHAR(30) NOT NULL,  price FLOAT,  produce_time YEAR,  validity_time...

(1)创建job数据库CREATE DATABASE job;(2)使用job数据库，创建user表和information表USE job;CREATE TABLE USER(userid INT(10) NOT NULL UNIQUE PRIMARY KEY AUTO_INCREMENT,                  username VARCHAR(20) NOT NULL,  p...

(1)t表中只包含两个字段 num和strCREATE TABLE t(num INT,       str VARCHAR(20)       );(2)向t表中插入一条记录。num值为30，str值为‘mysql’    INSERT INTO t VALUES(30,'mysql');   (3)从t表中取出num的值与数字4进行加法、减法、乘法、除法、求余运算SELECT num,n...