例如 資料表有 a, b, c三個資料表 要刪除裡面有空白的欄位
謝謝
更新1:
資料表有 a, b, c三個資料表 刪除欄位名稱nameid裡面有空白部分
更新2:
請問如果是屬於DELETE FROM A WHERE NAMEID = '' 刪除三個資料表這樣對嗎 $sql="DELETE FROM A ,B,C WHERE NAMEID = ' ' AND tdate>='2008-01-08'";
更新3:
用$tables = array("A","B","C"); $sql = "DELETE FROM %s WHERE NAMEID = ' ' AND tdate>='2008-01-08'"; for($i=0; $i ='2008-01-08' at line 1
更新4:
錯誤訊息 syntax to use near '%s WHERE NAMEID = ' ' AND tdate>='2008-01-08' at line 1 DELETE FROM A WHERE NAMEID=' ' AND dte>='2008-01-08'