Advertisement
Guest User

Untitled

a guest
Jun 4th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.18 KB | None | 0 0
  1. <?php
  2. // массив записей для добавления в БД:
  3. // $array_insert = array("('1','Anna','anna@mail.ru')",
  4. // "('2','Oleg','oleg@yandex.ru')", ... );
  5. $query = mysql_query("INSERT INTO `t1` (`id`, `name`, `email`)
  6. VALUES ".implode(",", $array_insert), $db);
  7. ?>
  8.  
  9. MariaDB [(none)]> create database test_1;
  10. Query OK, 1 row affected (0.00 sec)
  11.  
  12. MariaDB [(none)]> use test_1
  13. Database changed
  14. MariaDB [test_1]> create table t1 (a INT NOT NULL AUTO_INCREMENT,
  15. -> name varchar(100), email varchar(100), PRIMARY KEY (a)
  16. -> );
  17. Query OK, 0 rows affected (0.05 sec)
  18.  
  19. MariaDB [test_1]> drop table t1;
  20. Query OK, 0 rows affected (0.03 sec)
  21.  
  22. MariaDB [test_1]> create table t1 (id INT NOT NULL AUTO_INCREMENT, name varchar(100), email varchar(100), PRIMARY KEY (id) );
  23. Query OK, 0 rows affected (0.03 sec)
  24.  
  25. MariaDB [test_1]> insert into t1 (name, email) values ('user1', 'user1@gmail.com'), ('user2', 'user2@gmail.com');
  26. Query OK, 2 rows affected (0.02 sec)
  27. Records: 2 Duplicates: 0 Warnings: 0
  28.  
  29. MariaDB [test_1]> select * from t1;
  30. +----+-------+-----------------+
  31. | id | name | email |
  32. +----+-------+-----------------+
  33. | 1 | user1 | user1@gmail.com |
  34. | 2 | user2 | user2@gmail.com |
  35. +----+-------+-----------------+
  36. 2 rows in set (0.01 sec)
  37.  
  38. MariaDB [test_1]> INSERT INTO t1 (id, name, email) VALUES (1, 'user1', 'new_email_user1@gmail.com'), (2, 'new_name', 'user2@gmail.com') ON DUPLICATE KEY UPDATE name = VALUES(`name`), email = VALUES(`email`);
  39. Query OK, 4 rows affected (0.01 sec)
  40. Records: 2 Duplicates: 2 Warnings: 0
  41.  
  42. MariaDB [test_1]> select * from t1;
  43. +----+----------+---------------------------+
  44. | id | name | email |
  45. +----+----------+---------------------------+
  46. | 1 | user1 | new_email_user1@gmail.com |
  47. | 2 | new_name | user2@gmail.com |
  48. +----+----------+---------------------------+
  49. 2 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement