Hi,
I'd like to know if MySQL server supports http queries?
Thanks.
Kandy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi,
Is it true that the performance of running a query on a live replication
master and slave has to be much slower than running a query on a static
server?
I've tried to run the following query on a replication master and it
takes 1 min 13.76 sec to finish.
SELECT *, ABS(timeA-1266143632) a
Hi,
Is there a replication setup method just to replicate a specific
database not all the databases or exclude a specific database not to be
replicated?
Thank you.
Kandy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
Hi,
Is there a way to cache the MYSQL_RES in C++?
I've tried to develop a class with functions returning the MYSQL_RES,
MYSQL_ROW and MYSQL_FIELDS.
The functions work fine within the class file.
But if I call the functions where else, I'll either get 'Segmentation
fault' or 'bus error'.
Any i
le1 t
> WHERE timestamp_column <= '20080815091907'
> ORDER BY timestamp_column DESC LIMIT 1
> )
> UNION
> (SELECT TIMEDIFF(timestamp_column, '20080815091907') AS diff, t.* FROM
> table1 t
> WHERE timestamp_column >= '20080815091907'
> OR
so if that is what you are
> seeking for, I can help with PHP.
>
> Saul
>
> Kandy Wong wrote:
>> Hi,
>>
>> I need to write a C++ program in a Linux environment to query with a
>> timestamp.
>> The user will only provide with an approximate time so I'
Hi,
I need to write a C++ program in a Linux environment to query with a
timestamp.
The user will only provide with an approximate time so I'd like to know
how can I write a program or a query to return the closest data.
The followings are the timestamp in the MySQL database:
| 2008-08-05 03:56:0
I could be wrong.. but this is a guess..
event_type: 15 is update_rows_event which is used in mysql 5.1 and
later..
if mysqlbinlogs is an older version.. most likely it will produce an
error
because it does not recognize event_type 15 and is bombing out.
try it.
http://dev.mysql.com/doc
change the seed on the random function.
http://dev.mysql.com/doc/mysql/en/mathematical-functions.html
On Mon, 2005-10-03 at 08:33 -0700, Graham Anderson wrote:
> is there a way to make ORDER BY RAND() at bit more spontaneous ?
>
> I am using it in a php statement:
> $sql = "SELECT media.id,
>
more
> than 1MB, and depending on how oyu do the import can mean no mor ethan 1MB
> total data in a single batch.
--
Henry Wong <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All,
I'm confused by seemingly conflicting information between the mysql doc,
the high performance mysql book, and a mysql press release
(http://www.mysql.com/news-and-events/press-release/release_2003_05.html) regarding
mysql's SSL support. What's the difference between mysql 4.0's SSL suppor
Hi,
Is this possible to set a timeout value for mysql_query() call?
Regards,
- Joe
regards,
- Wong
Hi, may I know of the current MySQL python library supports MySQL cluster or not?
Regards,
- Wong
16777215
3. Insert another record without specifying the value of UID
At 3, it failed and said:
Duplicate entry '16777215' for key 1
But I have only 1 record in the table.
Regards,
- Wong
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[
Hi,
If it possible to limit the max value of an auto increment field to say, ,
and how to do it? I am using MySQL 4.0.18.
Regards,
-- Wong
Dear Marko,
It does look like the result of a gap lock, but notice that I used both
primary keys in the where clause of my update query, therefore it should
only match (and update) 1 row. From my understanding (correct me if I'm
wrong, my knowledge of how mysql works is gleaned from the mysql docs
Hi all,
This is my first time on the mysql mailing list, I appreciate if someone
can help me with a major problem I encountered with mysql.
I have this weird problem with 1 transaction locking out another for no
apparent reason and in an inconsistent fashion. I'm using mysql 4.0.18
with innodb ta
pls unsubscribe me from this maillist. thanks.
- Original Message -
From: "Andy Eastham" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Monday, September 15, 2003 8:54 PM
Subject: {Scanned} RE: random record
> 39?
>
> > -Original Message-
> > From: tuncay bas [ma
Hi
1- Is there a command to rename an existing database ?
2- If not, how does one create a new database from an existing database ?
could you show me the steps?
Any help is appreciated.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
Hi
How do I rename a new column ?
How do I drop a column ?
>From MySQL documentation, it refers
to rename/drop table.
I dont want to do that.
Thanks Paul for your aid.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi
1 - I have a column whose datatype is longtext. Its content is 08/06/2003;
I created a new column whose datatype is DATE. Its content is null now.
How do write a SQL statement that
inputs each row from 08/06/2003 in the
old column to 2003-08-06 in a new column ?
Eg:
old column name - my_date
ne
Hi
I have a database whose table has a column, which has a datatype longtext.
I then try a query
mysql> select MY_DATE from my_table where MLC_DATE between '09/22/2003' AND
'10/21/2
003';
I thought it would fail since the datatype isnt DATE nor TIMESTAMP.
But from the result, it seems to work.
1
ou for your time,
Scott Wong
Meiko America, INC
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FOREIGN KEY (parent_id) REFERENCES parent(id)
> ON DELETE CASCADE
> ON UPDATE CASCADE
> ) TYPE=INNODB;
>
> insert into parent set id=1;
> insert into child set id=1, parent_id=1;
> update parent,child set parent.id=parent.id+1, child.parent_id=parent.id
, child.parent_id=parent.id+1;
Thank you for your time.
Scott Wong,
Meiko America, INC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
ere parent.id=child.parent_id;
now i get
ERROR 2013: Lost connection to MySQL server during query
mysql>
Number of processes running now: 0
030213 15:54:20 mysqld restarted
regards,
Scott Wong
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February
et id=1, parent_id=1;
insert into grandchild set id=1, child_id=1;
delete parent,child from parent,child where parent.id=child.parent_id;
ERROR 1105: Unknown error
fix
?
Thank you for your time
Scott Wong
Meiko America
Wong
Meiko America, INC
-
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]>
To unsubscr
>
>Hi,
>
>I am currently running mysql-3.23.52-3 on Linux 8.0 and myodbc 3.51.05 on win2000
>machines
respectively.
>Users and host IP has been setup on mysql, and innodb has been setup with as below.
>
>innodb_data_file_path = ibdata1:10M:autoextend
>set-variable = innodb_buffer_pool_size=70M
>
;
The intesting thing is this :
show create table child;
FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON UPDATE CASCADE,
FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON DELETE CASCADE ON UPDATE
CASCADE
fix
?
Thank you for your time
Scott Wong
Meiko America, INC
.
Fix?
Scott Wong,
Meiko America, INC
-
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 PROTEC
Hi
I have a few tables in a database Z, namely
table
a
b
c
In table a, the columns are
my_date - longtext
num - int(11)
eg:
mysql> select * from a;
+--+--+--+
| my_date | x|
+--+--+
| 08/06/2002 |1 |
| 08/07/2002 |2 |
+--+--+--
Dear Sir,
I am very new to the mySQL product. I am trying to do some R&D on the
possibility to port the MS SQL to mySQL for our system. I have tried with
mysql-3.23.53-win. I able to start the mySQL and run the mysqlshow command
and others.
However, if I try with the mysql-max-4.0.4-beta-win, I s
base is faster.
Our development here is currently focused on SAP DB, but this does not
mean we want it to exclusively work with that database. We would love
(and appreciate) any help to adapt it to work with SAP DB. Please
contact us if there is any interest.
Thanks,
Mark
--
Mark Wong - - [E
g what are some downfalls
on this idea?
Thank you.
Scott Wong
System Administrator
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
> -Original Message-
> From: Wong Zach-CHZ013
> Sent: Wednesday, May 22, 2002 7:11 PM
> To: [EMAIL PROTECTED]
> Subject: Duplicate Record
>
> Hi
> 1) Suppose, in a file, say testfile.sql,
> it contains a line
> eg:
> LOAD DATA INFI
Hi
1) Suppose, in a file, say testfile.sql,
it contains a line
eg:
LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ;
And further suppose the record in file mlc_stat_ already exists in the
table mlc.
Does MySQL have the ability to stop inserting this duplicated record
Hi
1) Suppose, in a file, say testfile.sql,
it contains a line
eg:
LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ;
And further suppose the record in file mlc_stat_ already exists in the
table mlc.
Does MySQL have the ability to stop inserting this duplicated record
contributing to the project to make it work with MySQL. For more
details on the project, please see:
http://www.osdl.org/projects/performance/osdldbt.html
--
Mark Wong - - [EMAIL PROTECTED]
Open Source Development Lab Inc - A non-profit corporation
15275 SW Koll Parkway - Suite H - Beaverton OR, 97006
(503
contributing to the project to make it work with MySQL. For more
details on the project, please see:
http://www.osdl.org/projects/performance/osdldbt.html
--
Mark Wong - - [EMAIL PROTECTED]
Open Source Development Lab Inc - A non-profit corporation
15275 SW Koll Parkway - Suite H - Beaverton OR, 97006
(503
mysql functions as per the
manual examples and you'll soon find where the error is.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
I'm having an emotional outburst!!
*/
-
Before posti
I try to run the import test as listed in the document.
mysqlimport: Error: The used command is not allowed with this MySQL version,
when using table: imptest
My server version: 3.23.49.
What is the problem? How can I fix it?
Thanks!
Danny
-
h this name "'w4-1".
>
> But, i can't create the table with this name. The request is rejected.
>
> Has anybody an explanation ?
>
You need to enclose the table name with backticks, eg:
CREATE TABLE `w4-1` (
name varchar(10) NOT NULL default '',
category order by rnd;
+--+---+
| category_description | rnd |
+--+---+
| Figure | 0.200211824104387 |
| Magnet | 0.565105185438977 |
| Feng Shui| 0.811984655272201 |
| Candle | 0.953237160996755 |
+---
ed
result[$key_field_val][$key]::$result[$key_field_val][$key]"; }
else {
#$result[$key_field_val][$key] = $field; echo "Assigned
result[$key_field_val][$key]::$result[$key_field_val][$key]";
$tmp[$key] = $field; #echo "Assigned
result[$key_field_val][$key]::$result[
url is not null
>
> order
>
> > > by rand() limit 1");
> > > I have tried everything, but nothing seems to work. Can anyone help.
> > >
> > > Rob
The solution presented by Kodrik does work. What is the problem?
--
Jason Wong -> Gremlins As
t
> there're defaults files for My.cnf like /etc/my.cnf or datadir/my.cnf or
> ~/.my.cnf, but still i couldn't find that file.Please i need some advices.
It's OK, if they're not there, just create one.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
QOTD
ne has to write his own program to do
> this.
You can use something like this:
SEC_TO_TIME(UNIX_TIMESTAMP("2001-11-03 16:11:50") -
UNIX_TIMESTAMP("2001-11-03 15:48:00"))
which would return
00:23:50
hth
--
Jas
DATE/TIME field then
HOUR(myfield) will extract the hour portion from myfield.
Thus you can have
WHERE HOUR(myfield) = 14
will select only those rows in myfield where the time is 2:XX PM.
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
The Abrams' Principle
above)
SELECT * FROM table WHERE category LIKE '%christmas%'
should do the trick.
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Horngren's Observation:
Among economists, the real world is often a special case.
*/
--
On Thursday 29 November 2001 02:01, Auri Net SAC wrote:
> Hi
>
> please who knows a package that install apache + php + mysql in linux,
> i know phptriad but its for windows
> Thanks for your answer
> rvj
>
ApacheToolBox http://www.apachetoolbox.com
--
Jason Wong -
eness it should be usable if you do not have too many rows to
deal with.
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Baker's First Law of Federal Geometry:
A block grant is a solid mass of mone
g
In your form, you should name your multiselect fields as "name[]". In
your case it would be "zimmermulreg[]". This would then give you an
array when the form is submitted and thus make implode happy.
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
d what I am suppose to do with
> it. I type in commands and it just does another -> What is that?
The -> indicates that it is waiting for the rest of the query. You need
to end each query with a semi-colon. Thus:
mysql> show tables;
hth
--
Jason Wong -> Gremlins Associates ->
ould be returned should be:
>
> 4385 - 1
> 4513 - 2
> 4382 - 3
> 4533 - 7
try:
SELECT MAX(storyID), storyCategoryID, title
FROM newsStories
GROUP BY storyCategoryID;
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
HR 3128. Omnibus Budget Re
amounts of text, since TEXT data
> type does not support binary encoding?
>
> lease ... or i´ll do harakiri
You could try using a BLOB.
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
"After one week [visiting Austria] I couldn't wait to go back to
omains(
dName,
payPrYr,
nextPayDay,
timeCreated)
VALUES(
'$domainName',
'$payPerYear',
'$nxtPayDay',
'$tid')&qu
RY = "INSERT INTO bandbook (user, ect1, ect2...)
VALUES ('$userdb', '$ect1', '$ect2', ...)";
print("$QRY"); ## For debugging
$rows=$dbh->do($QRY) || die "Error";
hth
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
---
e as well.
hth
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
n
> Linux. I have a concatenated primary key of multiple fields. And I
> also have a unique index on each of these fields. There are
> 1,734,291 bytes of data in the table with an average row length of
> 61.
Sometimes it's quicker to drop the indices, insert your data, then
recreate the i
Hi
I'd like to be able to input pinyin and Big5 Chinese characters into mysql using Jive
discussion forum software, e.g. I would input both English and Chinese into the same
field.
After reading some past postings I understand that I only need to load Chinese
language support if I want to do
i am using
redhat 7.1 (i386-smp)
kernel 2.4.6
gcc 3.0
mysql 3.23.40
./configure --prefix=/usr/local/mysql --with-charset=big5 --with-mysqld-user
=mysql
i have the following error, could somebody help me?! thank you very much.
c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr
> Looks correct to me. Try running this query from the mysql program
> to verify that you're really matching the password of some entry:
>
> mysql> SELECT *, password('mypass') FROM user;
Hi guys,
I've solved the problem, but it was something related to the password
function.
In my user table,
> >PHP4> mysql_query("select * from user where username='myname' and passwd
=
> >password('mypass')");
>
> Define "doesn't work". Fails to return rows? PHP generates an error
>message?
Hi Paul,
Sorry bout that. Yes it doesn't return any rows despite the fact that the
correct username and pass
Hi there,
For some reason, this query doesn't work:
PHP4> mysql_query("select * from user where username='myname' and passwd =
password('mypass')");
WHILE this one does work:
PHP4> mysql_query("select * from user where username='myname' and
password('mypass')");
Notice the lack of "passwd = "
Dear Sir,
The Create Table function is not working. Any steps that I need to
take besides creating a database first.
Yew Peng
Singapore
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
htt
i initially had a master-host=A defined in my.cnf.
later i changed that to master-host=B.
i was mystified when i got a connection error:
Slave thread: error connecting to master:Host 'dumbo.pobox.com' is not allowed to
connect to this MySQL server(0), retry in 60 sec
i spent much time pro
Hey,
I have no idea why my "mysql' server keeps giving me ERROR 2000 no matter
what I type. I have checked the syntax not seems alright. Would you please
show me some light?
Thank you for you help!
Edith Wong
Chinese University of Hong Kong
Tel: 852
ble, I'd like to
avoid having to run 2 instances of the mysql daemon, and consequentually 2
instances of the Apache daemon as well.
Thanks for any answers
Wong
-
Before posting, please check:
http://www.mysql.com/manual.
I try to use the replication feature of the latest stable version 3.23.32. Everyting
works find when I follow the instructions until when I tried to stop the slave and
then start it. It generated the following messages in the error log:
010212 18:28:08 mysqld started
/vol2/mysql/libexec/m
i can not connect coldfusion with mysql database , the connection is alwasy
failed
can any one help ?
thanks
wong
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
how to i change the default connection from unix socket to tcpip 3306 ?
currently is connection = localhost via unix socket
thanks
Wong
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
hi
i have setup a mysql database foo_db and when i goto admininstrator of
coldfusion
to setup the odbc, the databsourse is foo_db and i select merant mysql
drive, then click
add.
the verify is fail
can anyone tell me what am i does wrong ?
i using linux 6.2, coldfusion pro 4.5
thanks
Wong
It's gives me correct result (integer value 11) on my FreeBSD 3.5, FreeBSD
4.2 and Debian Linux 2.2 Machine
- Original Message -
From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "MySQL mailinglist" <[EMAIL PROTECTED]>
Sent: Thursday, February 08, 2001 1:15 AM
Subje
If all tables name are unique, and if you can bear the downtime, just shut
down the server and copy the files of one of the database to another
database will do
- Original Message -
From: "Andrew Dennison" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 11:21
You've got 1G Ram!
Guys, take a look at the my-huge.cnf in the mysql tree (I've forgot which
folder)
- Original Message -
From: "Matis, Jan" <[EMAIL PROTECTED]>
To: "'Sam Wong'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wed
keybuffer=0?
tablecache=0?
For complicated query, Mysql may search the harddisk for stuff again, the it
holds the query for sometimes...and then some more connection come in, as a
result, more ram and cpu is consumed
May I suggest you to lower down the max connection, and tune up the
caching/buff
The I/O may not be as fast as the CPU, so it can't use up the CPU
- Original Message -
From: "Tim Samshuijzen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 11:03 PM
Subject: idle CPU
>
>
> Hello,
>
> We're running a large database on a dedicated server
> So why isn't the --with-raid option set in the binary download version?
The file will be bigger and slower in result
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
blize already, I think.
BTW, why you want it to span over multiple drive?
- Original Message -
From: "Jason Frisvold" <[EMAIL PROTECTED]>
To: "'Sam Wong'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 7:15 PM
Subject: RE:
Compile mysql with --with-raid option, then use symbolic link to link it to
other drive
- Original Message -
From: "Jason Frisvold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 6:33 PM
Subject: MySQL Tables over Multiple Drives
> I looked through the manua
Personally speaking, if the index > 256, it will lost the meaning of
indexing...
- Original Message -
From: "Jeremy D. Zawodny" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 3:06 PM
Subject: Re: ERROR 1170: BLOB column 'Url' used in key specification without
If you've upgraded the perl to 5.6.0, you've to reinstall the modules
- Original Message -
From: "Don Hargroves" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 11:15 AM
Subject: MySQL Perl DBI/DBD
> I have followed the instructions at
> http://
I bet your webserver and database server are seperate machine.
Make sure the hostname of web and db are in the /etc/hosts on both machine,
it's very slow to use DNS to resolve everything
- Original Message -
From: "Leonardo Dias" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, J
00 1MB Cache, with 1G ram on board
It's slow because it contains many files. i.e. Reading a big files is always
faster than reading many small files
- Original Message -
From: "Artem Koutchine" <[EMAIL PROTECTED]>
To: "Sam Wong" <[EMAIL PROTECTED]>; &
It's quite fast for tar, just around 10-20 minutes. But it's unacceptable
slow when untar, more than 3 hours! I just want to know if there's any
efficient way to do that...
- Original Message -
From: "Lars Schioler" <[EMAIL PROTECTED]>
To: "Sa
I know this question may not be mysql related, sorry.
I would like to know what's the faster way to duplicate all database to
another machine. I've over 10 tables in each three database, it's very
slow to use cp, and very slow to when untar (over 3 hours!)
Do you have any solution?
Thx in ad
I've heard that redhat 7 is not that good. They implant many beta version
code inside.
Sam
- Original Message -
From: "Mike Tuller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 27, 2001 9:10 AM
Subject: Error 2002: can't connect to mysql.sock
> I recently upgrade
I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2 Xeon
400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID
The traffic of it is about 300 queries/second on average, and keep staying
at around 400 q/s at night.
The problem is that, it core dumps in 5-10 mins, especially at night (high
traf
I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2 Xeon
400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID
The traffic of it is about 300 queries/second on average, and keep staying
at around 400 q/s at night.
The problem is that, it core dumps in 5-10 mins, especially at night (high
traf
91 matches
Mail list logo
