On 11/13/07, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
>
> hi there,
>
> i have a text file that i prepare:
>
> insert into `sa2007` (`id`,`amount`,`state`) values
> ('','1.00','oh'),
> ('','2.00','il'),
> ('','4.00','ks')
>
> how do i import this file to sa2007 table from the command line? i tried
> via phymyadmin, but it doesn't work (300 seconds timeout).Try: mysql -uusername -ppassword database < filename.sql -- Check out the Dallas Music Wiki http://www.digitaldarkness.com
