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

mysql float ÀàÐͲåÈë²»³É¹¦

²âÊÔÓï¾äÈçÏ£º
int j = 12;
float f = 89.76f;
wsprintf(sql,"INSERT INTO T_Score(FId,FScore) VALUES (%d,%f)",j,f);
µ±Ö´ÐÐÕâÌõÓï¾ä²åÈëµ½mysqlÊý¾Ý¿âÊÇ£¬±¨´í1054ºÅ´íÎóÐÅϢΪunkown colum ¡®f'
˵Ã÷£¬ÎÒ¾ø¶ÔÔÚÊý¾Ý¿âÖж¨Òå¹ýFScoreÕâ¸ö×ֶΣ¬²¢ÇÒΪ¸¡µãÀàÐÍ
Çó¸÷λ´óϺ°ï°ï¿´¿´ÊÇʲôԭÒò£¬Ôõô¸ÄÕý°¡

´òÓ¡sqlÄÚÈÝΪ£ºINSERT INTO T_Score(FId,FScore) VALUES (12,f) ÔõôÊÇfÄØ ¶ø²»ÊÇ89.76

%f ÊÇʲôÓïÑÔÖеģ¿

CÓïÑÔÖеİ¡

CÓïÑÔÖÐÓÐÕâ¸ö%f£¿ ¿´Ò»ÏÂÊÖ²áÖÐÊÇÈçºÎ½âÊ͵ġ£

float g = 10.2f;
printf("%f",g);
Õâ¸ö¶¨ÒåûÓÐ´í°¡

²»Ðоͻ»³É 
wsprintf(sql,"INSERT INTO T_Score(FId,FScore) VALUES (%d,%d)",j,f);
°É£¬¹À¼ÆÕâ¸ö wsprintf ÓÐÊ²Ã´ÌØÊâ¡£

ллÄ㣬¸øÁËÎÒ˼·£¬ºÇºÇ½â¾öÁË »»³ÉÁËsprintf ¸ø·ÖÀ²£¬ºÇºÇ£¬·½±ãµÄ»°½»¸öÅóÓÑŶ£¬ÄÜ·ñÁôÏÂQQºÅ°¡

ºÇºÇ£¬ÕæÐÄллÁË


Ïà¹ØÎÊ´ð£º

MYSQLÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......

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

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

Íò·Ö¸Ðл£¡

String SQL=&q ......

mysql×Ö¶ÎÌáÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......

vs2008 Á¬½Ómysql£¿ - MS-SQL Server / »ù´¡Àà

ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐË­ÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿

ÒýÓÃ
ÇëÎÊ
......

ÈçºÎÓÃMFCÁ¬½ÓÉÏMYSQL - VC/MFC / Êý¾Ý¿â

ÈçÌâ¡£Äܲ»Äܸø¸öÀý×Ó£¬·Ç³£¸Ðл

°²×°mysqlʱ¼ÇµÃ×° Àà¿â£¬ÀïÃæÓÐ mysqlÌṩµÄº¯Êý½è¿Ú£¬ÓÃËüÀ´Á¬mysqlºÜ·½±ã

ºÃ¶«Î÷£¬¹²Í¬Ñ§Ï°


mysql++ À࣬ºÜ·½±ãºÜºÃÓã¡

ÌùÓÊÏ䣬·¢Äã

1.mysql api
2.myodbc
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