multiple mysql tables
Hi, This may be more of a MySQL question than a Zope one. Is there an easy way to create multiple MySQL tables all in one shot without calling an outside shell script or something.
From what I've seen, MySQL can only accept one CREATE statement at a time. But I'd really like to put them all in one file.
Thanks, Jacob
Jacob Behm wrote:
From what I?ve seen, MySQL can only accept one CREATE statement at a time. But I?d really like to put them all in one file.
So have a Python Script call multiple ZSQL Methods. ...and stop posting in HTML! Chris
Did you put <dtml-var sql_delimiter> between the create statements in your code? -Casey On Tuesday 20 August 2002 12:28 pm, Chris Withers wrote:
Jacob Behm wrote:
From what I?ve seen, MySQL can only accept one CREATE statement at a time. But I?d really like to put them all in one file.
So have a Python Script call multiple ZSQL Methods.
...and stop posting in HTML!
Chris
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Now that's helpful .. thank you very much. - Jacob -----Original Message----- From: Casey Duncan [mailto:casey@zope.com] Sent: Tuesday, August 20, 2002 1:26 PM To: Chris Withers; Jacob Behm Cc: zope@zope.org Subject: Re: [Zope] multiple mysql tables Did you put <dtml-var sql_delimiter> between the create statements in your code? -Casey On Tuesday 20 August 2002 12:28 pm, Chris Withers wrote:
Jacob Behm wrote:
From what I?ve seen, MySQL can only accept one CREATE statement at a time. But I?d really like to put them all in one file.
So have a Python Script call multiple ZSQL Methods.
...and stop posting in HTML!
Chris
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (3)
-
Casey Duncan -
Chris Withers -
Jacob Behm