Re: how to create tables from .txt file

[Peter Brawley]

Simplest:

Edit the text file to ensure that it begins with ...

create database if not exists desired_db_name;
use desired_db_name;

... substituting desired_db_name with, uh, the desired db name.

Then run the mysql client program, and in it issue this cmd ...

source path_to_txt_file

where path_to_txt_file is, uh, the full path to the text file.

Note: you can use forward slashes even if you're on Windows, and the source command must not have a terminating semicolon.