How fast replication

Hi. How fast or what about time different between master and slave suppose when I insert row into master and then select from slave in replication environment. both machine have all the same specification Thank. Kittiphum Worachat. -- MySQL General Mailing List For list archives: http

Re: default character set

Victoria Reznichenko wrote: Kittiphum Worachat [EMAIL PROTECTED] wrote: Try to set character set to other not latin1 with MySQL 5 (windows binary) it not work can some one tell me how to do this. If you want to set character set on the server level, you should start mysqld

Re: default character set

Victoria Reznichenko wrote: Starts fine for me from command line: C:\mysql\binmysqld-nt.exe --default-character-set=tis620 --standalone --console 040122 14:36:50 InnoDB: Started; log sequence number 0 43634 mysqld-nt.exe: ready for connections. Version: '5.0.0-alpha-nt' socket: '' port: 3306

default character set

Hi. Try to set character set to other not latin1 with MySQL 5 (windows binary) it not work can some one tell me how to do this. Thanks Dr.K -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem with order by

is the mistake I do ?? I mean , = , = it OK but for it not OK. Both of my problem base on version 4.0.15 Thanks. Kittiphum Worachat,M.T. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Max_connections problem

this privileges or not and if has how to login with this option or if not has this privileges how to set this privileges. Thanks Kittiphum Worachat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Max connection

PROCESS_ACL privileges) if yes is root have PROCESS_ACL privileges and how to use to login with mysql client program or if root has not this privileges be default how to grant this for root or how to make a login ? Thanks Kittiphum Worachat,MT. -- MySQL General Mailing List For list archives: http

Binary column index

varchar instead of varchar ??? (if not use it corrupt why it corrupt ) Thanks Kittiphum Worachat,MT. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't set thread stack with ver 4.0.14

Hi. I try to set thread stack with ver 4.0.14 it never success the stack size still 128K (I can do with the same command with ver. 4.0.12 it work) The command is put in my.cnf like this set-variable = thread_stack = 512K how to set with ver 4.0.14 thanks Kittiphum Worachat -- MySQL General

Default character set error

for connect to MySQL server with out error (due to MySQL4.1 use 32 bit encryption) Thanks Kittiphum Worachat. -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECT single record

/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] add keyword limit 1 at the end of your sql like this select from limit 1 Kittiphum Worachat

Re: Need to cron an sql query

:00 a.m. Linux will cal MySQL to do that you want Kittiphum Worachat

Have some problem with Ver 4.0.13

the same problem occur on RedHat 8 that how to solve is add the line set-variable=thread_stack=256k in my.cnf ( I use with RedHat 8 it work so I try this with RedHat 9 it not work) Now I normaly use RedHat 9 and MySQL 4.0.12. Thanks Kittiphum Worachat. -- MySQL General Mailing List

re: Delete from sub select

have this option What happen and how to solve this. Thanks. Kittiphum Worachat,M.T - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

MySQL 3.23.49 Merger table

Hi. Why merge table have been done with table that have column char type not varchar type. Have anyone succesfully with varchar type merge table and how to do that. And how to use union query if merge table not work with varchar or what SQL to use for convert varchar back to char Kittiphum

Autorefresh MyODBC

Hi. Can we use Access to link table in MySQL and force Access to refresh data from MySQL automatically when data in MySQL table have change. Kittiphum Worachat,M.T. www.hatyailab.com - Before posting, please check: http

Age calculation

Hello, mysql, How to get Age from field date-time that contain dateofbirth and then display as xx year yy month zz days. Best regards. Kittiphum Worachat [EMAIL PROTECTED] 2002-05-15 - Before posting, please check

Re: Re: Age calculation

seen it before but it not my answer. I really want to get result something like your age are 30 years old 6 month and 15 days. is it possible with SQL. Best regards. Kittiphum Worachat [EMAIL PROTECTED] - Before posting

Error code 28

' group by b.f2 if f2.b if mediumtext I will got error 28 but when change type to varchar it OK but I realy need mediumtext type how to solve this problem Best regards. Kittiphum Worachat [EMAIL PROTECTED] 2002-05-13

