Re: Include SQL files

2009-04-01 Thread Jørn Dahl-Stamnes
On Wednesday 01 April 2009 16:49, Eugene Kosov wrote: > What about source? > > > use foobar; > > source some/dir/file1.sql; > source some/dir/file2.sql; > ... Gee... why did I not find that on google? :D Thanks... this give me control of the order of the files, which can be important. -- Jørn

Re: Include SQL files

2009-04-01 Thread Eugene Kosov
What about source? use foobar; source some/dir/file1.sql; source some/dir/file2.sql; ... Though, your solution is much simplier. Michael Dykman wrote: No include is possible, but this is done pretty routinely: cat *.sql | mysql ... - michael dykman On Wed, Apr 1, 2009 at 10:19 AM, Jør

Re: Include SQL files

2009-04-01 Thread Michael Dykman
No include is possible, but this is done pretty routinely: cat *.sql | mysql ... - michael dykman On Wed, Apr 1, 2009 at 10:19 AM, Jørn Dahl-Stamnes wrote: > Hello, > > After googling for an hour I gave up to find a solution. > > Problem: A framework is creating a lot of SQL files that will c

Include SQL files

2009-04-01 Thread Jørn Dahl-Stamnes
Hello, After googling for an hour I gave up to find a solution. Problem: A framework is creating a lot of SQL files that will create the database. But I'm tired of doing 10-20-30 'mysql -u... < file.sql' each time I rebuild the model. What I want to do is to create a sql file like: use foobar