Fwd: Load data infile...

This is using MySQL version 3.23.49 I think I'm bringing this up again but with different errors. This: $sql = LOAD DATA INFILE '$file' REPLACE INTO TABLE `jobs` FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '' LINES TERMINATED BY '\\r\\n'; is getting

Load data infile...

I think I'm bringing this up again but with different errors. This: $sql = LOAD DATA INFILE '$file' REPLACE INTO TABLE `jobs` FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '' LINES TERMINATED BY '\\r\\n'; is getting the error Access denied for user:

Re: AW: [PHP] How to argue with ASP people...

FOAD Quoting Freddie Sorensen [EMAIL PROTECTED]: Tony, Check out ASP.NET and you will want to forget everything about PHP ;-) Freddie -Ursprüngliche Nachricht- Von: mail.pmpa [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 31. Dezember 2004 03:27 An: mysql@lists.mysql.com

SELECT question

| 237|1256 | Chicago | IL | 244|945 | Chicago | IL | 355|2987 | Boston | MA | I need a query that would give me the one with highest ID i.e. host no. 945? Thanks for any help. Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Newbie question about index (why are they not updating?)

I've created a table with several indexes as follows: $query = CREATE TABLE `data_raw` ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, run_id VARCHAR(20) DEFAULT 'error_internal' NOT NULL, time_run DATETIME DEFAULT '-00-00 00:00:00' NOT NULL, ...clip. PRIMARY KEY (id), INDEX x_run_id (run_id),

When to cluster vs. replicate

look to employ it instead of replication? I'm thinking I really don't need clustering as my transactions are plenty fast and don't seem to overload my server am I right? Thanks for any help. Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

SELECT based on TIMESTAMP (DATETIME)

Hello! I need to pull records from the db where the timestamp column (2004-11-01 00:00:00) greater than November 1, 2004 WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) = a.createdate doesn't work DATE_SUB(CURDATE(),INTERVAL 30 DAY) = a.createdate doesn't work a.createdate '2004-11-01 00:00:00'

Help with installation: MySQL, FreeBSD 5, Sparc64

Hi There, I am having trouble installing MySQL on my system (Netra X1 - UltraSparc II - FreeBSD 5). I can't find any documentation on how to install for this system, nor can I find the binaries. Thanks for any help!! Richard

Help with installation: MySQL, FreeBSD 5, Sparc64

Hi There, I am having trouble installing MySQL on my system (Netra X1 - UltraSparc II - FreeBSD 5). I can't find any documentation on how to install for this system, nor can I find the binaries. Thanks for any help!! Richard

InnoDB Log and binlog files and Solid State Disk?

else other than perhaps temp table space that I might consider placing on SSD? Any input is appreciated. Thanks, Richard signature.asc Description: This is a digitally signed message part

Re: newbie: relationships between fields

stands for company ID, tie these two fields together select * from CONTACT,COMPANY where COMPANY.coID = CONTACT.company_id try that for starters Richard I want the field contact.employer to link to a specific company record. In Access I'd set up a lookup in the field contact.employer, linked

Re: Problem connecting to MySQL 4.1.7 running on another machine

. The error I receive is: Could not connect to the specified instance. MySQL Error Number 2003 Can't connect to MySQL server on 192.168.0.11(10060) Thanks. Kevin Kevin! Did you add the appropriate entry to your hosts table? I'm not sure how to do it, but that's the idea Richard R

ebay - WOT

My wife has inspired the following: ebay woman! ebay woman! ebay woman, Sunday afternoon ebay woman, Sunday afternoon tops and pants, pots and pans never saw a womanso broke R. Whitney Transcend Development Producing the next phase of your internet presence http://xend.net Premium Quality

next autoindex

Hello! I have situation where I need to find the next autoindex of a table - not just max(field) because the next autoindex may not jive with the number created by max(field) Any ideas? Am I making sense? Thanks! R. Whitney Transcend Development Producing the next phase of your internet

LOAD DATA LOCAL INFILE

