php mysql 基本操作(1)

来源:互联网 发布:linux 分区表修复 编辑:程序博客网 时间:2024/04/28 03:22

1)同时插入多条数据:
<?php$con = mysql_connect("localhost","peter","abc123");if (!$con)  {  die('Could not connect: ' . mysql_error());  }mysql_select_db("my_db", $con);mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Peter', 'Griffin', '35')");mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Glenn', 'Quagmire', '33')");mysql_close($con);?>

或只保留VALUES

<?php$con = mysql_connect("localhost","peter","abc123");if (!$con)  {  die('Could not connect: ' . mysql_error());  }mysql_select_db("my_db", $con);mysql_query("INSERT INTO PersonsVALUES ('Peter', 'Griffin', '35')");mysql_query("INSERT INTO PersonsVALUES ('Glenn', 'Quagmire', '33')");mysql_close($con);?>


0 0
原创粉丝点击