RE: Max columns in a tabel in MyISAM storage engine

confused. Of course, this would probably be painfully slow. I can't say whether or not it would be slower than the other alternatives. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message

RE: Configure options question

PPB 1020 Los Angeles, CA 90095 310/206-8216 -Original Message- From: Jerry Schwartz [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 10:23 AM To: Lopez, Denise; [EMAIL PROTECTED] Subject: RE: Configure options question -Original Message- From: Lopez, Denise

RE: Configure options question

-Original Message- From: Lopez, Denise [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 12:51 PM To: [EMAIL PROTECTED] Subject: Configure options question I have a beginner question for you all. I recently took over a server and would like to determine what configure

RE: Join update help

I think you want a subquery. Something like UPDATE t1 SET last_login_time = (SELECT MAX(logintime) FROM t2 WHERE t1.userid = t2.userid); would be a good start. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

RE: question about Queries per second avg

queries goes. If queries arrive while the previous query is still being served, then all is lost because the queue will grow to infinity. That's a very simplistic overview, there's an entire branch of statistics devoted to this sort of thing. Regards, Jerry Schwartz Global Information Incorporated 195

RE: Query to return Multiple values in a field?

I'm not sure this will work for you, but look at the GROUP BY clause and the GROUP_CONCAT() function. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Jesse [mailto:[EMAIL

RE: return integer for positive values

with a particular pollutant. That construct will return TRUE or FALSE, which evaluate to 1 and 0, respectively. I hope that helps. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message

RE: return integer for positive values

Are you trying to get a 1 or 0 depending upon whether or not there is an AQ_ record that matches? If so, then you could use a LEFT JOIN and an IF(ISNULL(AQ_.SITEID),0,1) or something like that. I probably don't understand your query. Regards, Jerry Schwartz Global Information Incorporated 195

RE: Finding a record in a result set

That would only work if the result set is sorted by name. You said you wanted to sort by hiring date, that's not going to work. As for the general approach, I don't have enough experience to judge. How big would you expect the result set to be? Regards, Jerry Schwartz Global Information

RE: Joins versus Grouping/Indexing: Normalization Excessive?

, there's no reason I can think of not to normalize the data. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Daniel Cousineau [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007

RE: insert data in to columns base on the selection of the list box.

Without knowing where the values of column2, column3, and column4 are coming from it's a little hard to say what the best technique would be. Usually one would take the POSTed value from the select control and use it to retrieve the related data from a table in your data base. Regards, Jerry

RE: Help With a Week ( date ) query

SELECT * FROM specials WHERE WEEK(NOW(), 7) = WEEK(specials.start_date, 7) AND DATEDIFF(NOW(),specials.start_date) 7; Let me know if that works. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original

RE: UPDATE / not UPDATE??

Yes. It only reports the changed rows. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 4:16 PM To: MySQL List

RE: Help With a Week ( date ) query

starts as well as its date, saving one function call in your query and allowing you to index on that week field. The second part of the WHERE clause should keep you within the right year, if I did it correctly. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington

RE: Select into outfile on nfs mount point

Can you touch the file name? It might be a permission issue at the directory level, it has to be writeable. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: David Ruggles

Search relevance

come up with is a Boolean search ordered by a natural search, which seems to work. Does anyone have any other suggestions? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

RE: What does NOW() return: linux time or something else?

in time zone related tables in the mysql data base, and there are utilities to load those tables from the system time zone tables (I forget the exact command). Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

RE: Finding a record in a result set

I don't think that will work. If there are 1,000 records that qualify but none for Joe, then it will return 1,001. If Joe is in record 1 of the retrieved record set, and there are 999 other people who match the WHERE clause, then it will retrieve 1,000. Am I missing something? Regards, Jerry

RE: fulltext substringsearches?

Sorry, you can't use a preceding asterisk. It is annoying. The only alternative is to use a LIKE operator. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Philipp Wabinski

RE: Does MySQL require patch for Daylight Savings Time 2007 change

Yes, I think that will work. I haven't tried it, though. By the way, you'll get more and better feedback if you reply all so that the entire group gets to see what you're doing. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

RE: Best Practice: Timezones and web development

the connection's time zone would get you anywhere. Perhaps not, since the return value of getTimezoneOffset() is already adjusted for DST and I don't know how you could translate the offset into a MySQL time zone setting anyways. Regards, Jerry Schwartz Global Information Incorporated 195

RE: MySQL Daylight Savings Time Patch - easy check

') --+- - 1173596400 | 117360 shell date -d mar 11 02:00 Sun Mar 11 03:00:00 EDT 2007 so my OS does have the right settings. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message

RE: MySQL Daylight Savings Time Patch - easy check

') --+- - 1173596400 | 1173596400 Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 5:10 PM

RE: Does MySQL require patch for Daylight Savings Time 2007 change

errors about Riyadh. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Jean-Sebastien Pilon [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 10:55 AM To: Causevic

RE: Does MySQL require patch for Daylight Savings Time 2007 change

and one minute later and got the same results. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Jean-Sebastien Pilon [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007

RE: Does MySQL require patch for Daylight Savings Time 2007 change

= Sun Nov 4 01:59:59 2007 EDT isdst=1 gmtoff=-14400 /etc/localtime Sun Nov 4 06:00:00 2007 UTC = Sun Nov 4 01:00:00 2007 EST isdst=0 gmtoff=-18000 Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

RE: MySQL Daylight Savings Time Patch - easy check

What version of MySQL are you using? I'm running 4.1.21, and that check doesn't work even after I've updated (I think) the time zone tables. I should probably eyeball the output of mysql_tzinfo_to_sql. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT

RE: what's better query to update table

, $thislen - 1); } $query = update suppliers set rating='A' where supp_id IN (${rating_list[A]}); ... And so forth. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: [EMAIL PROTECTED

RE: MySQL Daylight Savings Time Patch

are using replication across time zones, I suspect. There are explicit instructions for building time zone tables in section 5.9.8 of the manual. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original

RE: MySQL Daylight Savings Time Patch

. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/right/Mideast/Riyadh89' as time zone. Skipping it. etc. Any idea whether or not this is normal? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -- MySQL

RE: MySQL Daylight Savings Time Patch

Aren't the time zone tables new in 4.1.3? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Bryan S. Katz [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 20, 2007 9:03 PM

RE: Temporary table lifespan - SOLVED

levels. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Amer Neely [mailto:[EMAIL PROTECTED] Sent: Thursday, February 15, 2007 11:21 PM To: Daniel Kasak; mysql@lists.mysql.com

RE: Removing space characters ... char(160)? ... char(194)?

and that it shouldn't be remapped. You will also run into this problem if you copy and paste from a PDF, I suspect. This whole thing gives me a headache. I hope someone else who really understands this stuff will respond, so we can both learn. Regards, Jerry Schwartz Global Information Incorporated 195

RE: [Fwd: search issue]

Don't forget that LIKE %cap% will find captain, recapture, and anything else that has the substring cap in it. Your Boolean match against +cap will only find the word cap. Make sure that's what you want. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT

RE: NOT EMPTY, like NOT NULL

Try this: mysql insert into t (a) values (if(char_length(sbd), sbd, NULL)); Query OK, 1 row affected (0.47 sec) mysql insert into t (a) values (if(char_length(), sbd, NULL)); ERROR 1048 (23000): Column 'a' cannot be null Regards, Jerry Schwartz Global Information Incorporated 195 Farmington

RE: Getting number days between 2 dates

The original query should not generate a syntax error. I just tried it. However, DATEDIFF(CURDATE(), xxx) will probably evaluate to TRUE for every record so the WHERE clause as written isn't useful. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

Query ranges

I am trying to do an update, where item numbers 1-9 get four 0's added to the front, 10-99 get three 0's etc. Here is my query so far: if image_location = 1 to 9 then update inventory_items set image_location = concat(, image_location) end if Looking at the mysql manual, it just says to do

Update query question

I am new to mysql. I am trying to do a simple update query to update a field based on the contents of another field in the same table. Here is what I have. update inventory_items set name = necklace where description like %necklace%; I am not sure what is wrong. select * from inventory_items

Update queries

I need to run a query that will take the data from item_number field, add -1.jpg to the end of it, and store it in image_location I have tried update inventory_items set image_location = item_number + -1.jpg; but that just places the item number into the field, without the text in quotes. How do

RE: Fulltext search dilemma (IN BOOLEAN MODE)

be treated as word delimiters as far as I can tell. Also, the asterisk operator is only valid at the end of a word, not in the beginning. The leading asterisks should be ignored, since they would be treated as word delimiters. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave

RE: Fulltext search dilemma (IN BOOLEAN MODE)

Sorry, I have no idea what is going wrong. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Andreas Iwanowski [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 2:22

RE: Questions about delete and optimize

, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Ian Barnes [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 4:23 PM To: mysql@lists.mysql.com Subject: Questions about delete

RE: General MySQL Question: Ed Reed (CA, United States ofAmerica) Medium

If you are into ancient Egypt, check out the Rosicrucian museum in San Jose. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Eric Braswell [mailto:[EMAIL PROTECTED] Sent

RE: simple alternate query

I suggest you use parentheses, by the way, so that it is obvious what you are doing. I never like to depend upon the precedence of operators to make my intentions clear. It's too easy to make mistakes. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT

RE: Alias a function result?

I saw a reference that said standard SQL doesn't allow an alias to be used in a WHERE clause, but I thought perhaps I'd get an error message. I understand why, logically, it should be the way it is. Thanks for the reassurance. Regards, Jerry Schwartz Global Information Incorporated 195

RE: Alias a function result?

an alias of the same name in the list of columns to be retrieved. Apparently this is the way SQL defines it to work. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Felix Geerinckx

RE: Ms access front end and mysql back end

that far? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Langson B.-Computer Specialist [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 4:27 AM To: Jerry Schwartz

Alias a function result?

-standard. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

RE: Ms access front end and mysql back end

mean the Windows workstation hangs, not the MySQL daemon. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Langson B.-Computer Specialist [mailto:[EMAIL PROTECTED] Sent: Friday

RE: Connecting from a remote computer

If you have that short a script to test wit, try it from the command line. Your HTML might be obscuring the error messages. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Kay

RE: Ms access front end and mysql back end

You didn't give us much information. If you open the Data Sources configuration, what happens when you test the connection? Did this ever work? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original

RE: Extracting data from MySQL into Access

You can set up an ODBC connection to the MySQL data base, and then use Access directly on your data base. Does that come near what you want? (You can set it up read-only.) Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

RE: Row position in table when sorted?

, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Nuno Oliveira [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 10:05 AM To: mysql@lists.mysql.com Subject: Row position in table when

RE: [OT} How to pronounce GIF (was: Re: How to pronounce MyISAM and InnoDB)

... Especially for tall ones. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 1:49 PM To: mysql

RE: Select where the column names are not fully known

, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 11, 2007 5:01 AM To: mysql@lists.mysql.com Subject: Select where

RE: automated character set conversions for tables

Columns can have character set definitions, also. In this case, I hope not. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Chris White [mailto:[EMAIL PROTECTED] Sent

RE: Help me to understand multiple locking the same tables (lock; lock; unlock)

changing your data under you, you'll need a single (WRITE) lock around your entire operations. Sad, but true. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Denis Solovyov [mailto

RE: How to access an array variables in a single query

like it, because it might fail mysteriously if the query gets too long, but I inherited it and haven't thought of a good way to rewrite it. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message

RE: How to access an array variables in a single query

Thanks. I might actually adapt our code, in my infinite free time. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Monday

RE: Varchar limit warning - similar question

For limiting possible values to 0, 1, 2, 3, 4, 5 you could use an ENUM, although that is not advised because you're using numeric indices to refer to numeric values and that can be confusing. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

RE: Varchar limit warning - similar question

The length of the numeric type defines the way it will be displayed. The storage requirement is defined by the numeric data type (tinyint, etc.). I don't think there's any way to have MySQL limit input data to the length you use. Regards, Jerry Schwartz Global Information Incorporated 195

RE: InnoDB vs MyISAM

, you might want to rebuild it periodically rather than maintain it in real time. This would make your application run faster when doing updates and inserts, if you can tolerate an index that isn't up-to-the-minute. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave

RE: Error: Duplicate entry 'xxxx-L' for key 6

Are you using a custom-written application to do the loading? If so, what language is it written in? I suspect that some of your variables are getting clobbered by a bad subscript, bad pointer, so something like that. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave

RE: select statement question

-hand side. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Aaron Cannon [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 03, 2007 3:47 PM To: mysql@lists.mysql.com Subject

RE: Error: Duplicate entry 'xxxx-L' for key 6

Where is the error message itself coming from? Is MySQL itself generating any error? I ask because that error message shouldn't be coming from MySQL. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

RE: Question regarding Update ... LEFT JOIN

I hope it is locking both tables. Even if you aren't changing any fields in the right-hand column, you don't want anyone changing it under you. I hope that, if you aren't actually modifying the right-hand table, that MySQL uses a read (SELECT) lock. Regards, Jerry Schwartz Global Information

RE: MySQL Data Vanishing with FireFox

Did you make a mistake when showing us your PHP code? There's a missing single quote after the period on the second line of you $SQL = Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message

RE: MySQL Data Vanishing with FireFox

I see it was my mistake, not yours. I'm going to shut up now. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Matt Neimeyer [mailto:[EMAIL PROTECTED] Sent: Thursday, December

RE: Primary field do I need one

You do not absolutely need a primary key, but I suggest you add an auto-increment primary key anyways. When you start coding your PHP application, you may find that you need to identify a specific record and this auto-increment field will be your way to do that. Regards, Jerry Schwartz Global

RE: MySQL Data Vanishing with FireFox

If the problem is browser-dependent, then it isn't a MySQL problem. I don't know what is going on, but have found that IE handles failing controls in a non-standard way. My issue was with button controls, but if I were you I would take a very close look at the REQUEST data. Regards, Jerry

RE: database design help

, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: ppywriw [mailto:[EMAIL PROTECTED] Sent: Saturday, December 16, 2006 11:54 AM To: mysql@lists.mysql.com Subject: database design help Hiya

RE: MySQL 5.0.27: character problem

, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Eric Lilja Sent: Wednesday, December 13, 2006 2:03 PM To: mysql@lists.mysql.com Subject: MySQL

RE: MySQL 5.0.27: character problem

(cp1252,utf-8,$text_to_convert); file_put_contents(basename($file_to_convert,.orig), $text_converted); } ? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: news [mailto

RE: MySQL 5.0.27: character problem

this out enough to get it working, I was still on shaky ground. Sorry I can't help more. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf

RE: Thread safety

way to do this. Remember, however unlikely any collision that might happen eventually will. You can't fix this problem without a location-wide single-threaded resource. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

RE: Selecting data from three tables

I'm not sure I followed everything you said, but if products.productid is NULL then I think you will only find those categories that have no matching products in the products_categories table. Is that what you want? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave

RE: Index effectivity for a 2-valued field (was Re: Should I use an index in this case?)

some other data type. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Andy Sy [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 4:05 AM To: mysql@lists.mysql.com Cc

RE: mysql on a NAS

OCFS probably provides protection at the file level, but mysqld undoubtedly keeps some critical information in its own internal memory. The two MySQL daemons are oblivious to each other, so that memory-resident information will not be synchronized. Regards, Jerry Schwartz Global Information

RE: Copy some datasets including the foreign key constraints

it works when you use your PHP code. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Eidner, Fabian [mailto:[EMAIL PROTECTED] Sent: Thursday, November 23, 2006 6:47 AM To: Jerry

RE: Having Problem With Load Files and AutoNumber id fields

Perhaps that empty field is being interpreted as a string? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: John Kopanas [mailto:[EMAIL PROTECTED] Sent: Friday, November 24

RE: FIND_IN_SET question

Is this one of those places where a HAVING clause is needed? ... HAVING YESNO = 0 Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Lars Schwarz [mailto:[EMAIL PROTECTED] Sent

RE: Copy some datasets including the foreign key constraints

single quotes and the like. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Eidner, Fabian [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 22, 2006 7:46 AM To: mysql

RE: Update query in order to modify some fields

) You will also have problems if there are capitalization differences. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: spacemarc [mailto:[EMAIL PROTECTED] Sent: Friday

RE: Contents storing in mysql

/1234), the corresponding record in image_table, and the corresponding records in prod_image_index. I hope that helps. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Shain

RE: MySQL Error for Blobs

://www.mysql.org/doc/refman/4.1/en/packet-too-large.html Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: C K [mailto:[EMAIL PROTECTED] Sent: Thursday, November 16, 2006 12:46 PM

RE: finding NULL records

*/ Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 2:22 PM To: [EMAIL PROTECTED]; mysql@lists.mysql.com

RE: Max date in recordset

Assuming that insertdate is a DATE column, SELECT * FROM t WHERE t.insertdate = (SELECT MAX(t.insertdate) FROM t)); would do it. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message

RE: Max date in recordset

From what I know, your solution would only work if you have exactly three records to find (there might be 1 or 100), only if the latest records fall within the last three days. I think Vittorio said he didn't know ahead of time what most recent date would be. Regards, Jerry Schwartz Global

RE: Find next available number for gidnumbers and uidnumbers

Would it be practical to leave the record in the table and mark it as unused? That would certainly simplify the whole business. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From

RE: ORDER BY RAND() gives me duplicate rows sometimes

multiple times. I'm not sure what, exactly, the difference is between the two. In any case, as I understand it your (Christian's) suggestion runs counter to the documentation. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

RE: Regular expression not working as expected (documented)?

According to the documentation, [.period.] should match but so should [...] (if I read it right). Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Christian Hammers [mailto

RE: Max of Count

whose count is the maximum. It seems tantalizingly out of reach. I know what MySQL is telling me (I can use MAX without a GROUP only if I don't use other columns that aren't functions), but not how to fix it. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT

RE: finding NULL records

I inherited a system in which the code was writing the string NULL into a CHAR field. It took me a long time to figure out what MySQL CLI was showing me. These kids today... Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

Max of Count

couldn't just use id in the outer select, but how do I get it? I tried adding GROUP BY t.prod_id, but that just gave me the same error. Please help me find my way. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

RE: utf8 importing problem

Most likely the UTF8 is still in the data base, but whatever program you are using to view it is not displaying UTF8 properly. MySQL's command line program will not, for example, even if you SET NAMES utf8. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington

RE: utf8 importing problem

already believes the data is UTF8 so it might not work. SELECT COUNT(*) FROM table1 WHERE CONVERT(field1 USING utf8) != field1; Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: [EMAIL

RE: Speed of DECIMAL

with integer types. Sorry, that's about as far as I can guess. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 27, 2006 2

RE: Speed of DECIMAL

arithmetic, on the other hand, requires more data manipulations. The size of the column probably is outweighed by the more complex data handling. No doubt someone whose internals experience is more recent than mine will chime in. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington

RE: Remove unwanted characters from a name field

is, and how picky you are about the results. You can probably do what you want with a combination of REGEXP, IF, SUBSTRING, and CONCAT; but it would take more time than I have to work it out. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

RE: help with query: select customers that ARO NOT in orders table

Is a sub-select more efficient than an outer join? SELECT cust_id FROM customers LEFT JOIN orders on customers.cust_id = orders.cust_id WHERE orders.cust_id IS NULL; Or am I missing something (as usual)? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington

<    1   2   3   4   5   6   7   8   9   >