Hi All,
I used the prepare statement in mysql and it worked.
Thanks for all your help and suggestions.
regards
anandkl
On 7/11/08, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> I could not find it, when i tried the above
>
> find / -type d -name mysql-test
>
> But i looked at the prepared statemen
I could not find it, when i tried the above
find / -type d -name mysql-test
But i looked at the prepared statements in mysql, i try that and get to you
all.
regards
anandkl
On 7/10/08, Joerg Bruehe <[EMAIL PROTECTED]> wrote:
>
> Hi Ananda,
>
>
> Ananda Kumar wrote:
>
>> Hi Joerg,
>> Can you ple
Hi Ananda,
Ananda Kumar wrote:
Hi Joerg,
Can you please let me the correct path to find mysql-test/t grep -i
'prepare.*@' *.test
no, I cannot - I do not know where you installed MySQL, and which
package you used.
Just do
find / -type d -name mysql-test
and the system will tell you.
Hi Joerg,
Can you please let me the correct path to find mysql-test/t grep -i
'prepare.*@' *.test
regards
anandkl
On 7/10/08, Joerg Bruehe <[EMAIL PROTECTED]> wrote:
>
> Hi !
>
>
> Ananda Kumar wrote:
>
>> Hi All,
>> I was to rename a table as belo
Hi !
Ananda Kumar wrote:
Hi All,
I was to rename a table as below
set @t_name=now();
rename table amc to concat('amf_',t_name);
but i am getting below error. How do i fix this.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your My
nita <[EMAIL PROTECTED]> wrote:
>
> Have you tried:
>
> rename table amc to concat('amf_', @t_name);
>
> Octavian
>
> - Original Message -
> From: "Ananda Kumar" <[EMAIL PROTECTED]>
> To: "mysql"
> Sent: Thursday, July 10
Hi All,
I was to rename a table as below
set @t_name=now();
rename table amc to concat('amf_',t_name);
but i am getting below error. How do i fix this.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the ri
