OS X binary

I just installed the 5.0.4 binary for OS X. Where's the client? It's not in my PATH. Surely I don't have to now download the source and compile the client myself? Dan BEGIN-ANTISPAM-VOTING-LINKS -- If you are not the CanIt administrator and

RE: Query Issue on Large DB

Hi Jenn, I suggest you use of this query : SELECT host, date, time, message FROM syslogTB WHERE host = '$host' ORDER BY date DESC,time DESC LIMIT " . $start . ", " . $numresults . ""); at the second stage, try adding an index date_time on syslogTB(date DESC,time DESC, host); Mathias Selon Jennif

RE: Query Issue on Large DB

Here how I created the table: CREATE TABLE syslogTB ( facility char(10), # OPTIONAL field for facility priority char(10), # OPTIONAL field for priority date date, # date of this log message time time, # time of this message host varchar(128), # host logging, If you have a host with

LGPL client libraries

I am wondering if there has been any work done on the last LGPL (3.23.58 I assume) version of the client libraries to modernize them? I've seen one project to do so, but it seems never to have gotten off the ground. I would also like to know what technical issues would surround trying to use the

Re: Query Issue on Large DB

Hi, have you a query sample + show create table + show indexes from ? Mathias Selon Jennifer Fountain <[EMAIL PROTECTED]>: > Hi, > I am new to the list and mysql for that matter. I am trying to > configure a centralized syslog server using mysql, msyslog and php. > Works great until the DB gr

Re: remote connection

Hi, haven't you added "identified by *" int he grant statement. I don't see it in your show grants comand. Mathias Selon Chris Faulkner <[EMAIL PROTECTED]>: > Hello > > I am trying to connect from host 192.168.0.8 on my home network to a > database on 192.168.0.7. When I connect as root on

remote connection

Hello I am trying to connect from host 192.168.0.8 on my home network to a database on 192.168.0.7. When I connect as root on 192.168.0.7 itself, I can do this mysql> show grants for 'root'@'192.168.0.8'; ++ | Grants for [EMAIL PROTECTED]

Re: MySQL give up on a query after a certain length of time

On 5/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > There is a variable called --network-timeout ! You can set it to 300 (5 > minutes, etc.). Don't you mean net_read_timeout? http://dev.mysql.com/doc/mysql/en/dynamic-system-variables.html SET SESSION net_read_timeout = 300; Thanks, Jacob

Re: constraints

Mathias, >The syntaxe is here, but the constraints seems not to be checked. Is this a bug >? i don't know ! >mysql> create table employee ( >-> name varchar(30), >-> salary numeric(10,2), >-> constraint check (salary > 0) >-> ); >Query OK, 0 rows affected (0.22 sec) 13.2.6 of the 5.0.4 manua

Re: constraints

>> The manual is your friend! I was trying to inform you but you were faster :o) An IF then insert in your application can do the trick. Mathias Selon Michael Stassen <[EMAIL PROTECTED]>: > The manual is your friend! CHECK constraints are not supported in > mysql. "The CHECK clause is parsed

Re: constraints

The manual is your friend! CHECK constraints are not supported in mysql. "The CHECK clause is parsed but ignored by all storage engines." . Using your example, you can easily verify this with SHOW CREATE TABLE: mysql> SHOW CREATE TABLE emp

Re: constraints

Hi, The syntaxe is here, but the constraints seems not to be checked. Is this a bug ? i don't know ! mysql> create table employee ( -> name varchar(30), -> salary numeric(10,2), -> constraint check (salary > 0) -> ); Query OK, 0 rows affected (0.22 sec) mysql> my