On Friday 05 October 2007 16:50, Arun wrote: > Baron, > I am sourcing it. I do not know if that is the best way though.. I am > running the insert statement from a mysql prompt in a linux/windows > machine. > My script has a single build script which sources other scripts. > build.sql > ====== > source ./ddl/useraccount/useraccountddl.sql > source ./mobchannel_db.sql > source ./ddl/usercontent/usercontentddl.sql > source ./ddl/userinfo/profilesddl.sql > source ./ddl/system/systemddl.sql > source ./ddl/shopping/retailitem.sql > source ./ddl/shopping/shoppingddl.sql > source ./ddl/rewards/userrewardsddl.sql > source ./ddl/location/locationddl.sql > source ./ddl/listing/listingddl.sql > =========================== > I will cd into the directory which contains the sql (so that '.' gets > resolved) and do a mysql -u root -p and enter password and do a > mysql>use dbname; > mysql>source build.sql; > > ERROR 1064 (42000): You have an error in your SQL syntax; check the manual > that corresponds to your MySQL server version for the right syntax to use > near ')' at line 8.
foreach source do source <file> fix any error until no errors -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]