Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySql×¢ÈëµÄÎÊÌâ

´ó¼ÒºÃ£¬ÎÒÓÃÎÒ×Ô¼ºµÄµçÄÔ×÷ΪʵÑé¶ÔÏó£¬ÒѾ­¿ÉÒÔÔÚ±íµ¥ÖнøÐÐsql×¢Èë¶øÔÚÎÒµÄmysqlÖÐÌí¼ÓÁËÒ»¸öÓû§£¬È¨ÏÞºÍrootÒ»Ñù£¬ÄÇô½ÓÏÂÀ´ÎÒÏëÀûÓÃÕâ¸öн¨µÄÕ˺ŶÔÎҵĵçÄÔÀïµÄÎļþ½øÐвÙ×÷£¨°üÀ¨Ôö¼Ó»òɾ³ý£©£¬ÊÇ·ñ¿ÉÒÔʵÏÖ?ÁíÍ⣬±»mysql×¢ÈëÒÔºó£¬×îÑÏÖØµÄºó¹ûÄÜ´ïµ½ÔõÑù£¿Âé·³´ó¼Ò´Í½Ìһϣ¬Ð»Ð»

ÒýÓÃ
LOAD_FILE(file_name)

¿ÉÒÔÓÃÕâ¸öº¯ÊýÀ´¶ÁÈκÎroot@localhostÓÐȨÏÞµÄÎļþ

select ... INTO OUTFILE  °ÑÐÅϢдÈëijÎļþ¡£

¿ÉÒԲο¼Ò»ÏÂÎĵµÖеÄÏêϸ˵Ã÷ÓÃÀý×Ó¡£
MySQL¹Ù·½Îĵµhttp://dev.mysql.com/doc/refman/5.1/zh/index.html

лл°æÖ÷µÄÀý×Ó£¬ÆäʵÎÒ×îÏëÖªµÀµÄÊÇ£¬±»×¢ÈëÖ®ºó×îÑÏÖØµÄºó¹ûÊÇʲô?³ýÁËÊý¾Ý¿âÖеÄÊý¾Ý»áй¶£¬±»É¾¸Ä£¬±»É¾³ýÖ®Í⣬ÊÇ·ñ¿ÉÒÔ¶Ô·þÎñÆ÷½øÐйÒÂí£¬»ò½øÐпØÖÆ£¿

ÒýÓñ»×¢ÈëÖ®ºó×îÑÏÖØµÄºó¹ûÊÇʲô?

È¡µÃÄãÕû¸ö²Ù×÷ϵͳµÄ¿ØÖÆÈ¨¡£Ê²Ã´¶¼¿ÉÒÔ×öÁË¡£

ÒýÓóýÁËÊý¾Ý¿âÖеÄÊý¾Ý»áй¶£¬±»É¾¸Ä£¬±»É¾³ýÖ®Í⣬ÊÇ·ñ¿ÉÒÔ¶Ô·þÎñÆ÷½øÐйÒÂí£¬»ò½øÐпØÖÆ£¿

Ò»Çж¼¿ÉÒÔ¡£

ËùÒÔ²»Òª¸øMysqld Ì«´óµÄȨÏÞ¡£ unixÖв»Òª¸ømysqlÓû§¹ý¶àµÄȨÏÞ¡£ windowsÖаѷþÎñÉèÖÃÖ¸¶¨Õ˺ÅÔËÐС£¼õÉÙȨÏÞ¡£

¿ÉÒÔ˵˵ÔõôÑùÈ¡µÃÕû¸öϵͳµÄ¿ØÖÆÈ¨Â𣿻òÕßÓÐʲô×ÊÁÏ¿ÉÒԲο¼Ò»Ï£¬ÈçºÎͨ¹ýsql×¢Èë¶øÈ¡µÃÕû¸öϵͳµÄȨÏÞ£¿ÎÒgoogleµÃµ½µÄ´ó²¿·Ö¶¼ÊÇÈçºÎ·ÀÖ¹×¢È룬¶ø×¢Èë³É¹¦ÒÔºóÈçºÎ½øÐÐÆÆ»µÐÔ´óµÄ²Ù×÷È´Ò»Ö±¶¼ÕÒ²»µ½£¬²»ÖªµÀÊDz»ÊÇÎÒÕҵķ½·¨²»¶Ô

ÒýÓÿÉÒÔ˵˵ÔõôÑùÈ¡µÃÕû¸öϵͳµÄ¿ØÖÆÈ¨Â𣿻òÕßÓÐʲô×ÊÁÏ¿ÉÒԲο¼Ò»Ï£¬ÈçºÎͨ¹ýsql×¢Èë¶øÈ¡µÃÕû¸öϵͳµÄȨ


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

ÔõôÔÚeclipseÏÂÏòmysql²åÈë±äÁ¿°¡ - Java / JavaÏà¹Ø

String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡­¡­µ½µ×¸Ãզд°¡

Íò·Ö¸Ðл£¡

String SQL=&q ......

mysqlÊý¾Ý¿â - Java / JavaÏà¹Ø

CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
  (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......

mysql Îļþ¶ÁÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ 
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