Re: RE: Error code 28

Hi Rahul Torvi, and MySQL user group you can use perror 28 to see what does that error code mean Rahul T -Original Message- From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 10:50 AM To: [EMAIL PROTECTED] Subject: Error code 28 Hello, mysql, In select

Re: Re: Error code 28

Worachat,M.T. www.hatyailab.com On Monday, 13. May 2002 07:20, Kittiphum Worachat wrote: Hi, In select field list if they have some field that field type is text or blob and if I use group by some filed MySQL will generate Got error 28 from table handler the query like this select a.f1,a.f2,a.f3

Re: Multiple updates

. Kittiphum Worachat,M.T. www.hatyailab.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Re: Multiple Inserts

Hi. insert into mytable (id,name,job_number,job_date) values ('1','Mark','AA1','2002-04-15'),('2','Mark','AA2','2002-04-16'),('3','Mark', 'AA3','2002-04-17'), Kittiphum Worachat,M.T. www.hatyailab.com Does anyone know if it's possible to insert mutilple records into 1 table in one

Re: Howto: insert PHP code into mysql blobs

write php code in to text file (or php script) such as mycode.txt and then use insert into mytable values (load_file('/path/path/mycode.txt')); it must be simple done. Kittiphum Worachat,M.T. www.hatyailab.com - Before

Replication problem

Hi. I got the problem with replication if I use SQL command LOAD DATA INFILE... to update data in master table the data change to the new one correctly but in slave table nothing happen the data still have the old value. how to solve this problem ?? Kittiphum Worachat,M.T. www.hatyailab.com

Re: Insert from select

. Something like insert into table_a from select * from table_b where blah=somevalue Thanks, David McInnis query like; insert into table_a select * from table_b where blah=somevalue Kittiphum Worachat,MT. www.hatyailab.com

Re: update data from other table

HI Hi, How to update data in table with data from other table in single SQL command (without using loop)? Sommai, insert into table1 select * from table2 Kittiphum Worachat,MT. www.hatyailab.com - Before posting

Re: update data from other table

Hi. Try to use replace if you have unique key index and both table have the same structure: and query like, replace into tableA select * from tableB Kittiphum Worachat,MT. www.hatyailab.com - Before posting, please check

Re: How to read blob field data as picture and display on browser?

']; Kittiphum Worachat,MT. www.hatyailab.com Thailand. OK, I know how to insert the data into a database, now how can i retrieve it and display it in client's browser? Thanks ST Ooi Malaysia - Before posting, please check

Re: How to insert a picture into a blob field

Hi You can use load_file() such as sql=insert into xxx (fld_blob) values (load_file('xxx.jpg') Kittiphum Worachat ,MT. www.hatyailab.com How can I insert a picture into blob field of a database? Thanks ST Ooi Malaysia

Re: index problem

can't get the benifit of index Kittiphum Worachat,MT. www.hatyailab.com Hi, I have problem with these query: select * from holder, management where holder.id=management.id or (holder.name=management.name and holder.surname=management.surname) order by holder.no It take a long time (more than

Function in index

syntax error ALTER TABLE xxx ADD INDEX yyy (BDATE(4)) error the used key part isn't string ALTER TABLE xxx ADD INDEX yyy (BDATE) OK but I don't want this Thanks. Kittiphum Worachat,M.T. www.hatyailab.com - Before

Re: Help with join

; or SELECT f.freq1, f.ctcss1, f.callsign, a.agency FROM frequencies as f,agencies as a WHERE f.uid = a.uid; Kittiphum Worachat www.hatyailab.com - Before posting, please check: http://www.mysql.com/manual.php (the manual

Function in index

Hi. Is it possible to use function such as year() in index key (like use subpart for string field that it work) I try this ALTER TABLE XXX ADD INDEX YYY (Year(DoBirth)); --- error syntax error ALTER TABLE XXX ADD INDEX YYY (DoBirth(4)); --- error used key part isn't string Thanks. Kittiphum