|
Hi Rasmus
I think it an issue with including multiple sql commands in one
var...
as i see it...:
the drop table bit is one coomand and the create table is one
command.
When i run these with or with the seperating ; it comes back with the
mysql error.
What i am trying to do is in thery simple.
Dump structure and dat from a table with drop table command to a .txt
file
then load it back in via my script.
I have tried infile, file() and straight forward global var to no
avail.
4 hours of searching the net has'nt yeild any working light on this
issue and i am confident this is not rocket science just me giong about it
the wrong way.
The load from file would be the best result for me.
Any pointer and or code example would be most appreiciated.
Thank You
Dave C
-------Original Message-------
Date: Sunday, May 26,
2002 16:20:39
Subject: Re: [PHP-DB]
db sql issue from var
Well, where is your ';'? At the end of the statement? You
don't
terminate queries with semi colons when talking directly to the
database.
Just remove it.
-Rasmus
On Sun, 26 May 2002,
Dave Carrera wrote:
> Hi All
>
> I have found the
problem from my last post and need to know how to solve
it.
>
> Example sql var:
>
> $sql
> When i
run the script i get
>
> Mysql error near ';' create
table......
>
> So how do i run this command from my script to
include the ; as part of the
> sql.
>
> phpmyadmin copes
with this ok so it must be able to be done.
>
> Thanks for any
help in advance
>
> Dave C
>
>
> --
>
PHP Database Mailing List (http://www.php.net/)
> To
unsubscribe, visit: http://www.php.net/unsub.php
>
. |
