Re: Doubt about TINYINT type

of values that | can be stored in the column, or the number of digits that | will be displayed for values having a width exceeding that | specified for the column. I haven't found much use for display widths myself, but then different people use MySQL differently. -- Keith C. Ivey [EMAIL

Re: simplifying OR clauses

://dev.mysql.com/doc/mysql/en/Comparison_Operators.html#IDX1209 -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: first LIMIT then ORDER

the UNION keyword isn't even there). That means it will always eliminate duplicate rows (like DISTINCT). That hasn't come up when I've used it, since I've never been selecting result sets that could contain duplicate rows, but it's something to keep in mind. -- Keith C. Ivey [EMAIL PROTECTED

Re: first LIMIT then ORDER

and then sort them alphabetically by another column. Now, the fact that the syntax isn't documented may mean that it will disappear, but it's reasonable and useful. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list

Re: NOT NULL column behaves strangely

value is the empty string. http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

RE: Managing Very Large Tables

big, though that could take a while), they'll be able to grow past 4 GB even if they're dynamic. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Query Problems

are indexed, and new rows are indexed as they are added. What makes you think they're not? -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

RE: MAX_ROWS

an AUTO_INCREMENT primary key that's a TINYINT or UNSIGNED TINYINT or SMALLINT or UNSIGNED SMALLINT ..., but I don't think that's going to help you either. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http

Re: Query Problems

ON a.Field1 = b.Field1 AND a.Field2 = b.Field2 WHERE condition ) ORDER BY whatever; -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: disabling optimizations to identify slow queries

On 24 Feb 2004 at 12:00, Bill Marrs wrote: Actually, I just noticed that even after I restart mysql, the speed stays. That doesn't make any sense, maybe there is some other unknown factor influencing this. Sounds like it's your operating system's caching of the disk reads. -- Keith C. Ivey

Re: MAX_ROWS

. If the data file becomes larger than can be handled by that size of pointer, then you can't add any more records to the table (unless you increase MAX_ROWS or AVG_ROW_LENGTH so that the pointer size is increased). -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org

Re: operator OR slows down query?

/MySQL_indexes.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: White Space

generally includes tabs, carriage returns, and line feeds -- and sometimes vertical tabs, form feeds, or nulls -- along with spaces). -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Temporary table issues. Do I need persistent connections with php?

, but it won't be a TEMPORARY table in the MySQL sense. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Setting PACK_KEYS=1 on existing tables

be a single table_option, and table_option can be PACK_KEYS = 1. So the syntax is just ALTER TABLE table_name PACK_KEYS = 1; -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Unique IDs

INTERVAL 1 SECOND), gives 20040213114860, which gets converted to 20040213114800 on insert. If you've already used all the timestamps for that minute, then you're never going to get to the next minute (and thus never going to get a usable ID) by repeatedly adding 1. -- Keith C. Ivey [EMAIL

Re: Unique IDs

the bullet and change the unique ID to something that's actually unique -- even an AUTO_INCREMENT would work. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Unique IDs

, but not as ugly as the solution with waiting. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Odd Rounding?

just as well be 0.0123449 or 0.0123451, and 0.01234 is perfectly fine as a rounded value. If you do have exact numbers with six decimal places, you're probably better off storing them as some sort of integer and adding the decimal point when necessary for display. -- Keith C. Ivey [EMAIL

Re: Something like STR_TO_DATE in 3.23.58?

the last one. ORDER BY MID(datecol,8) DESC, FIELD(LEFT(datecol,3), 'Jan','Feb','Mar','Apr','May','Jun', 'Jul','Aug','Sep','Oct','Nov','Dec') DESC, MID(datecol,5,2) DESC -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing

Re: mediumtext crash on strings 1MB?

the default value of 1M. I believe that earlier versions of MySQL seomtimes gave server went away error in that circumstance rather than packet too large. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http

Re: mediumtext crash on strings 1MB?

= max_allowed_packet=16M I see now that that syntax is deprecated in MySQL 4.0, so I should at some point change it to max_allowed_packet = 16M -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http

Re: = not working?

that, you have to cast the value into a numeric type before comparing them. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: unixtime update syntax

. FROM_UNIXTIME() does the opposite of UNIX_TIMESTAMP(). It takes an integer representing a Unix time and converts it to a DATETIME in local time (not GMT). It would be nice if there were a FROM_UNIXTIME_TO_GMT() function, but there isn't. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents

RE: unixtime update syntax

time zone and daylight time issues is the main reason to use Unix time. I don't see the advantage of keeping your time in two different formats. It seems like sticking to one would be simpler. But then I don't know your system. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http

Re: Formatted index

it. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Formatted index

something like this? SELECT * FROM DateInfo WHERE updateDate BETWEEN '2003-03-01' AND '2003-03-31'; Or if updateDate is a DATETIME column, SELECT * FROM DateInfo WHERE updateDate BETWEEN '2003-03-01 00:00:00' AND '2003-03-31 23:59:59'; -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents

Re: LIMIT and placeholders

() to identify the parameter as an integer. Rudy Lippan, the author of DBD::mysql, had a message about it on the dbi-users list: http://groups.google.com/groups?selm=Pine.LNX.4.44.0307291622390.14615 -10%40elfride.ineffable.net -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http

RE: Howto reduce size of MYISAM files after deleting records?

On 28 Oct 2003 at 13:59, Dan Greene wrote: Is there a way to do this on a live running (i.e. production) server? http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list

Re: updating records without changing timestamp fields

to update automatically, you shouldn't be using TIMESTAMP in the first place. You probably want DATETIME instead. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Beginner trying to use Unicode with MySQL

.) ? -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: SHOW CREATE TABLE on one line?

