创建一个mysql数据库,输入10条记录. 计算机作业 不会做 帮我做一个拜托 mysql数据库—— 新建student(学生表)，请教大神...
MYSQL\u6570\u636e\u600e\u4e48\u4ece\u4e00\u4e2a\u7535\u8111\u8f6c\u79fb\u5230\u53e6\u4e00\u4e2a\u7684\u7535\u81111\u3001\u627e\u5230my.ini\u6587\u4ef6\uff0c\u91cc\u9762\u6709\u4e00\u884cdatadir=...\u7684\uff0c\u5c31\u662f\u6570\u636e\u5e93\u6587\u4ef6\u76ee\u5f55\uff0c
\u5173\u6389mysql\u670d\u52a1\uff0c\u5c06\u8fd9\u4e2a\u76ee\u5f55\u6574\u4e2a\u62f7\u8d1d\u8fc7\u53bb
\u5728\u90a3\u8fb9\u518d\u914dmy.ini\u8ba9\u76ee\u5f55\u543b\u5408\u5c31\u884c\u4e86\u3002
2\u3001
\u628a\u6570\u636e\u5e93\u4e0a\u7684\u8d44\u6599\u5907\u4efd\u51fa\u6765\uff0c\u5230\u53e6\u5916\u4e00\u4e2a\u6570\u636e\u5e93\u8fd8\u539f\uff0c\u6709\u5de5\u5177PHPMYADMIN\uff1b
\u4e5f\u53ef\u4ee5\u547d\u4ee4\u884c\u5bfc\u51fa\uff0c
\u5229\u7528\u201cmysqldump -u \u7528\u6237\u540d -p databasename >exportfilename\u201d\u5bfc\u51fa\u6570\u636e\u5e93\u5230\u6587\u4ef6\uff0c\u5bfc\u5165\uff1a
\u8fdb\u5165MySQL Command Line Client\uff0c\u8f93\u5165\u5bc6\u7801\uff0c\u8fdb\u5165\u5230\u201cmysql>\u201d\uff0c\u8f93\u5165\u547d\u4ee4"show databases\uff1b"\uff0c\u56de\u8f66\uff0c\u770b\u770b\u6709\u4e9b\u4ec0\u4e48\u6570\u636e\u5e93\uff1b\u5efa\u7acb\u4f60\u8981\u8fd8\u539f\u7684\u6570\u636e\u5e93\uff0c\u8f93\u5165"create database voice\uff1b"\uff0c\u56de\u8f66\uff1b\u5207\u6362\u5230\u521a\u5efa\u7acb\u7684\u6570\u636e\u5e93\uff0c\u8f93\u5165"use voice\uff1b"\uff0c\u56de\u8f66\uff1b\u5bfc\u5165\u6570\u636e\uff0c\u8f93\u5165"source voice.sql\uff1b"\uff0c\u56de\u8f66\uff0c\u5f00\u59cb\u5bfc\u5165\uff0c\u518d\u6b21\u51fa\u73b0"mysql>"\u5e76\u4e14\u6ca1\u6709\u63d0\u793a\u9519\u8bef\u5373\u8fd8\u539f\u6210\u529f\u3002
CREATE TABLE student(sno INT(15) NOT NULL PRIMARY KEY,sname VARCHAR(50), sex CHAR(2) CHECK(sex IN('\u7537','\u5973')),dept VARCHAR(25), birth DATE,age INT(3) CHECK(age >=0 AND age <=100))ENGINE=INNODB DEFAULT CHARSET=utf8;
create database abc;CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(70) NOT NULL,
`email` varchar(70) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
INSERT INTO `users` VALUES ('1', 'oooop', 'fsfsdfsdf');
INSERT INTO `users` VALUES ('2', 'fdsfsdfs', 'fsdfsfsdfsf');
INSERT INTO `users` VALUES ('3', '程培阳', 'dsflfklds');
INSERT INTO `users` VALUES ('4', 'gggg', 'fsdfsfsdfsf');
INSERT INTO `users` VALUES ('5', 'jjjj', 'fsfsdfsdf');
INSERT INTO `users` VALUES ('6', 'kkkk', 'fsfsdfsdf');
INSERT INTO `users` VALUES ('5', 'lllll', 'fsfsdfsdf');
INSERT INTO `users` VALUES ('6', '程培阳', 'fsfsdfsdf');
INSERT INTO `users` VALUES ('7', 'hhhhhh', 'fsfsdfsdf');
INSERT INTO `users` VALUES ('8', 'fdsfsdfs', 'fsdfsfsdfsf');
INSERT INTO `users` VALUES ('9', 'uuuuuu', 'dsflfklds');
INSERT INTO `users` VALUES ('10', 'tttttt', 'fsdfsfsdfsf');
具体什么要求啊？。。。
绛旓細mysql -u root -h -p 璇锋敞鎰忥細涓轰簡鑳界櫥杩涜繙绋嬬殑MySQL鏈嶅姟鍣紝浣犻渶瑕佸紑鍚湇鍔″櫒涓婄殑杩滅▼璁块棶锛屽鏋滀綘鎯宠皟鐢ㄥ悓涓涓绘満涓婄殑MySQL鏈嶅姟鍣紝浣犲彲浠ョ渷鐣 "-h " 鍙傛暟 mysql -u root -p 浣犲皢闇瑕杈撳叆MySQL鏈嶅姟鍣ㄧ殑瀵嗙爜锛屽鏋滆璇佹垚鍔燂紝MySQL鎻愮ず灏嗕細鍑虹幇銆傜浜屾锛鍒涘缓涓涓狹ySQL鏁版嵁搴 鍦∕ySQL鎻愮ず涓緭鍏...
绛旓細7銆佺涓冩锛氳繘鍏鍒涘缓琛ㄧ殑椤甸潰锛屾帴涓嬫潵灏辨槸鍒涘缓瀛楁浜嗭紝璁剧疆涓婚敭骞朵笖鑷姩閫掑锛岃嚜鍔ㄩ掑鐨勪綔鐢ㄦ槸锛屾瘡澧炲姞涓鏉℃暟鎹紝id灏变細鑷姩澧炲姞锛屼笉闇瑕佹垜浠杈撳叆銆8銆佺鍏锛氬悓鏃舵寜Ctrl+s淇濆瓨鏁版嵁琛紝骞朵笖濉啓鏁版嵁琛ㄥ悕锛屽懡鍚嶄负xz銆傞氳繃涓婇潰鐨勬楠わ紝鎴戜滑灏卞畬缇庡疄鐜鏁版嵁搴鐨勫垱寤轰笌鏁版嵁琛ㄧ殑鍒涘缓銆mysql濡備綍寤虹珛锛熷湪mysql...
绛旓細闇瑕佹洿澶氫富娴鏁版嵁搴撳垱寤鏂规硶鐨勭煡鍙嬪彲浠ョ湅鐪嬩笅闈㈣繖绡囨枃绔狅細鏁版嵁搴撴庝箞鍒涘缓锛4绉嶆祦琛屾暟鎹簱鐨勫垱寤烘柟娉曚粙缁峗鏍戞噿瀛﹀爞 MySQL涓鍒涘缓鏁版嵁搴鐨勫熀鏈娉曟牸寮忓涓嬶細鍏朵腑鈥渄b_name鈥濇槸灏嗚鍒涘缓鐨勬暟鎹簱鍚嶇О锛岃鍚嶇О涓嶈兘涓庡凡缁忓瓨鍦ㄧ殑鏁版嵁搴撻噸鍚嶃備緥瀛愶細鍒涘缓鏁版嵁搴 鍒涘缓鏁版嵁搴 shulanxt锛岃緭鍏璇彞濡備笅锛氭寜鍥炶溅閿墽琛岃鍙ワ紝...
绛旓細1銆佹墦寮鐢佃剳鐨凷QL杞欢 锛岃緭鍏鐢ㄦ埛鍚嶅拰瀵嗙爜锛岃繛鎺ヤ笂Mysql涓绘満鍦板潃锛屽皢Mysql鍚姩銆2銆佽繘鍏ysql閲岄潰鍚庯紝鐢ㄩ紶鏍囧彸閿偣鍑讳富鏈猴紝鐒跺悗浼氬脊鍑鸿彍鍗曟爮锛岀偣鍑婚噷闈㈢殑鈥鍒涘缓鏁版嵁搴鈥濓紝涔熷彲浠ヤ娇鐢ㄥ揩鎹烽敭Ctrl+D銆3銆佹帴鐫浼氬嚭鐜扳滃垱寤烘暟鎹簱鈥濈殑绐楀彛锛屼负鍒涘缓鐨勬暟鎹簱鍙栧悕锛屽苟閫夋嫨鈥滃熀瀛楃闆嗏濅负鈥淯TF-8鈥濓紝鐒跺悗鐐瑰嚮鍒涘缓...
绛旓細锛2锛夊～鍐欏ソ涔嬪悗锛屽崟鍑烩滄祴璇曡繛鎺モ濓紝寮瑰嚭鈥滆繛鎺ユ垚鍔熲濓紝灏辨寜纭畾銆4銆佸～鍐欏唴瀹癸細浼氱湅鍒板乏杈瑰嚭鐜颁簡鎴戜滑鍒氭墠鍒涘缓鐨勮繛鎺ワ紝閲岄潰鏈夊緢澶氱殑鏁版嵁锛屾垜浠彲浠ュ彸鍑昏繛鎺ワ紝閫夋嫨鏂板缓鏁版嵁搴銆傚～鍐欐暟鎹簱鐨勫悕绉板拰瀛楃缂栫爜銆傚瓧绗﹂泦涓嬫媺妗嗕腑鍒楄〃姣旇緝澶氾紝鍙互杈撳叆鍏抽敭瀛楄繘琛岃繃婊わ紝濡傚浘锛岃緭鍏utf鍗冲彲杩囨护鍑轰互utf寮澶寸殑瀛楃闆嗭紝...
绛旓細鍦╟md鍛戒护鎻愮ず绗︿笅杈撳叆 mysql-uroot-p鍥炶溅锛岀劧鍚庤緭鍏ュ瘑鐮佸洖杞 杩涘叆mysql鍛戒护琛屾ā寮 createdatabasedatabasename;//鍒涘缓鏁版嵁搴 usedatabasename;//浣跨敤鏁版嵁搴 createtabletablename(idintnotnullprimarykey );杩欐牱灏卞垱寤轰簡涓涓鍙湁id瀛楁鐨則ablename琛 ...
绛旓細涓銆佷娇鐢ㄨ彍鍗曡嚜鍔ㄥ垱寤鏁版嵁搴 鐧婚檰phpMyAdmin 鍦╬hp MyAdmin鍙宠竟绐楀彛涓紝濉啓鏁版嵁搴撳悕绉帮紝鐐瑰垱寤哄嵆鍙 渚嬪鎴戜滑杩欓噷鍒涘缓涓涓鍚嶅瓧涓猴細cncmstest 鐨勬暟鎹簱 鍒涘缓鎴愬姛涔嬪悗鎻愮ず濡備笅 浜屻佽繍琛孲QL璇彞鍒涘缓鏁版嵁搴 鐧婚檰phpMyAdmin 鍦╬hpMyAdmin涓荤晫闈腑鐐瑰嚮鈥淪QL鈥濊秴閾炬帴銆傚涓嬪浘鎵绀 鍦⊿QL杈撳叆绐楀彛杈撳叆寤琛ㄨ鍙ワ紝鐐瑰彸...
绛旓細3銆佺偣鍑诲乏涓婅鐨勪富椤垫寜閽紝杩斿洖php(鍋氫负鐜板湪鐨勪富娴佸紑鍙戣瑷)MyAdmin涓荤晫闈細4銆佸湪涓荤晫闈㈢殑鍙宠竟鐐瑰嚮鈥滄潈闄愨濇潵鍒涘缓鏁版嵁搴撳笎鍙凤紝骞舵坊鍔犳柊鐢ㄦ埛銆5銆佸湪璇ラ〉闈腑锛屽～鍐欒鍒涘缓鐨勬暟鎹簱鐢ㄦ埛鍚嶏紝璇ョ敤鎴风殑璁块棶鑼冨洿锛屽強瀵嗙爜銆傦紙鍦ㄤ竴涓湇鍔″櫒涓婁竴鑸潵璁查兘涓嶆涓涓珯鐐癸紝鏇翠笉姝涓涓狹ySQL鏁版嵁搴銆備负浜嗛槻姝㈠畨鍏ㄩ殣鎮...
绛旓細浜屻佷慨鏀瑰瘑鐮 鏍煎紡锛mysqladmin -u鐢ㄦ埛鍚 -p鏃у瘑鐮 password 鏂板瘑鐮併 渚嬪 1銆 缁檙oot鍔犱釜瀵嗙爜ab12銆傞鍏堝湪DOS涓嬭繘鍏ョ洰褰昺ysql\bin锛岀劧鍚庨敭鍏ヤ互涓嬪懡浠 mysqladmin -u root -password ab12 2銆 鍐嶅皢root鐨勫瘑鐮佹敼涓篸jg345銆俶ysqladmin -u root -p ab12 password 涓夈鍒涘缓鏁版嵁搴 1銆 CREATE ...
绛旓細鍦 MySQL 鍛戒护琛屽鎴风杈撳叆 SQL 璇彞CREATE DATABASE test_db锛屽嵆鍙鍒涘缓涓涓暟鎹簱锛岃緭鍏鐨 SQL 璇彞涓庢墽琛岀粨鏋滃涓嬨mysql> CREATE DATABASE test_db;Query OK, 1 row affected (0.12 sec);鈥淨uery OK, 1 row affected (0.12 sec);鈥濇彁绀轰腑锛屸淨uery OK鈥濊〃绀轰笂闈㈢殑鍛戒护鎵ц鎴愬姛锛屸1 row...
