【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了class.sql提供大家参考,希望对大家有所帮助!
锘?- phpMyAdmin SQL Dump
-- version 2.9.1-rc2
-- http://www.phpmyadmin.net
--
-- 涓绘満: localhost
-- 鐢熸垚鏃ユ湡: 2006 骞?11 鏈?03 鏃?16:45
-- 鏈嶅姟鍣ㄧ増鏈? 4.1.21
--
PHP 鐗堟湰: 4.4.4
--
-- 鏁版嵁搴? `class`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `classmates`
--
CREATE TABLE `classmates` (
`classID` tinyint(2) unsigned NOT NULL auto_increment,
`className` varchar(20) NOT NULL default '',
`classSex` varchar(2) NOT NULL default '濂?,
`classBirthday` date NOT NULL default '0000-00-00',
`classEmail` varchar(100) default NULL,
`classPhone` varchar(100) default NULL,
`classAddress` varchar(100) default NULL,
PRIMARY KEY (`classID`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=11 ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`classmates`
--
INSERT INTO `classmates` (`classID`, `className`, `classSex`, `classBirthday`, `classEmail`, `classPhone`, `classAddress`) VALUES
(1, '鏈皬鑳?, '濂?, '1966-02-11', 'puing@sohu.com.cn', '(010) 85559931','鍖椾含甯傚寳鏂版ˉ98鍙?),
(2, '閲戝皬濡?, '濂?, '1987-12-12', 'kingyean@sohu.com.cn', '(010) 65554822','鍖椾含甯傚垢绂忓ぇ琛?90鍙?),
(3, '瀹夊皬鏃?, '鐢?, '1980-03-26', 'ansu@sohu.com.cn', '010) 65555011','鍖椾含甯傛案瀹氳矾342鍙?),
(4, '杞﹀皬寮?, '鐢?, '1976-05-15', 'carsung@sohu.com.cn', '(010) 65987654','鍖椾含甯備綋鑲插満涓滆34鍙?),
(5, '瑁村皬淇?, '鐢?, '1976-04-02', 'payjung@sohu.com.cn', '(010) 63107877','鍖椾含甯傚闄㈠寳璺?7鍙?),
(6, '瀹嬪皬鍏?, '濂?, '1989-04-04', 'songyung@sohu.com.cn', '(010) 51824448','鍖椾含甯備笢鐩撮棬澶ц50鍙?),
(7, '瀹嬪皬瀹?, '鐢?, '1979-12-24', 'songsyan@sohu.com.cn', '(010) 65554640','鍖椾含甯傜帀娉夎矾 12鍙?),
(8, '钄″皬鐞?, '濂?, '1976-04-18', 'tsuiling@sohu.com.cn', '(010) 89927556','鍖椾含甯傜煶鏅北璺?1鍙?),
(9, '鍏冨皬鏂?, '鐢?, '1973-09-18', 'uangbing@sohu.com.cn', '(010) 87134595','鍖椾含甯傚寳杈拌矾11鍙?),
(10, '鏉庡皬鐖?, '濂?, '1954-03-03', 'leei@sohu.com.cn', '(010) 65552222','鍖椾含甯傝タ鐩撮棬澶ц10鍙?);