mysqlÖÐÕâÖÖÓï¾äÔõôд?
update ITEMS_ALARM_LIST set AlarmEndtime = now() where AlarmID = (select max(alarmid) from ITEMS_ALARM_LIST where EquipmentID = 1 and Alarm_Property = 1)
´íÎóÌáʾ£ºYou can't specify target table 'ITEMS_ALARM_LIST' for update in from clause
SQL code:
UPDATE ITEMS_ALARM_LIST t1,ITEMS_ALARM_LIST t2
SET t1.AlarmEndtime=now()
WHERE t1.AlarmID=MAX(t2.AlarmID) AND t2.EquipmentID=1 AND t2.Alarm_Property=1;
MYSQL²»Ö§³ÖÕâÖÖд·¨
update ITEMS_ALARM_LIST a,
(select max(alarmid) as ma from ITEMS_ALARM_LIST where EquipmentID = 1 and Alarm_Property = 1) b
set a.AlarmEndtime = now() where a.AlarmID = b.ma
SQL code:
update ITEMS_ALARM_LIST a,
(select max(alarmid) as max_id from ITEMS_ALARM_LIST where EquipmentID = 1 and Alarm_Property = 1) b
set a.AlarmEndtime = now() where a.AlarmID = b.max_id
mysql µÄÓï¾äÖÐÓÐһЩÏÞÖÆ¡£
SQL code:
update ITEMS_ALARM_LIST a,(select max(alarmid) as max_alarmid from ITEMS_ALARM_LIST where EquipmentID = 1 and Alarm_Property = 1) b
set a.AlarmEndtime = now()
where a.AlarmID=b.max_alarmid
лл£¬ÒѾ½â¾
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12
£¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......