mysql¼ÆËãÁÐ
mysqlÊý¾Ý±íÓУº¹Ì¶¨¹¤×÷¡¢½±½ð¡¢¶îÍâ½ð¡¢¿Û³ý¡¢Ó¦·¢¹¤×ʵÈ×ֶΡ£ÔõôÔÚ±í¸ñʵÏÖ£ºÓ¦·¢¹¤×Ê=¹Ì¶¨¹¤×Ê+½±½ð+¶îÍâ½ð-¿Û³ý
ôÒâ˼?
Êǽ¨±í?
SQL
¹Ì¶¨¹¤×Ê+½±½ð+¶îÍâ½ð-¿Û³ý AS 'Ó¦·¢¹¤×Ê'
select Ó¦·¢¹¤×Ê=¹Ì¶¨¹¤×Ê+½±½ð+¶îÍâ½ð-¿Û³ý from tb
mysql table pwages(id char(4),name char(8),Fixed_wage decimal(8,2),bonus decimal(8,2),Other_add decimal(8,2),Other_cut decimal(8,2),total_wages decimal(8,2));
È»ºó£¬ÔõôÌí¼Ó´úÂ룬ʹµÃtotal_wages=Fixed_wage + bonus + Other_add - Other_cut ÔÚ±íÖÐÌí¼Ó£¬²»ÊÇÔÚ²éѯʱ¼ÆËã¡£
MYSQLÓÐÇëPÁº
SQL code:
mysql table pwages(id char(4),name char(8),Fixed_wage decimal(8,2),bonus decimal(8,2),Other_add decimal(8,2),Other_cut decimal(8,2),Fixed_wage + bonus + Other_add - Other_cut AS total_wages );
ÕâÑùÊÔÊÔ,MYSQL²»¶®
ÕâÁÐÃ²ËÆºõ¶àÓà.
²éѯʱֱ½ÓʹÓÃ:¹Ì¶¨¹¤×Ê+½±½ð+¶îÍâ½ð-¿Û³ý.
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´
......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......