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

ÇëÎÊÔõôÁ¬½ÓMYSQLÊý¾Ý¿âºÍÖ´ÐÐSQLÓï¾ä°¡£¿

²»ÖªµÀΪʲôÏÂÁ˱ðÈ˳ÌÐò¶¼±à²»¹ý£¬Ö´ÐбðÈ˱àºÃµÄ³ÌÐò£¬ÔËÐоͳö´í¡£¡£¡£
Ë­ÄÜÖ¸µãÒ»ÏÂÔõôÁ¬½ÓMYSQL°¡¡£Ð»Ð»ÁË¡£
¿ÉÒÔÓÃÌṩµÄAPIº¯Êý

ÍøÉÏËÑÒ»´ó°ÑµÄÀý×Ó

ËÑËØÁËÒ»¸ö
C/C++ code:

mysql_real_connect()ÊÔͼ½¨Á¢µ½ÔËÐÐhostµÄÒ»¸öMySQLÊý¾Ý¿âÒýÇæµÄÒ»¸öÁ¬½Ó¡£Æäº¯ÊýÔ­ÐÎΪ£º

MYSQL *mysql_real_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned int client_flag)
ÎÒÒª±àÒ»¶Î³ÌÐòÓÃÀ´Ô¶³ÌÁ¬½ÓÒ»¸ömysqlÊý¾Ý¿â¡£ÎÒÔÚÊý¾Ý¿âµÄ±¾»úÉÏ×öÊÔÑ飬·¢ÏÖmysql_real_connect()µÄµÚ¶þ¸ö²ÎÊýÉèΪ"localhost"ʱ¿ÉÒÔÕý³£Á¬½Ó£¬µ±¸ÄдΪ¸Ã»úÆ÷µÄIPµØÖ·"192.168.100.2"ʱ¾ÍÁ¬½Óʧ°Ü¡£ÎÒÔÚ³ÌÐòÖÐдµÄÔ­¾äΪ£º
mysql_real_connect(mysql,"192.168.100.2","root","","mydns",0,NULL,0)¡£

×î³õ£¬ÎÒÒÔΪ½«"localhost"¸ÄΪ"192.168.100.2"Ö®ºóÒª½«µÚÁù¸ö²ÎÊý¶Ë¿ÚºÅдÉÏ£¬µ«»¹ÊDz»ÐС£ÓÉÓÚÎÒÊÇÔÚLinuxÉÏ×öµÄ£¬ËùÒÔÏëÒ²ÐíÐèÒª½«µÚÆß¸ö²ÎÊýunix_socketдÉÏ£¬½á¹û»¹ÊDz»ÐС£ÓÚÊǵ½googleÕÒ½â¾ö·½·¨£¬·¢ÏÖÒªÔ¶³ÌÁ¬½ÓmysqlÐèҪΪmysqlµÄÖ¸¶¨ÕʺÅÉèÖÃÔ¶³ÌÁ¬½ÓµÄȨÏÞ¡£ÔÚÎҵijÌÐòÖУ¬¾ÍҪΪrootÉèÖÃÕâһȨÏÞ¡£ÊÂʵ֤Ã÷£¬ÎÒ֮ǰÁ¬½Óʧ°ÜÕýÊÇÓÉÓÚÕâ¸öÔ­Òòµ¼Öµġ£µ«ÎÊÌâÊÇ£¬ÍøÉϱ»¹ã·º×ªÌùµÄ·½·¨ÊÇ´íÎóµÄ£¬ÎÒÕÕ×öºó»¹²»ÐУ¬×îºóÎÊÁËͬѧ²Å½â¾öµÄ¡£ÏÂÃæÎÒ¾ßÌå˵һÏ£¬Íû´ó¼Ò²»»áÔÙ±»Î󵼡£

ÔÚmysqlÊý¾Ý¿âÖÐÓÐÒ»¸ömysql¿â£¬ËüÀïÃæ°üº¬Ò»¸öuser±í£¬ÀïÃæ


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