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
Victoria Reznichenko wrote:
Starts fine for me from command line:
C:\mysql\bin>mysqld-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
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 mysql
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]
it will scan from ALL record what 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]
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]
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
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]
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
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]
l.com/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
crontab -l
and now every 00:00 a.m. Linux will cal MySQL to do that you want
Kittiphum Worachat
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
For
NTO t2 (message) VALUES ("Testing"),("table"),("t2");
CREATE TABLE total (a INT AUTO_INCREMENT PRIMARY KEY, message
CHAR(20))
TYPE=MERGE UNION=(t1,t2);
it work but when I insert data into merge table i got
Error: 1031 - Table handler for 'total
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
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
t;> display as xx year yy month zz
>
>days.
>>
Yes I have ever 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 poss
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
tiphum 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
>>
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: Erro
a.f1='xxx'
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 P
r die.;
$sql = "UPDATE mytable set job_date='$job_date2' where job_number
='$job_number2'";
@mysql_query($sql, $connection) or die.;
$sql = "UPDATE mytable set job_date='$job_date3' where job_number
='$job_number3'";
@m
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 W
k if you 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
--
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.hat
;],"",number_format($row['Rows']),"";
}
echo "";
mysql_close ($conn);
?>
you will see the result in table (tag html) format with the name of data
table and it's number of records.
Kittiphum Worachat,M.T.
www.hatyailab.com
- Original Message --
it possible to insert from a 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
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
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
-
echo $row['fld_blob'];
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
--
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
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?
>
>
ng
Thanks.
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
s1, f.callsign, a.agency
FROM frequencies as f
INNER JOIN agencies as a ON f.uid = a.uid;
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
BDATE)) > error 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 Woracha
35 matches
Mail list logo
