我正在尝试学习PHP并遇到了一个问题。我会非常感激任何帮助。
我有一个数据库,看起来像这样:
ID USER AGE
1 name1 18
2 name2 19
3 name3 20
etc etc
我想删除多条记录。这是我使用的代码:
<?php
$username = "root";
$password = "";
$hostname = "localhost";
//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
//select a database to work with
$selected = mysql_select_db("photo",$dbhandle)
or die("Could not select examples");
//execute
echo "CONNECTED";
echo "</br>";
//Action
$delete_query = ("DELETE FROM _users WHERE age in(17,18,19)");
$result = mysql_query($delete_query);
echo 'Deleted';
mysql_close($dbhandle);
?>
当我通过查询age列来删除数据时,可以成功删除多个行。
但是,当我这样操作时:
$delete_query = ("DELETE FROM _users WHERE USER in(name1,name2,name3)");
什么也没有发生。这是因为它们是字符串吗?我该如何解决?
谢谢!