Hi! Can someone point me in the right direction? I have this that works in v.4x: $sql = LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE `members` FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '' LINES TERMINATED BY '\\r\\n'; When I try it using 3.23.55 I get the

Re: mysql optimizing large table

already actually... Thanks for your help, Richard . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql optimizing large table

. Thanks a lot - that fixed those errors. Richard. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql optimising large table

or so, everything slows down. My own solution at the moment is to make temporary tables for each month, as things seem to stay fast with less than 2mil. records in a table. Does anyone have any advice on how to optimise this setup? Thanks, Richard. PS, some extra mysql info: (sorry for the long

Re: Innodb foreign keys names

Thanks Heikki for your response : it works perfectly with the brand new version (4.1.6), I'm gonna drop all my old foreign keys now and rename them with an appropriate name... bye -- Richard FURIC CEDRICOM Tel : 02 99 55 07 55 Fax : 02 99 55 08 64 E-mail : [EMAIL PROTECTED] site vitrine

Slow query?

Anyone know why this query takes so long? SELECT SUM(l.cost+l.fscc) FROM orders o, acctg.invoice i LEFT JOIN acctg.payable p ON (o.ORD_NO=p.ORD_NO) WHERE p.ORD_NO IS NULL AND i.ORD_NO=o.ORD_NO; Is there something I can do to speed it up? Thanks, Richard -- MySQL General Mailing List

left join question

Is it possible to do two left joins involving three tables in one query? select a.id, a.amount FROM t1 LEFT JOIN t2 ON (t1.id=t2.id) then LEFT JOIN t3 ON (t1.id=t3.id) Is this even possible? Any help would be greatly appreciated. Richard -- MySQL General Mailing List For list archives

Naming constraints

`nameid` (`nameid`), CONSTRAINT `0_23` FOREIGN KEY (`nameid`) REFERENCES `tblphone` (`nameid`), ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Any idea about this behaviour ? thanks in advance... best regards -- Richard FURIC CEDRICOM Tel : 02 99 55 07 55 Fax : 02 99 55 08 64 E-mail : [EMAIL

Re: Naming constraints

So how is it possible to drop a foreign key in a master / slave replication ? the autogenerated-naming constraint should be different ? How automatic database structure update can be executed (from a script generetor like PowerDesigner) ? thanks... Martijn Tonies [EMAIL PROTECTED] a écrit dans

Innodb foreign keys names

the constraint foreign key names ? thanks in advance regards -- Richard FURIC CEDRICOM Tel : 02 99 55 07 55 Fax : 02 99 55 08 64 E-mail : [EMAIL PROTECTED] site vitrine : www.cedricom.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

COMPRESS engine

, Richard -- a professional is simply one who gets paid for doing what an amateur does for love. -- Ursula K. Le Guin -- MySQL General Mailing List For list

Re: COMPRESS engine

Thanks, I'll give it at try. Richard On Wed, Oct 06, 2004 at 05:14:01PM -0500, Dan Nelson wrote: In the last episode (Oct 06), Richard Jacobsen said: I've got some large tables, ~160GB each with indexes, which are only used for read only access. Since obviously all table space doesn't

OT - Gmail invite

Could one of you send me an invite to gmail? I screwed mine up by admitting I sold some on ebay. As soon as I did that I stopped getting any mail. You may recall me as [EMAIL PROTECTED] Thanks! R. Whitney Transcend Development Producing the next phase of your internet presence http://xend.net

OT: Gmail

I have 3 invites - anyone interested? -- R. Whitney Transcend Development Producing the next phase of your internet presence http://xend.net Premium Quality Web Hosting http://hosting.xend.net [EMAIL PROTECTED] [EMAIL PROTECTED] 310-943-6498 602-288-5340 The day this country abandons God is the

Modulo Arithmetic... for negative numbers

Hi, just an odd query. Background: I'm trying to calculate the Next Thursday and Next Friday dates from today (whenever that is), and return today's date if it's already a Thursday or a Friday. As a bit of a traditionalist, I've been used to modulo arithmetic always giving a positive answer,

Re: Modulo Arithmetic... for negative numbers

Thanks Keith! About 5 minutes after I posted it, I had a personal email from someone suggesting exactly(!) the same thing. For the record, my reply: On 19 Aug 2004, at 21:39, Richard Dyce wrote: Thanks! I'd got to go with: if(weekday(d)4,3-weekday(d),10-weekday(d)) day) which is I suppose

RE: How to show comments/annotations in MySQL client output

to both of you. I know what my options are now. - Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Setting up MySQL on Raid Mirror

on a unmirrored volume is more risky than having it on the RAID 1 volume. Assuming its not a super-high performance situation, I would put everything on the RAID 1 volume. If its really high performance, you need an altogether different disk setup anyway. Hope this helps - Richard -- MySQL General

RE: Setting up MySQL on Raid Mirror

Rick Dwyer wrote: Assuming its not a super-high performance situation, I would put everything on the RAID 1 volume. Richard, what would you define as super-high performance? This MySQL database server will serve as the backend for a Lasso/ OS X Apache webserver handling thousands of hits

Re: mysql_safe just ends

Cameron, Take a look in the data directory for a .err file. This error log will almost certainly contain the reason why Mysql failed to load and will make fixing it much easier. Richard On Wed, 28 Jul 2004 13:15:34 -0600, Cameron Roe [EMAIL PROTECTED] wrote: Thanks Rory, I did go through

RE: How to show comments/annotations in MySQL client output

Harald Fuchs wrote: In article [EMAIL PROTECTED], Michael Stassen [EMAIL PROTECTED] writes: Richard Mixon (qwest) wrote: I run some mysql command files (just SQL statements in a file I read from standard input) and need to place some annotiations/comments in the output. If I place standard

RE: How to show comments/annotations in MySQL client output

in the MySQl manual for 4.0.18. Thanks for your help - Richard Michael Stassen wrote: One more thought: Your mention of echo jogged my memory. You can use SYSTEM to pass what follows to the system and display the result. So, SYSTEM echo ## The following output should only contain two rows

RE: How to show comments/annotations in MySQL client output

[EMAIL PROTECTED] wrote: Hi Richard, not exactly sure what you want but try using \G at the end of the select statements. Also try using UNION. e.g. select Put your comment here, UNION select field1, field2 from table1 group by field 1 \G You may get something that will work for you

RE: How to show comments/annotations in MySQL client output

Its not documented in my version 4.0.18 manual on Windows XP either. I checked the Linux machine but cannot seem to find the manual.html file. The SYSTEM command DOES work in 4.0.18 on SuSE Linux, DOES NOT work on 4.0.18 under Windows. - Richard -Original Message- From: Markus

RE: tests comparing AMD64 to Xeon MySQL performance?

standing still since, a new benchmark would be nice if someone knows of one. Still, given the Opteron's ability to handle larger amounts of RAM, that would be my choice for a database server. - Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

OT, but real: Hoax or legit

Is anyone else getting this? Is this for real or someone sending SPAM or viruses? Thanks - Richard -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 27, 2004 8:21 PM To: [EMAIL PROTECTED] Subject: IMPORTANT: Please Verify Your Message Hello [EMAIL

How to show comments/annotations in MySQL client output

... | +---+ | First comment ... | +---+ 1 row in set (0.00 sec) Any/all ideas are appreciated - Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ARGH - Mysql won't stop eating RAM and finally it SEGV's

PROTECTED] wrote: Richard Clarke [EMAIL PROTECTED] wrote: I have switched to the mysql standard binary and it helped in no way at all. If anything it made the situation worse. It seems that mysql grows even worse than before. Mysql uses an extra 1MB roughly every 5-10 seconds. mysql

ARGH - Mysql won't stop eating RAM and finally it SEGV's

a truncate table_name. It is really not appropriate for me to recompile Mysql for debugging so I hope that someone can give some advice. Richard. #START -- my.cnf - START [client] #password = your_password port= 3306 socket = /tmp/mysql-4.1.3.sock

Re: ARGH - Mysql won't stop eating RAM and finally it SEGV's

statistical operations depending on the above functions temporarily. I am using gcc-3.3.3-r6 and glibc-2.3.3.20040420 gentoo packages. Richard. On Tue, 20 Jul 2004 15:57:17 +0300, Egor Egorov [EMAIL PROTECTED] wrote: Richard Clarke [EMAIL PROTECTED] wrote: I think that is possibly related to some

Re: ARGH - Mysql won't stop eating RAM and finally it SEGV's

I have switched to the mysql standard binary and it helped in no way at all. If anything it made the situation worse. It seems that mysql grows even worse than before. Mysql uses an extra 1MB roughly every 5-10 seconds. Richard On Tue, 20 Jul 2004 14:44:39 +0100, Richard Clarke [EMAIL PROTECTED

Re: Best table structure

believe. Try and balance out the admin / code headache that would be an 81 column table vs. exactly how often this is even an issue anyway. Best regards, Richard Davey -- http://www.launchcode.co.uk - PHP Development Services I am not young enough to know everything. - Oscar Wilde -- MySQL

Re: R: R: connectorJ huge table problem

PARTITIONED_B_ + table + WHERE ID=?; ) Thank you anyway -- Richard F. Rebel [EMAIL PROTECTED] t. 212.239. signature.asc Description: This is a digitally signed message part

RE: Delphi 7 (6) and MySQL

] = Richard Czerwonka, Delphi Programmer ENT Technologies Mob: 0412 104 042 = -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Perl arrays into MySQL

A perhaps more perlish way would be, my $table = MyTable; my $sql = join ',', map {$_=?} keys % - Original Message - From: Daniel Kasak [EMAIL PROTECTED] To: Nik Belajcic [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 5:15 AM Subject: Re: Perl arrays into MySQL

Re: Perl arrays into MySQL

Crap sorry about the double post.. where's that damn undo send e-mail button :( A 'better' way imo would be, my %record; #full of my stuff my $table = MyTable; my $sql = join ',', map {$_=?} keys %record; $dbh-do(insert into $table set $sql,undef,values %record); Richard - Original

GET_LOCK(str,timeout) behaviour

think that it be much more useful for a client to be able to hold multiple locks rather than each lock being released upon request of a new lock. I can't think when it would be useful to have the current behaviour. Please correct me if I'm wrong Richard. -- MySQL General Mailing List For list

Re: GET_LOCK(str,timeout) behaviour

I am aware it is a string lock, and this is what I want. LOCK TABLES is not suitable for advisory locking. My question is targetted at the usefulness of the GET_LOCK functionality when you can only lock one 'string' per connection. Richard - Original Message - From: gerald_clark [EMAIL

Re: Password displayed in process list

owner this will provide the level of security you require. Richard. For more info see, http://dev.mysql.com/doc/mysql/en/Option_files.html - Original Message - From: Aleksandar Mihajlovic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 30, 2004 8:03 PM Subject: Password displayed

Relationships Question

PERFORMANCES having two foriegn keys (composition_id and installation_id) one of which would be redundant. Whats the best way to design this relationship? Cheers, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Strange return behaviour in UDF (bug?)

-implicit-templates -fno-exceptions -fno-rtti -shared -I/usr/include/mysql -rdynamic dist.cc -o dist.so Anyone have any ideas? Thanks, Richard -- a professional is simply one who gets paid for doing what an amateur does for love

Mysql 4.1.1, InnoDB - Slow TRUNCATE operations with Multiple Tablespaces

. Swapping: WinXP reporting commit charge 800MB Note: I'll be moving to a Linux-based development server soon and will be able to tell whether the above is specific to Windows or Linux. Best regards, Richard Dale. Norgate Investor Services - Premium quality Stock, Futures and Foreign Exchange Data

[Setup language MySQL ??]

help. -- Regards, Richard ___ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fulltext searching

Ok having some problems with MySQL's fulltext search. I have the fields that I need fulltext indexed, everything seems to be working correctly, but for some reason when I search for beyond looking for an item called: Beyond Heaven yoga Day Spa It doesn¹t find it.. I am searching in boolean

Re: Fulltext searching

PROTECTED] wrote: Check to see if beyond is in your stopword file. -Original Message- From: Richard Baskett [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:12 PM To: MySQL Subject: Fulltext searching Ok having some problems with MySQL's fulltext search. I have the fields

Re: Fulltext searching

on 5/6/04 16:53, Michael Stassen at [EMAIL PROTECTED] wrote: If you've built from source, the stopwords are in path-to-source/myisam/ft_static.c In my copy of 4.0.18, beyond is in the list. You can create your own stopword list, or turn off stopwords altogether, if you want. See

Create a table from SHOW TABLE STATUS ?

system views that are equivalent to SHOW xyz commands ? Thanks, Richard A. DeVenezia -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query help

Thank you very much Shawn and Mike for your quick responses. Left join was exactly what I was looking for and it worked quite nicely. Once again, thanks for your help. Richard [EMAIL PROTECTED] wrote: Richard, This is the case for using a LEFT JOIN. You want everything from the left table

Re: What is your mysql debugging strategy?

I only use mysql with php so all I need is php code: $result = mysql_query($sql) or die(mysql_error()); This always tells me what I did wrong in the query. You could easily put together a very short script into which you just drop you query. THis would output the problem to the page. Dead

Query help

works only for those events that have a sposor. Any help would be greatly appreciated. Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: update if insert fails

Hello Andy, Friday, April 23, 2004, 12:59:28 PM, you wrote: AF Is there such a statement where, if the insert fails (due to a duplicate AF record) an update will happen No, but you might want to look at REPLACE INTO to simulate this effect. -- Best regards, Richard Davey http

Simple Select (You'd think)

tables. Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Simple Select (You'd think)

Thank you very much that worked great except I had to make it select new.item_id. Richard Subqueries are supported staring with mysql 4.1. I'm guessing you have an earlier version. You can rewrite your query as a join, though. SELECT item_id FROM new LEFT JOIN old using (item_id

Re: Query Question

posting? ;) -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re[2]: Query Question

Hello, Friday, April 16, 2004, 12:56:32 AM, you wrote: M I did try it, and it doesn't work, I was looking for Ideas that will work. Obviously not, because that's exactly how you do it. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List

Re: Using 1 statement to delete from 2 tables

4 supports a cascaded delete, but 3 does not. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: FULLTEXT search in form of MATCH...AGAINST

Hello Robb, Thursday, April 8, 2004, 4:30:46 PM, you wrote: RK I've got several tables with FULLTEXT indexes and on none of them can I get RK this syntax to work. What's up? Your version of MySQL perhaps? -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL

Re: where clause query

Hello joe, Monday, April 5, 2004, 3:17:27 PM, you wrote: jc does MySQL have an equilivent for the WHERE Unique_id IN ('1',' 2', '3') as jc used in oracle. Yes. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http

Product link that goes to hard core porn site

http://www.mysql.com/portal/software/convertors/index-2.html http://www.mysql.com/portal/software/item-266.html Regards Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fulltext search question: words with numbers (ie DB2)

characters in. If you are using MySQL 4 you can change the minimum length via the ft_min_word_len variable. On MySQL 3.x there's nothing you can do short of changing the actual source code and recompiling. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL

Re: Directory question for the masters...

Mark, Thank you. I subscribe to both lists as my system uses Tomcat (sometimes Jetty) and MySQL with Servlets to do it's work. However, you were the first person to reply! Thanks for the answer - even if it is from the wrong list! :-) Cheers, -Richard Mark Matthews wrote: -BEGIN PGP

Re: Creating index on very large table

have). My suggestion would have been - why not take say 10,000 records and just test the index creation on that small sub-set of the data? If it works without error then you know it will (should?) eventually finish on the final massive set. -- Best regards, Richard Davey http

Directory question for the masters...

very much in advance, -Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MY APOLOGIES!!!

Very Sorry!!! I sent a Tomcat request to this list by mistake. Please ignore it. Thanks, -Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re[2]: Index not functioning

AND FROM_UNIXTIME(1076734799) ORDER BY dtime; Does your index include both id and dtime in a single index? If not, it probably ought to if the above is a typical query you need to run on this table. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General

Horizontal list...

| +---++ Based on a group by or something... A + -- ** Richard CARLIER http://www.rcarlier.net (o_- Votre association et Internet (mai 2002, VMP, 2-7440-6013-5) //\- Profession Webmaster

Re[2]: PHP and using mysql_last_id()

the last ID - other than the fact it takes another query on the database? -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: General Help - ERROR 1045: Access denied for user: 'ackerley@localhost' Using password: YES

get in. Try using root and giving nothing as the password. If that lets you in, create yourself the ackerley user. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Optimizing Queries

the total table size just by optimising your use of data types. Just some thoughts anyway. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Update field conditionally

. it's a popular site). -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re[2]: Optimizing Queries

: http://www.mysql.com/doc/en/MySQL_indexes.html -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re[2]: Update field conditionally

Hello Terry, Tuesday, March 9, 2004, 6:25:00 PM, you wrote: TR Good point, Richard. I was perhaps in a little bit too much of a hurry TR putting that together, and didn't even consider that! No worries. One other thought that occurred to me that might help with the original problem

Re: Date Problem

, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re[2]: Date Problem

:00, which is what I would expect. That's on MySQL 3.23.58, so I doubt if they broke it in any version since. MySQLs date handling has never caused any problems for me (when I remember the correct y-m-d format :) -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html

Re[2]: Optimizing Queries

:) -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Hierarchical list...

FROM links_categories WHERE (id = 2 or parent = 2) Works for the father and the son, but for the others... :( A + -- ** Richard CARLIER http://www.rcarlier.net (o_- Votre association et

Re: Duplicates returns in query?

you need here, instead look at using a GROUP BY on perhaps the VenueName (if that is what you need grouped). -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: plz help

? -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Changing the primary key

will fail because it will leave an invalid table definition. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Remove a RPM Installation

mail client is playing silly buggers, or you're sending far too many copies of this to the list Rafael. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Optimising LIMITs

that does something like: SELECT * FROM thread WHERE threadid IN (...) (where ... = all of the IDs previously selected). Would the fact that threadid is my primary key make the original LIMIT/sort faster? Any thoughts appreciated. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296

Re: Type TEXT

Hello Jim, Monday, March 1, 2004, 5:44:22 PM, you wrote: JM Are the TEXT column types padded out to their max length by spaces? No, they're variable length and at a maximum of 65KB per row, be thankful of this! A 30 character string will take up 32 bytes for example. -- Best regards, Richard

Re[2]: Type TEXT

then use a char. Use the text range of data types if you need more storage space but still want to be able to run fulltext indexes etc. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: anybody used prepared statements in 4.1 succesfully?

. Of course, if other people don't find prepared statements to be buggy, I would love to hear about it, since I really, really want them to be working properly. Hope this helps, Richard On Thu, Jan 22, 2004 at 11:59:08AM +, Brian Power wrote: Has anybody used prepared statements in mySQL 4.1

Re: anybody used prepared statements in 4.1 succesfully?

if there is a good way to check if you don't have everything being logged. Nor do I know of a more quantitative measure. I'm pretty new to mysql. Richard On Thu, Jan 22, 2004 at 08:42:56AM -0500, Sid Lane wrote: on a related note how can you verify that you're actually using a prepared statement (re

Re: anybody used prepared statements in 4.1 succesfully?

and Sales Engineers, I would love to hear them. Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

<    1   2   3   4   5   6   7   8   >