you can run it by issuing the command in the dos command prompt like mysql -u username -p < textfile.sql
but place use yourdatabasename; at the beginning of your text file. USE YOURDATABASENAMEHERE; DROP TABLE IF EXISTS NAME; CREATE TABLE NAME (KD NUMERIC(3), OO CHAR(30)); insert into name values (1,"John"); insert into name values (2,"George"); insert into name values (3,"Chris"); insert into name values (4,"Patrick"); Regards, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Tel: (632) 634-5141/ (632) 634-5140 Fax: (632) 634-5139 ----- Original Message ----- From: "Marinos" <[EMAIL PROTECTED]> To: "MySql" <[EMAIL PROTECTED]> Sent: Sunday, January 06, 2002 4:32 AM Subject: Niebie again > I have a txt file with sql commands eg: > > drop table name > CREATE TABLE NAME > (KD NUMERIC(3), > OO CHAR(30)); > insert into name values (1,"John"); > insert into name values (2,"George"); > insert into name values (3,"Chris"); > insert into name values (4,"Patrick"); > > Using mysql-max-3.23.47 for win98 how can i run it (with mysql monitor or > mysqlgui or sth else )? > > Thank you for your ansewrs > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
