Find two sets of records

WHERE prod.prod_discont = 0); This expresses what I am trying to do, but it is not a legal query because eo_name_table is in both the inner and outer queries. Suggestions? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 0603

RE: LEFT JOIN problem

As usual, the computer is right and I am wrong. The only reason that one query was coming out "right" is that it just happened the WHERE clause was never failing. It was just luck that my data was just so. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farm

RE: LEFT JOIN problem

uot;) AS >pub_date, > IF(prod.prod_num IS NOT NULL, prod.prod_num, "") AS prod_num, > IF(prod.prod_discont = 0 OR prod.prod_discont IS NULL, "", >"Discontinued") AS discont, > IF(prod.prod_title IS NOT NULL, prod.prod_title, "") AS

RE: LEFT JOIN problem

>From: Bill Newton [mailto:[EMAIL PROTECTED] >Sent: Monday, April 14, 2008 2:09 PM >To: Jerry Schwartz >Cc: 'Mysql' >Subject: Re: LEFT JOIN problem > >Hi Jerry, > >I think the problem is that NULL is not less than or greater than your >prod_published date.

LEFT JOIN problem

;") AS match_title FROM eo_name_table LEFT JOIN prod ON eo_name_table.eo_name = prod.prod_title AND eo_name_table.eo_pub_date > prod.prod_published WHERE (prod.prod_discont = 0 OR prod.prod_discont IS NULL) ORDER BY eo_name_table.eo_name; Instead of getting 860 rows in the result, I

RE: Why is this delete so slow? ( 90 seconds per 100 records)

-Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Subject: Re: Why is this delete so slow? ( 90 seconds per 100 records) Also the table seems to be locked while running this delete... thats not going to be very good when I need to run it on production. Is there a way to have

RE: select records to send to another table in another database

Yes Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: Christoph Boget [mailto:[EMAIL PROTECTED] Sent

RE: select records to send to another table in another database

> I have a slew of records that went to the wrong database. The tables > have the same names and now I want to copy those records over to the > correct database. Is there such a mechanism using the cli mysql > application in Linux? If the tables have the same schema, you should be able to jus

0x96 character in command file

this work when I type paste this directly in? More importantly, why does it NOT work when I source the file and what can I do about it? There is much too much data to paste. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 060

Re: Multiple revision of a record

plifies things a lot. You won't need the list of changed fields, etc. This is probably the only way to do it, even though it is expensive. Our transaction volume is very low, and our database is relatively small. Regards, Jerry Schwartz The Infoshop by Global Information Incorpo

RE: stored procedure, parameter type help needed

> -Original Message- > From: Magne Westlie [mailto:[EMAIL PROTECTED] > Sent: Friday, February 08, 2008 5:37 AM > To: [EMAIL PROTECTED] > Cc: mysql@lists.mysql.com > Subject: Re: stored procedure, parameter type help needed > > Hi again, > > I found a way that works for the query I wanted in

RE: Error: You can't specify target table '...' for update in FROM clause

> -Original Message- > From: Yves Goergen [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 05, 2008 6:22 PM > To: Baron Schwartz > Cc: mysql@lists.mysql.com > Subject: Re: Error: You can't specify target table '...' for update in > FROM clause > > On 05.02.2008 23:25 CE(S)T, Baron Schwar

RE: GROUP question

That's rather what I feared. I'm trying to avoid code, mostly because this should be a one-off run. I could strangle the designer who didn't make email a unique key (with appropriate coding in the input application). Thanks. Regards, Jerry Schwartz The Infoshop by Glo

GROUP question

ng the obvious here. I've fiddled with sub-queries, but didn't really get anywhere. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.

RE: ON vs. WHERE

> -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 30, 2008 11:50 AM > To: Jerry Schwartz; mysql@lists.mysql.com > Subject: Re: ON vs. WHERE > > At 11:46 AM -0500 1/30/08, Jerry Schwartz wrote: > >The documentation say

ON vs. WHERE

gards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 <http://www.the-infoshop.com> www.the-infoshop.com <http://www.giiexpress.com> www.giiexpress.com www.etudes-marche.com

RE: transfer huge mysql db

ption. :) [JS] Yes, but tar is just extra baggage. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -- MySQL General Mailing List Fo

RE: transfer huge mysql db

> -Original Message- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 29, 2008 2:02 AM > To: Ivan Levchenko > Cc: mysql@lists.mysql.com > Subject: Re: transfer huge mysql db > > Ivan Levchenko wrote: > > Hi All, > > > > What would be the best way to transfer a 20 gig db from

RE: Did NOT condition on VARCHAR change with 5.0.45?

> -Original Message- > From: Mont McAdam [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 22, 2008 7:18 PM > To: mysql@lists.mysql.com > Subject: Re: Did NOT condition on VARCHAR change with 5.0.45? > > `method` is the name of the column in the table. > > In my opinion it should return ev

RE: Changing data types in mysql!

> -Original Message- > From: Lenin Lakshminarayanan [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 22, 2008 6:54 PM > To: mysql@lists.mysql.com > Subject: Changing data types in mysql! > > Hello, > > I was pulling data from one datasource [ oracle ] earlier which had a > couple > of fie

RE: Handling Special Characters

> use UTF-8 for text files > use SET NAMEs to correctly MySQL what charset you are using > > > > -- > Sebastian [JS] You are correct. The results were very confusing, especially since the visual difference between a hyphen (0x2D) and an N-quad (0x96). Also, copying UTF-8 text to a command window s

RE: Handling Special Characters

> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Baron Schwartz > Sent: Friday, January 18, 2008 2:33 PM > To: Jerry Schwartz > Cc: mysql@lists.mysql.com > Subject: Re: Handling Special Characters > > Jerry, > > On Jan 18, 2008 2:27 PM, Jerry Schwar

RE: Handling Special Characters

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Baron Schwartz > Sent: Friday, January 18, 2008 2:33 PM > To: Jerry Schwartz > Cc: mysql@lists.mysql.com > Subject: Re: Handling Special Characters > > Jerry, > > On Jan

Handling Special Characters

.22 community server on a Linux platform. I'm using version 5.0.45 of the CLI client. Anyone have any ideas? I was trying to avoid having to write a program to do this. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8

RE: Forbidden subquery

> -Original Message- > From: Jay Pipes [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 20, 2007 11:25 AM > To: Jerry Schwartz > Cc: mysql@lists.mysql.com > Subject: Re: Forbidden subquery > > No problem. I hope by now you figured out I made a typo... :) T

RE: Forbidden subquery

> > Hi Jerry! > > The very last sentence on: > http://dev.mysql.com/doc/refman/5.0/en/delete.html > > is "Currently, you cannot delete from a table and select from the same > table in a subquery." > [JS] Yes, I knew that. I just thought that illegal query

RE: Forbidden subquery

I did a CHECK TABLE and it reported no errors. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com From: Rodrigo Marins

RE: Forbidden subquery

> > What I want to accomplish is expressed best as > > > > DELETE FROM prod_price > > WHERE prod_price.prod_price_chg_flag = "O" > > AND prod_price.prod_id IN > > > >(SELECT prod_price.prod_id FROM prod_price > >WHERE prod_price.prod_price_chg_flag = "X") > > ; > > > > This is clear, concis

Forbidden subquery

d` datetime default NULL, PRIMARY KEY (`prod_price_id`), KEY `prod_id` (`prod_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 I'm running 5.0.45-community-nt. Suggestions? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.6

RE: Error: No query specified

Are you sure you don't have a semicolon after the \G? That would do it. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-march

RE: speical characters in text column

You need to escape the data read from the form. I'm sure that whatever programming language you are using has some function to do this. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 ww

RE: Update Join with Aliases

You are joining ambien_nev.Sections to itself, but the join condition natural_db.Sections.section_id = ambien_nev.Sections.section_id references a data base that isn't in the join. I think that might be the problem. Regards, Jerry Schwartz The Infoshop by Global Information Incorporate

RE: repost timestamp for update & insert

I think you are missing the data type for spdate_updated. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Mess

RE: Why is Delete slow on a Merge Table?

Does TRUNCATE work on a merge table? I honestly don't know, but it should be faster than a DELETE for removing all of the records. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 ww

RE: IMAGES/PICTURES-MYSQL

ogic to convert a blob in order to serve it up with a script, you just need to programmatically create a link to the image file and let the web server do it. I find that easier to work with, and certainly easier to debug. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated

RE: Fulltext Relevancy not returning anticipated results?

Sorry, no. I hope someone else will be able to help. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Mess

RE: Fulltext Relevancy not returning anticipated results?

By default, MySQL ignores any "word" with less than four characters when doing full text searches. You can change this in my.conf, the setting should be obvious. I had to do this so that customers could find inventory items that were red. Regards, Jerry Schwartz The Infoshop

RE: Select question

Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Message- > From: Matthew Stuart [mailto:[EMAIL PROTECTED]

RE: Query performance plain/text versus AES_DECRYPT(): LIKE %..%

Have you tried reversing the order of your tests, to see if there is some influence from caching? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes

RE: Need ideas on handling aliases and a.k.a.s

ing for. When presenting the image, filmography, or such, you'd use the primary name. To change the primary name, your management interface would present each name separately with a checkbox or some such. Conceptually this seems reasonable to me, but I'm interested to see what others have come up

RE: Query not returning Data

Have you tried testing the two parts of your WHERE clause separately? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Origi

RE: do I need two tables or one will do just fine?

mproves normalization; in fact, I think it reduces it. It will certainly make manipulating it more of a nuisance. By the way, I hope you have a unique identifier for your table. There is more than one John Smith in the world. Regards, Jerry Schwartz The Infoshop by Global Information Incorp

RE: Storing Devnagari unicode data in MySQL

Try upgrading to a version 5 of the ODBC connector. It worked for our Chinese data. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com

RE: Ouch! ibdata files deleted. Why no catastrophe?

thing like that. The file will actually be safe so long as it is not closed by the last user. Those files will go away as soon as they are closed, so the database should be dumped before shutting down mysqld. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmingto

RE: Problem with characters

I found that using version 5.1 of the ODBC connector solved our problem with Chinese characters. It might solve the problem with the pound sterling sign. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

RE: Query to find less than 3 char string

Pain in the neck when you can't find the word "red" in a catalog. I know the problem. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.et

RE: Query to find "foo" within "(foo)"

If you want to match only "(johnie)" or " johnie ", then you could use a regular expression test. They can get as complicated as your brain will tolerate. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

RE: Query to find "foo" within "(foo)"

"(", then you need to get more complicated. You might even need a regular expression. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.c

RE: ordering dates

M news ORDER BY date DESC "); Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Message- > From: Ross H

RE: Left join problem

Which table is bladref in? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Message- > From: Kaj Sc

RE: Reset a auto increment field?

: SELECT COUNT(*) FROM table; SELECT MAX(auto_inc) FROM table; Offhand, I do not know how to do the first. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com

RE: Reset a auto increment field?

table but leave off the autoincrement field. TRUNCATE the original table and copy back the original records, supplying NULL for the autoincrement field. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674

RE: Dynamic tables--always a bad idea?

How are you going to do queries that join or merge thousands of tables? or won't that be necessary? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpres

RE: Database architecture and security

nd if it passed then create a session with the .inc file variables stored as session variables. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.et

RE: Left join is not doing what I thought it should do.

27;t understand what that would do to an AND operation, I would think the result would be false. I hope someone else can explain that to us. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.t

RE: Left join is not doing what I thought it should do.

on UserB. Does that help? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Message- > From: Critters [

RE: Import file into MySQL Database..

Doesn't that (the trailing comma) depend upon whether or not you want the default value for the (missing) field, as opposed to "" or 0 used for empty fields? Either way, you are right - you should be able to import the data. Regards, Jerry Schwartz The Infoshop by Glo

RE: Import file into MySQL Database..

Could the commas at the end of your data lines be causing a problem? (I've never loaded a CSV file.) Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpres

RE: counting on a complex query

Will SELECT SQL_CALC_FOUND_ROWS and SELECT FOUND_ROWS() do what you want? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com

RE: fulltext search option

So far as I know, the only way to accomplish what you want is to do what you tried: put the Boolean match in the WHERE clause and order by a natural match. That's what I do on our web site. By the way, you can't use prefix stemming: "*abcd" is the same as "abcd".

RE: PHP mysqli problem

us part of using prepared statements. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Message- > From: Jerry S

PHP mysqli problem

ws: ' . "\n"; var_dump($num_rows); $row = mysqli_fetch_assoc($result); echo '$row: ' . "\n"; var_dump($row); ?> $result: object(mysqli_result)#2 (0) { } $num_rows: int(1) $row: array(2) { ["prod_num"]=> string(5) "53851" ["prod_title&

RE: MySQL Connector/ODBC 3.51.17 fails to work with MS Access 2002

Hmm... I tried this again with a user that has full access to all databases on the host, and it worked. This read-only user worked on the previous version of the connector, but it only worked on 3.51.17 when I gave it SELECT privilege on the mysql database. Problem solved. Regards, Jerry

MySQL Connector/ODBC 3.51.17 fails to work with MS Access 2002

for user 'readonly'@'%' to database 'mysql' (#1044) The same user with the same password has no trouble accessing the appropriate database ('giiexpr_db') using the mysql CLI from the same computer. Regards, Jerry Schwartz The Infoshop by Global Inf

RE: MySQL admin GUI

Yes, I've been using phpmyadmin. Thanks. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Message- >

MySQL admin GUI

Does anyone know how to add a field anyplace but at the bottom? I haven't found any "insert here" functionality. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-inf

RE: SELECT missing records

My apologies, you were correct: I left out a line from my query, so it would have given bogus results except for the fortunate fact that every product having at least one price has a USD price. The EXPLAIN output didn't change. Regards, Jerry Schwartz The Infoshop by Global Inform

RE: SELECT missing records

key: PRIMARY key_len: 45 ref: giiexpr_db.prod.pub_id rows: 1 Extra: Using where *** 4. row *** id: 2 select_type: DEPENDENT SUBQUERY table: prod_price type: index_subquery possible

RE: SELECT missing records

I think that will give me one record for every price that is not Yen, so if a product has a price in USD and a price in GBP it will show up twice. A GROUP BY might help, I'll have to chew on that. It seems too simple. Regards, Jerry Schwartz The Infoshop by Global Information Incorporate

SELECT missing records

FROM prod JOIN price WHERE prod.prod_id = price.prod_id AND price.prod_id NOT IN (SELECT price.prod_id FROM price WHERE price.prod_curr = "YEN"); Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

RE: MySQL and 'ODBC'@'localhost' error

You didn't specify a user or password on your mysql command line when you redirected your input to your .sql file, and for some reason the default is [EMAIL PROTECTED] You need to use the -p and -u options on the command line. Regards, Jerry Schwartz The Infoshop by Global Inform

RE: off-topic unsubscribe concern

I'm getting them also, I ignore them. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Message- > Fr

RE: zipcode to timezone

I think Indiana has two time zones. I think there are also some states or portions thereof that don't observe daylight saving time. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 ww

RE: about the username and hostname

If you are starting the MySQL command line client from a shortcut, then all you have to do is right-click on the shortcut and examine its properties. The entire command line will be there. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT

RE: select statement with variable for table_reference?

| Imminent | |2 | Incoming | |3 | Follow Up | |4 | Eventual | |5 | Interested | |6 | Ongoing| |7 | Accts | |8 | Dump | |9 | Purchased | +--++ 9 rows in set (0.05 sec) Regards, Jerry Schwar

RE: Birthday format

mysql> SELECT FLOOR(54.75); +--+ | FLOOR(54.75) | +--+ | 54 | +--+ 1 row in set (0.05 sec) Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.

RE: ODBC Drivers 3 and 5

Does that explain why, using ODBC 3.x, I can't retrieve Chinese characters with Access? I never noticed that there was no Unicode support, no wonder I've been beating my head against a wall. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave.

RE: Design Help Needed

) and another table that stores the associated users. You use a unique business ID to find all of the users for a particular business. Once you start thinking that way, you'll start to get the hang of it. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farm

RE: how to get Number of rows matched?

Have you looked at mysql_info()? The format of the return value might not be the most useful, but it should give you what you need. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the

RE: Select and COUNT

SELECT tableA.*, COUNT(*) AS Tot FROM tableB LEFT OUTER JOIN tableA ON tableA.uid=tableB.uid GROUP BY tableA.uid Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com

RE: Lock Tables Question

Whatever you do, make sure that every bit of code that locks multiple resources locks them in the same order. That's the only way to avoid deadlocks. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674

RE: True multi user?

merge engine in VBA before you were done. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Message- > From: JugLug

RE: Trigger question

Will a SELECT * FROM work there? I'm not using 5.x, so I haven't really investigated triggers; this is just a guess. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-in

RE: True multi user?

tion with MySQL. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Message- > From: JugLugs [mailto:[EMAIL PROTECTED] &

RE: Scheduled backups

Are you running on Windows? I seem to recall that you can't normally schedule a task unless the user has a password. That might apply only to XP Pro, I don't know about the server versions of Windows. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farm

RE: multilanguage web application with mysql database?

Are all of your fields using the UTF8 character set? I think that's necessary. We use UTF8 and have stored Chinese characters successfully using UTF8 with a PHP web application. (At least, they look right to me - I don't know Chinese at all.) Regards, Jerry Schwartz Global I

RE: Object-Oriented database

If you serialize the object, you can store it in the data base as a blob. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: sam rumaizan [mailto:[EMAIL PROTECTED]

RE: Less | More

There is no \P command in the Windows version of MySQL (as of 4.x). It would be a nice addition, since there is a more command in the Windows CLI, but I'm not sure how (or if) the piping can be set up in Windows. Regards, Jerry Schwartz Global Information Incorporated 195 Farmingto

RE: basic architecture review?

d you index the ones that have many different values. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Michael Higgins [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 02,

RE: IS NULL Question

me a devil of a time. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Kevin Hunter [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 01, 2007 11:37 AM > To: John Kebbel &g

RE: Research Subjects drawn randomly from databases

Well, then color me baffled. I don't know why your first query didn't work. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: John Kebbel [mailto:[EMAIL P

RE: Research Subjects drawn randomly from databases

WHERE ROUND(id) != id; If you get a non-zero count, then you know that there is a possibility of CEIL(RND()) not hitting an ID. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- >

RE: Optimize code?

Thanks, Jay. Comments interspersed... > Jerry Schwartz wrote: > > I need (ultimately) to update some prices in a prod_price > table. First, I > > need to locate a product and its associated prices using a field > > prod.prod_price_prod_id which is not unique, and is

Optimize code?

CI MySQL, is reported to take .05 seconds. Unfortunately, I have about 20,000 products to process; so at a minimum I would expect it to take 1,000 seconds. Even ignoring the overhead from PHP, this is going to run for awhile. Does anyone have any suggestions for improving my code? Regards, Je

RE: select first letters

I must have misunderstood, then. I thought the Greek characters were more than one byte. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: nikos [mailto:[EMAIL PRO

RE: select first letters

The multi-byte extension doesn't seem to include one, but it appears that somebody put one together and posted it in the notes on chr(). http://us2.php.net/manual/en/function.chr.php#69082 Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT

RE: select first letters

It would depend upon the collating sequence for the field. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: nikos [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April

RE: select first letters

he English letters. The former would be safer, just to guard against the possibility that some non-Greek Latin characters have crept in. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message-

RE: Results taking over 15 seconds!

. As for the query, you didn't give us anything to go on. What kind of WHERE are you doing? Are you using a full-text search, or a LIKE? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Ori

RE: Max columns in a tabel in MyISAM storage engine

I agree it is poor design, but other than putting a full text index on the answers I'm not sure what can be done. Of course, that might well be faster for retrievals; but it would be slower on insertion. I don't know which would predominate in this case. Regards, Jerry Schwa

<    1   2   3   4   5   6   7   8   9   >