Get Insert Statement for existing row in MySQL

by

There doesn’t seem to be a way to get the INSERT statements from the MySQL console, but you can get them using mysqldump like Rob suggested. Specify -t to omit table creation.

mysqldump -t -u MyUserName -pMyPassword MyDatabase MyTable --where="ID = 10"

More Related Contents:

  1. How can I fix MySQL error #1064?
  2. 1064 error in CREATE TABLE … TYPE=MYISAM
  3. Using an Alias in SQL Calculations
  4. What is the question mark’s significance in MySQL at “WHERE column = ?”?
  5. How do I modify a MySQL column to allow NULL?
  6. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  7. MySQL delimiter syntax error
  8. GRANT with database name wildcard in MySQL?
  9. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  10. Error related to only_full_group_by when executing a query in MySql
  11. Find duplicate records in MySQL
  12. How to declare a variable in MySQL?
  13. Can you split/explode a field in a MySQL query?
  14. MySQL order by before group by
  15. MySQL Cannot Add Foreign Key Constraint
  16. Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
  17. Grouping into interval of 5 minutes within a time range
  18. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  19. Difference between float and decimal data type
  20. Parse date in MySQL
  21. mysql dynamic query in stored procedure
  22. Table is ‘read only’
  23. How to select one row randomly taking into account a weight?
  24. Proper database model for a user feedback system (an interesting case)
  25. MySQL – Replace Character in Columns
  26. Sort the rows according to the order specified in WHERE IN clause
  27. MySQL Select minimum/maximum among two (or more) given values
  28. connecting to a docker-compose mysql container denies access but docker running same image does not
  29. mysql – move rows from one table to another
  30. #1214 – The used table type doesn’t support FULLTEXT indexes

Leave a Comment