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£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
ÈçÌâ¡£Äܲ»Äܸø¸öÀý×Ó£¬·Ç³£¸Ðл
°²×°mysqlʱ¼ÇµÃ×° Àà¿â£¬ÀïÃæÓÐ mysqlÌṩµÄº¯Êý½è¿Ú£¬ÓÃËüÀ´Á¬mysqlºÜ·½±ã
ºÃ¶«Î÷£¬¹²Í¬Ñ§Ï°
mysql++ À࣬ºÜ·½±ãºÜºÃÓã¡
ÌùÓÊÏ䣬·¢Äã
1.mysql api
2.myodbc
......