您好,登錄后才能下訂單哦!
記錄自己創(chuàng)建數(shù)據(jù)庫(kù),需要更具情況修改
這是以一個(gè)學(xué)生查分系統(tǒng)作為例子:
create table info(
student_id int not null auto_increment, //會(huì)自動(dòng)加值,而且是主鍵
name char(10),
password char(8) not null default "12345678", //設(shè)置默認(rèn)值是
chinese int(2) default 0,
math int(2) default 0,
english int(2) default 0,
Chemistry int(2) default 0,
Physics int(2) default 0,
time timestamp not null default current_timestamp, //會(huì)自動(dòng)獲取時(shí)間,不需要插入
PRIMARY KEY (student_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8; //設(shè)置默認(rèn)編碼
插入數(shù)據(jù)
insert into info(
student_id,name,password,chinese,math,english,Chemistry,Physics)
values
( "2016102401","蔡小先生","19941024",80,90,80,89,95);
刪除表中一行的數(shù)據(jù)
delete from info where student_id=2016102406;
//-------------------------------------
student_id | name | password | chinese | math | english | Chemistry | Physics | time |
+------------+--------------+----------+---------+------+---------+-----------+---------+---------------------+
| 2016102401 | 蔡小先生 | 19941024 | 80 | 90 | 80 | 89 | 95 | 2016-11-19 00:16:11 |
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。