Depends on the client you are using. If you are using the command line client under unix (and possibly Windows, I've never tried it) Put your SQL code in a file. Then type
mysql < filename Assuming you have a .my.cnf setup with your login and password, and you have permission to create databases, this should eat your SQL and execute it. If you are using Windows,check out mySQLyog. (Google it, they didn't put a URL in their About box) It's the best Windows client I've seen. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -----Original Message----- From: Kevin Passey [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 4:37 AM To: Mysql (E-mail) Subject: HOWTO Run SQL DDL in Mysql Hi, I have generated a database using Websphere Site developer and have created an SQL script to build my database. How do I run that on mysql so as to build my database automatically instead of keying all the commands on the command line to generate this. You guessed it I've just loaded mysql Kevin Passey --------------------------------------------------------------------- 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
