é¦å
ï¼å¾ç¡®è®¤èªå·±å·²ç»å®è£
äºMySQL Server 5.1ånavicat for mysqlãè¿ä¸ªå®è£
æ¯å¾ç®åçï¼ç½ä¸å¾å¤æç¨ï¼åå®è£
ä¸è¬è½¯ä»¶å·®ä¸å¤ãåªæå¨å®è£
MySQL Server 5.1æ¶ï¼è¦æ³¨æéæ©å符ç¼ç 为gb2312ï¼ä¸æï¼é£ä¸ªé项ã好äºï¼å®è£
è¿éå°±ä¸è¯´äºã
å®è£
好äºä¹åï¼æå¼MySql Commend Line Clientï¼è¾å
¥å¯ç ï¼
ç°å¨æ们就è¿å
¥å°äºMySqlçå½ä»¤çªå£äºã,å¯ä»¥å¨è¿éå建ä¸ä¸ªæ°æ®åºåä¸ä¸ªè¡¨ï¼
mysql> create database mydata;
mysql> use mydata;
mysql> create table StudentScore
-> (name varchar(10) primary key,
-> number int(10),
-> department varchar(10),
-> gender varchar(10),
-> birth int(10),
-> score int(10)
-> );
ä¸é¢çå è¡å½ä»¤å°±å·²ç»å建好äºä¸ä¸ªmydataçæ°æ®åºï¼éé¢æä¸ä¸ªStudentScoreç表ï¼è¡¨éé¢çæå¦ä¸å åï¼name, number, department, gender, birth, score. ä¹å®ä¹å¥½äºæ¯ä¸ªç±»å以å主é®ã
æå¼navicat for mysqlï¼ålocalhostæ¬å°æ°æ®åºè¿æ¥ï¼æ们就å¯ä»¥çå°åæ建ç«çæ°æ®åºå表ï¼
å¯ä»¥å¯¼å
¥æ¬å°çtxtæ°æ®æ件ï¼å¦ä¸ï¼ï¼è¿éæé»ç çè¿ä¸æ¯å¾æ·±ï¼ä¹åé½æ¯ä¸ç´ä½¿ç¨è¿ç¨æ°æ®åºï¼å¯¼å
¥æ¬å°çtxtæ件è¯äºä¸ä¸ï¼æ¯å¯ä»¥çï¼æ³¨æä¿ææ ¼å¼æ£ç¡®ï¼
ä¸é¢ä¸æ¥è¦æ³¨æä¸ä¸ï¼å¦æä½ çæ°æ®åºä¸æä¸ææ°æ®ï¼ç¼ç æ ¼å¼ä¸å®è¦éæ©æ¯ä¸æçGB2312
ç¶åé´éç¬¦ä¸ºç©ºæ ¼ï¼æ ¹æ®txtä¸çå
·ä½æ
åµæ¥å®ï¼ã并éæ©ç®æ 表ï¼å°æ¯ä¸åä¸ä¸å¯¹åºï¼å³å¯å¯¼å
¥ã
温馨提示:答案为网友推荐,仅供参考