Inserting sql file from mysql prompt

[netmastan]

hi,

I always use phpmyadmin. Today I have decided to use mysql directly.

What's the code u type in mysql prompt to insert sql file
(Not :mysql datbasename -p < yourfile.sql, I am talking about
mysql>what code goes here for inserting sql file)

THanks

[RGBlackmore]

from http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Loading_tables :

mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;

I just can say you

RTFM 🙂 !!

[netmastan]

I know that code. So if u don't know the table..you just have a sql file how you gonna use it.

I know we can use

mysql -uusername -p databasename<1.sql
[/php

With this one you will have to type and enter password for every single sql file you have.

What I want is ?

what code we use from mysql prompt (mysql>) to insert sql file.

Why ? Cause, in this way  I just login only once . And it save time and i don't have to type  password again for single sql file.

ie
(mysql> insert <1.sql
mysql insert  <2.sql  etc)