我正在使用MySQL,我想检查是否存在一条记录,如果存在,请删除该记录。SELECT 'Barcelone' AS City, EXISTS(SELECT 1 FROM mytable WHERE City = 'Barcelone') AS 'exists';
WHERE City = 'Barcelone';
谢谢你的帮助。
我有一张有以下字段的表格: * LastName * IdNumberString sqlStatement = "DELETE FROM `PersonnelTable` WHERE `Password` = ?m_prepared.setString(2, _username); // set the user-name
int rowsAffected