If ur storing "ALPHANUMERIC" values, then use varchar instead of TEXT
On 7/11/08, Waynn Lue <[EMAIL PROTECTED]> wrote:
>
>
>
> On Mon, Jul 7, 2008 at 4:20 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
>> Yes, i definitly agree on the third table if "APPLICATION FUNCTIONALITY"
>> increase and need
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
Shaun,
Purge master logs is available in 4.0 it just doesn't have the
"before" key word. It should be trivial to write a script that decides
which log file to purge based on the mtime.
-Eric
On Thu, Jul 10, 2008 at 12:15 PM, Shaun Adams <[EMAIL PROTECTED]> wrote:
> I'm running a RHEL 4.1 and MyS
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
my sql version is
mysql> select version();
+--+
| version()|
+--+
| 5.0.24a-standard-log |
+--+
1 row in set (0.00 sec)
linux kernel 2.6.11.6
Changying Li <[EMAIL PROTECTED]> writes:
> I set a master and a slave, master s
I set a master and a slave, master server is a live server, slave server
does't online. but I got 1062 error frenquently, especially when I stop
slave a while and start slave again. following is from my general log:
19 Query insert into user_stat
(column_name,user_id,c
On Mon, Jul 7, 2008 at 4:20 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Yes, i definitly agree on the third table if "APPLICATION FUNCTIONALITY"
> increase and need to add more columns into the current tables.
>
> On 7/7/08, metastable <[EMAIL PROTECTED]> wrote:
>>
>> Ananda Kumar wrote:
>>
>>>
I'm running a RHEL 4.1 and MySQL 4.0.26
so a lot or the more recent commands available in 5.0.x aren't available to
me. Does anyone know of any scripts or anything I can use to delete files
that arent being used or run by my slave servers? It's pretty safe to say
that I can delete log files o
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.
Warren Windvogel wrote:
> Hi,
>
> Is there a way to force mysql to import a dump which contains a mysql
> reserved word as a field name?
>
> Regards
> Warren
>
You can use "sed" to replace column names with other.
for example:
sed 's/timestamp (timestamp) not null/datetime (timestamp) not null/g'
w
Hi,
Is there a way to force mysql to import a dump which contains a mysql
reserved word as a field name?
Regards
Warren
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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 right syntax to
Hi all,
I woke up this morning to find that our main database had stopped
responding so I jumped on to see what was going on. MySQL was no
longer running and the error log contained lots of...
<---
InnoDB: Warning: a long semaphore wait:
--Thread 39439068816 has waited at trx0trx.c line 715
Hi Andrew, all !
AndrewMcHorney wrote:
Hello
I downloaded some of the document files but the file extension is rpm.
How does one extract this file?
If you are on an RPM-based Linux system (like SuSE, RedHat, etc), you
need not "extract", you can "install" - using the "rpm" program.
See "m
17 matches
Mail list logo
