Re: Best table structure

as you think I don't 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 k

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

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 Ge

Re: Query Question

o try it before 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: Using 1 statement to delete from 2 tables

ingle SQL Query on MySQL 3.x MySQL 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.o

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 Ge

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

words with less than 4 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.phpcomm

Re: Creating index on very large table

I've never tried it on a table with 302 million records (although I'm sure others here 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?

Re[2]: Index not functioning

TWEEN FROM_UNIXTIME(107397) JC> 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.o

Re[2]: PHP and using mysql_last_id()

PHP function that returns 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'

't 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 un

Re[2]: Optimizing Queries

r it. Farewell MSSQL :) -- 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]: Date Problem

12-31 00:00:00', INTERVAL 2 MONTH) Gives me "2005-02-28 00:00: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 for

Re: Date Problem

d work and not alter the time, but only a test will tell. -- 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

ield intact. This also presents the option of showing to the client/visitor the last time a page was visited (and you just know that might be the next request on the list :) -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archi

Re[2]: Optimizing Queries

ver this page: 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: Update field conditionally

s (i.e. 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: Optimizing Queries

currently selected. You can shave MBs from 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 un

Re: Duplicates returns in query?

- you're asking for 5 values and while you have duplicates no-where are ALL of the values duplicated. DISTINCT probably isn't what 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.phpc

Re: Changing the primary key

en dropping 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: plz help

you got last time? -- 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

uot; date so either my 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

Re[2]: Type TEXT

ys know the exact length 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.m

Re: Type TEXT

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]

Optimising LIMITs

the thread IDs and then use a separate query 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 r