output. Seems a lot better than hand-coding. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Converting GMT stored data into other zones

SELECT DAYOFYEAR( datefield - INTERVAL 4 HOUR ) AS day ... GROUP BY day? -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: small bug in mysqldump

On 29 Sep 2003 at 20:47, Lorenzo Sicilia wrote: when I use mysqldump the database name is write: design-network instead design-network If you have odd characters in your names, then you need to use the --quote-names option on mysqldump, so that it puts backticks around them. -- Keith C

Re: FULL Text Limitation issue!

-tuning.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Does NULL == ?

On 15 Sep 2003 at 11:47, Brent Baisley wrote: It's almost useless to specify a property as NOT NULL and also set a default value. The only way it would ever be NULL is if you specifically set it to NULL. I think you meant NULL rather than NOT NULL there. -- Keith C. Ivey [EMAIL PROTECTED

Re: Order By question

are ordering by a constant: the string tr.Amount. Since the string is the same for every row, you're not actually getting any ordering. What are you trying to accomplish with those quotes? Get rid of them, and you may get the results you want. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online

Re: Comparing spaces with LIKE

C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Writing a NULL in a CHAR field

extra byte to store the length, so you'll be using 9 bytes instead of 8. Still, it doesn't seem like the best idea. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: Query optimizer decision to use index depends on data?

be mouch of an optimizer. It still does make mistakes, though, and USE INDEX should solve the problem in those cases. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: $sth-rows problem

question. Have a look at the documentation for the do() method in DBI. It returns the number of rows, not a statement handle. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Table is full error

; -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table is full error

* FROM email_body; Actually, the exact figures for MAX_ROWS and AVG_ROW_LENGTH shouldn't matter, as long as their product is between 2**32 and 2**40 - 1. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives

Re: Table is full error

On 4 Sep 2003 at 15:31, Keith Bussey wrote: I do have another Database on the same machine which has a table that is a lot bigger (about 9 GIGs) and it wasn't created with any of the special table options suggested by Keith C. Ivey below. Does the other table have fixed-length records

Re: Table is full error

)? -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table is full error

the records into it: INSERT INTO email_body_NEW SELECT * FROM email_body; Actually, the exact figures for MAX_ROWS and AVG_ROW_LENGTH shouldn't matter, as long as their product is between 2**32 and 2**40 - 1. End quoted text -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online

Re: HAVING column not in select_statement

may confuse yourself and those who come after you). -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Two many key part specified

as well. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table Query taking WAY TO LONG...HELP PLEASE!!!

won't be consecutive). But if you're using IN in you're query (with more than one value in the list) then you need to get a range from the index. Since that's not possible with a heap table, the whole table must be scanned. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http

Re: Telemobile auto-reply

way to get subscribed by e-mail without replying to a confirmation message? At any rate, I think they're a result of mistakes, not a plot, and the addresses should simply be removed from the list. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL

Re: Slow results with simple, well-indexed query

. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECT SPEEDS......

statement to see how MySQL plans to execute it. Those seem to be treated identically in version 4.0.14, but it's possible that the second one wasn't as optimized in some earlier version. Documentation on EXPLAIN is here: http://www.mysql.com/doc/en/EXPLAIN.html -- Keith C. Ivey [EMAIL

Re: Query question

; presumably you want contact_id in both. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Optimizing imports

On 15 Aug 2003 at 16:34, Jackson Miller wrote: However I want to know how I can optimize my insert statements to try to speed things up. Have you read this? http://www.mysql.com/doc/en/Insert_speed.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org

Re: Matching escaped strings

, because you want two backslashes in the string you give to LIKE, which means you need to start with four backslashes (there's an extra level of escaping): SELECT * FROM table WHERE Name LIKE 'Author\'s'; -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org

Re: Unix date problems

. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Date Calculation

; (assuming the dates are within the 1970-2037 range). -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unix date problems

1901-12-13 15:45:52, which is the same as FROM_UNIXTIME(-2147483648), which is what I would expect if the argument to FROM_UNIXTIME() is a signed integer. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http

Re: Database not writting

or DBI placeholders). -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Form values are truncated

into the habit of always using them.) -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Select statement with a field name that is a number?

C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unix date problems

C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: storing large integers properly

on them. Besides, don't some ISBNs end in 'X'? -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Load data infile issue

to delete from a database called '$sql_id' -- that is, a dollar sign followed by 'sql_id'. Presumably that's not your actual database name. Remove the single quotes (so that you're using the *value* of $sql_id) and try again. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http

RE: Load data infile issue

the problem was with the location of the file (are you giving MySQL the full path?) or with permissions. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Unable to ADD databases

if the database doesn't exist yet). To actually create the database you need to use CREATE DATABASE: http://www.mysql.com/doc/en/CREATE_DATABASE.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http

RE: calender table - time column?

days so this will have to be taken into account. Has anyone done something like this? Cheers Andrew -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: how to limit COUNT(*)

C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: utf8 support

which characters (or byte sequences) are parts of words and which aren't. Perhaps you're think of the LIKE operator? -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Best practice column type for storing decimal currency amounts?

calculations on them as well at some point, and it's likely that not all those calculations are going to occur in MySQL (even assuming MySQL handles DECIMAL calculations exactly). You may have an easier time in your applications doing the calculations on integers. -- Keith C. Ivey [EMAIL

Re: How can I display images from a mySQL Database in a web page?

you're trying to do. Except for the process of retrieving the data from the database, this has nothing to do with MySQL, so questions related to HTML, PHP, and HTTP headers should be directed to another list. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org

Re: auto_incement foobar

AUTO_INCREMENT = [one more than the MAX]; If you need to sort by something other than the ID, you should introduce a new column to sort by rather than changing the ID values. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List

Re: Indexing on replicated databases

than adding the indexes to all copies of the tables? Is there a command/query I can issue to show me the indexed columns for tables in DB-C (I inherited these DB's so there's still a lot I don't know about their structure). SHOW CREATE TABLE table_name; SHOW INDEX FROM table_name; -- Keith C

Re: What's wrong with this query?

' at line 1 Plain JOIN doesn't take a join condition (ON). You presumably mean INNER JOIN. See the documentation: http://www.mysql.com/doc/en/JOIN.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives

Re: Max key length error

your table structure or indexes (by posting your CREATE TABLE statement, for example) what do you expect us to be able to say? -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Max Key Length Error

matter much). Also, the last index (UNIQUE(UserId, UserName)) is pointless, because UserId is already unique on its own. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Fulltext - stop words!?

to peten714 student liu se. To search for a phrase you need to use Boolean mode. See the documentation: http://www.mysql.com/doc/en/Fulltext_Search.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http

Re: MySQL performance question..

-- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: date format

functions is here: http://www.mysql.com/doc/en/Date_and_time_functions.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Date query optimization

). This is because I might also be searching for a range of dates (as in the commented out and clause above). The normal way to do a search for a range of dates would be ... WHERE a.submitdate BETWEEN '2003-07-01' AND '2003-07-14'; Is that what you're looking for? -- Keith C. Ivey [EMAIL

Re: Date query optimization

any results. If it's a DATETIME field, you'll want something like ... WHERE a.submitdate BETWEEN '2003-07-01 00:00:00' AND '2003-07-14 23:59:59'; or ... WHERE a.submitdate = '2003-07-01 00:00:00' AND a.submitdate '2003-07-15 00:00:00'; -- Keith C. Ivey [EMAIL PROTECTED

Re: Best Pratices for mySQL Backups in Enterprise

much larger if you have lots of non-text columns. The difference may be greater or smaller than the size of the .MYI file. It depends on your data and your indexes. In most cases I'd say that whatever difference there is isn't enough the affect the choice of backup method. -- Keith C. Ivey

Re: The quote ' problem...

the escaping of values. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Best Pratices for mySQL Backups in Enterprise

statement about the size difference (whichever way it happens to go) not being a deciding factor between using mysqldump and copying the files (with mysqlhotcopy or otherwise). -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List

Re: fulltext indexing of alphanumeric strings?

/Fulltext_Search.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: fulltext indexing of alphanumeric strings?

: SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST ('V000*' IN BOOLEAN MODE); -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Best Pratices for mySQL Backups in Enterprise

after the copying is done. If your database is big enough and active enough that locking it during the copying time is unacceptable, consider setting up a replication server and backing that up instead. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org

Re: sum() problems - I don't understand

-05-2003 | 3491.984 | 80 | SC0001GP| 2666 |2666 | 28-05-2003 | ++--+--+-+--+-+-- In fact it appears that for this query there are 8 rows in 'carello' corresponding to each row in 'ordini', so the sums are multiplied by 8. -- Keith C

Re: Best Pratices for mySQL Backups in Enterprise

, the index file will be large enough that it and the data file combined will be larger than the dump file, but in some cases it won't be. I wouldn't consider the difference in size, whichever way it goes, to be significant in deciding between backup methods. -- Keith C. Ivey [EMAIL PROTECTED

Re: Speed Up Insert Query Results

. Do an EXPLAIN on each of your SELECT queries and compare the use of indexes to see why there's such a difference. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: can you insert null?

be represented as '\0' in MySQL SQL statements). -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What's wrong with this query?

MySQL thinks (probably correctly) that using the index to find a range of status values from 'AA' to 'VQ' is no faster than doing a full table scan. I could be missing something, but if so it would help if you could explain how you expect the key to be used. -- Keith C. Ivey [EMAIL PROTECTED

Re: NOT NULL ?

it into your table. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

More anti-spam annoyance

this system please email [EMAIL PROTECTED] with the subject line UNBLOCK ADDRESS. In the body of the email. You MUST also INCLUDE the email address you are communicating with. We will the review and make a decision from there. --- End of forwarded message --- -- Keith C. Ivey [EMAIL PROTECTED

Re: Now() and time function bug??

by design: http://www.mysql.com/doc/en/DATETIME.html If you don't want automatic updating, perhaps you should use a DATETIME column instead. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http

Re: again with SELECT

-- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Turning off column and value reconciliation

just want to fill the old columns with the legacy data. It's hard to know since you don't show us any of your code, but it looks like you should add the list of column names to your INSERT or LOAD statement rather than letting the list default to all the columns. -- Keith C. Ivey [EMAIL

Re: Turning off column and value reconciliation

to consider writing a perl script or something to add the column specifiers. Another way would be to make a table with the old structure (without the new columns) and import into it, then do a SELECT ... INSERT from it into the real table, specifying the columns. -- Keith C. Ivey [EMAIL PROTECTED

Re: UPDATE doesn't work

WHERE numordine 1385, but 1157 isn't greater than 1385. Why would you expect the values to be updated? -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Help with Date Range Query

to BETWEEN 0 AND 30. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   3   >