How to run SQL script in MySQL?

by

If you’re at the MySQL command line mysql> you have to declare the SQL file as source.

mysql> source \home\user\Desktop\test.sql;

More Related Contents:

  1. How do I import an SQL file using the command line in MySQL?
  2. How to export and import a .sql file from command line with options? [duplicate]
  3. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  4. Downloading MySQL dump from command line
  5. List of Stored Procedures/Functions Mysql Command Line
  6. How to remove all MySQL tables from the command-line without DROP database permissions? [duplicate]
  7. Dump a mysql database to a plaintext (CSV) backup from the command line
  8. How to connect to MySQL from the command line
  9. How to start MySQL server from command line on Mac OS Lion?
  10. Create a Cumulative Sum Column in MySQL
  11. Equivalent of explode() to work with strings in MySQL
  12. mysql select dynamic row values as column names, another column as value
  13. Access denied for user ‘root’@’localhost’ (using password: YES) (Mysql::Error)
  14. MySQL DELETE FROM with subquery as condition
  15. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  16. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  17. Simple Random Samples from a Sql database
  18. node.js mysql error: ECONNREFUSED
  19. MySQL Select Date Equal to Today (having datetime as the data type)
  20. mysql root password forgotten
  21. How to deploy local MySQL database to Heroku
  22. Should I use MySQL blob field type?
  23. Does MySQL overwrite a column of same value on update?
  24. mysql like performance boost
  25. MySQL selecting yesterday’s date
  26. Does MySQL included with MAMP not include a config file?
  27. How do I write an SP in phpMyAdmin (MySQL)?
  28. Unserialize through query at database level itself
  29. Detecting utf8 broken characters in MySQL
  30. django cannot connect mysql in docker-compose

Leave a Comment