Newbie to MySql question : how to execute multicommand sql script ?

lurulu · #1 (**permalink**) 08-22-06, 12:08

Hi,
I 'm using winsql 5.0 + mysql-connector-odbc-3.51.12 + mySql 5.0.21 and I want to initialize a database with a script containing lots of
create table statements and insert statements. Seems I can only execute one statement at a time. How can I execute the whole script ??
Tx, L.

HSN · #2 (**permalink**) 08-30-06, 04:33

copy & paste it in the mysql console!

pakcik_kantin · #3 (**permalink**) 09-14-06, 00:20

Quote:

mysql/bin > mysql -uroot -p database_name < sample_script.sql

sample_script.sql

Quote:

create table.....;
insert ....;
create table.....;
insert ....;
create table.....;
insert ....;
create table.....;
insert ....;

pakcik_kantin · #4 (**permalink**) 09-18-06, 00:40

Greetings,
the multiline command depends on the tools, but most free tools that i use, like
MySql console,HeidiSQL,MySQL Front, Navicat did accept multiline script in the query browser...

Internet Services

Web Development

Digital Marketing

Consumer Tech