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 below
>>
>> set @t_name=now();
>> rename table amc t
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 MySQL server ve
rename table amc to concat('amf_',@t_name);
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 'concat('amf_',@t_name)' at line 1
On 7/10/08, Octavian Rasnita <[EMAIL PROTECTED]> wrote:
>
> Ha
