谢谢,楼上这位,我用了上面这个语句在PHPMYADMIN 运行老是提示错误,我就是找死,都不知道原因。
真实的SQL 如下:
DELETE FROM products p,
products_description pd,
products_to_categories pc WHERE p.products_id = pd.products_id AND p.products_id = pc.products_id AND pd.products_id = pc.products_id AND p.products_model LIKE 'test%'
真实的SQL 如下:
DELETE FROM products p,
products_description pd,
products_to_categories pc WHERE p.products_id = pd.products_id AND p.products_id = pc.products_id AND pd.products_id = pc.products_id AND p.products_model LIKE 'test%'
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'p,products_description pd,products_to_categories pc
where p.p
mysql4delete a,b from a,b where a.id=b.id
products_description pd WHERE p.products_id = '%pd.products_id' AND p.products_model LIKE 'test%'
<?
products_description pd WHERE p.products_id = '$pd.products_id' AND p.products_model LIKE '$test%'
?>mysqlproducts_description pd WHERE p.products_id = 'pd.products_id' AND p.products_model LIKE 'test%' ^_^加分
这位兄弟,正解,
语句:
DELETE p,
pd,
pc FROM products p,
products_description pd,
products_to_categories pc WHERE p.products_id = pd.products_id AND p.products_id = pc.products_id AND pd.products_id = pc.products_id AND p.products_model LIKE 'test%' 执行成功了。
非常感谢。