SELECT INTO and “Undeclared variable” error

by 
INSERT ... SELECT

http://dev.mysql.com/doc/refman/5.1/en/insert-select.html

INSERT INTO newsletter_to_send
SELECT id_subscriber FROM subscribers

PS: are you sure you don’t need in WHERE clause?

More Related Contents:

  1. Are table names in MySQL case sensitive?
  2. Can’t connect to MySQL server on ‘localhost’ (10061)
  3. MySQL database with unique fields ignored ending spaces
  4. MySQL 1062 – Duplicate entry ‘0’ for key ‘PRIMARY’
  5. MySQL DROP all tables, ignoring foreign keys
  6. How to start MySQL server from command line on Mac OS Lion?
  7. MySQL: Check if the user exists and drop it
  8. Autostart MySQL Server on Mac OS X Yosemite/El Capitan
  9. Get the second highest value in a MySQL table
  10. Call a stored procedure for each row returned by a query in MySQL
  11. MySQL ‘select for update’ behaviour
  12. How to select non “unique” rows
  13. Why is connecting to MySQL server so slow?
  14. MySQL disable all triggers
  15. Retrieving only a fixed number of rows in MySQL
  16. How do I fix the ‘Out of range value adjusted for column’ error?
  17. MySQL Closure Table hierarchical database – How to pull information out in the correct order
  18. Fetching a Single Row from Join Table
  19. why this mysql event can’t get run?
  20. Is it unreasonable to assign a MySQL database to each user on my site?
  21. Mysql Counting the consecutive rows that match
  22. Specific Date Format in mysql
  23. MYSQL Truncated incorrect DOUBLE value
  24. Last index of a given substring in MySQL
  25. Create a new database with MySQL Workbench
  26. Connect to mysql server without sudo
  27. Generate serial number in mysql query
  28. What are the benefits of only_full_group_by mode?
  29. How to search and replace all instances of a string within a database?
  30. mySQL SELECT upcoming birthdays

Leave a Comment