>-Original Message-
>From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
>Sent: Monday, October 26, 2009 5:29 AM
>To: Jerry Schwartz
>Cc: [MySQL]
>Subject: Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1
>
>Thanks for the response Jerry. I sup
The UTF-8 issue was the only thing that really concerned me at the time. I work
for a multi-national based in Japan.
Isn’t there a change log on the MySQL web site?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
The key difference for me was the ability to handle UTF-8.
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
>-Original Message-
>From: Tompkins Neil [mailto:neil
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
>-Original Message-
>From: Scott Haneda [mailto:talkli...@newgeo.com]
>Sent: Friday, October 16, 2009 2:
>-Original Message-
>From: Ray [mailto:r...@stilltech.net]
>Sent: Friday, October 16, 2009 1:10 PM
>To: mysql@lists.mysql.com
>Subject: Re: insert random number into table
>
>On October 16, 2009 10:57:48 am Jerry Schwartz wrote:
>> There is a RAND function i
s the Internet
(at least).
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
>-Original Message-
>From: Ray [mailto:r...@stilltech.net]
>Sent: Friday, October 16,
;\G" instead of
";". I think it's easier to read.
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
>-Original Message-
>From: Ian [mailto:bar
>-Original Message-
>From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com]
>Sent: Wednesday, October 07, 2009 2:15 PM
>To: 'John Oliver'; mysql@lists.mysql.com
>Subject: RE: Dump / restore rows in table?
>
[JS] I should have mentioned that you can do thi
TABLE new_one LIKE old_one;
INSERT INTO new_one SELECT * FROM old_one LIMIT 1000,5000;
If you want a random selection (say 1% of your original records), use
... WHERE RAND() < .01;
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06
ile. Depending upon the data, and exactly how you've
specified the export, it can put double-quotes in unexpected places.
If you leave out the 17th line of data what happens?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 0603
note. Obviously I can’t use MAX(NoteText). I could do this using a
temporary table, but it seems like there should be another way.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
close as I can come to a similar application, off the
top of my head.
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
>-Original Message-
>From: Mike Spreit
"Approximate" things are something humans are very good at, but computers are
not. I'll bet a Rolodex would be faster than a web-based application.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FA
SoundEx doesn't do much for names, or non-English words for that matter.
Although you could use AJAX to handle the web part of this, I can't imagine it
being able to handle much of a load. I think you'll beat the system to death,
to little avail.
Regards,
Jerry Schwartz
The Inf
ey aren't
>evaluated until after the WHERE clause is applied.
>
[JS] You can use the HAVING clause, although it is probably inefficient.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
ww
#x27;t need Article_Type table if you're going to store
>Article_Type value directly."
>
>is my answer.
>
[JS] I might have missed part of the discussion, but a foreign key back to an
Article_Type table would help enforce data integrity.
Regards,
Jerry Schwartz
The Infoshop by
.)
>
>Thank you,
>:)
>
[JS] Based on my (somewhat distant) experience, using a database as a FIFO can
turn into a performance nightmare. I don't know how many "workers" you plan on
having, nor how many incoming jobs you're going to have, but unless your sleep
ti
lly, its voodoo :)
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
>Christos, you can download and run mysqlreport from
>http://hackmysql.com/mysqlreportguide
>it wi
then I think you'll need to go with "fill in the blanks" type of
query form.
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
>Are there other viable ways
here was one response that suited all
questions: "It depends".
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
--
MySQL General Mailing List
For list archives:
>-Original Message-
>From: Gavin Towey [mailto:gto...@ffn.com]
>Sent: Friday, August 21, 2009 2:45 PM
>To: Jerry Schwartz; 'mos'; 'MySQL'
>Subject: RE: Scaling Mysql
>
>RENAME statement is atomic, and you can specify multiple tables to rename
a
ration
might be, the application is likely to collide with it.
You cannot rename a locked table, so I'm not sure how you could do what you
are suggesting in an ACID way. You'd need some kind of semaphore somewhere.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporate
to fetch only rows starting with
''sr/db"
>>>
[JS] I might not understand what you want to do, especially since you begin
your string with two single-quotes and end it with one double-quote.
You want to find those ROWS (not lines) in which `t` begins with the five
characters
Been there, done that - over and over. It is one of the FAQs:
http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html
>-Original Message-
>From: Noah Garrett Wallach [mailto:no...@yahoo-inc.com]
>Sent: Thursday, August 13, 2009 2:49 AM
>To: mysql@lists.mysql.com
>Subject: settin
I hope you mean that the SHOW WARNINGS statements follow the DDL statements.
If the DROP statements have the IF EXISTS modifier, then there should not be
any warnings shown in the output. If there are, something (less severe than
an outright error) is wrong with the CREATE statement. It might be s
>-Original Message-
>From: Michael Abbott [mailto:damy...@hotmail.com]
>Sent: Saturday, July 11, 2009 11:10 AM
>To: mysql@lists.mysql.com
>Subject: What to Download
>
>
>Hi Folks, can someone give me some info on what I need to download
>here?? I just bought a new 64 bit laptop
>
pletely oblivious to
any and all web servers.
>phpMyAdmin? I tried MySQLAdmin on my Linux system, but I could not cut
>and
>paste SQL Commands into the editor.
>
[JS] I use PHPAdmin. When you install the Windows MSI package for PHP, it
will ask you which web server you want to configure. You
>-Original Message-
>From: OKAN ARI [mailto:okan...@aribem.com]
>Sent: Monday, July 06, 2009 11:39 AM
>To: Jerry Schwartz
>Subject: Re: How To Clean Old Table Data
>
>Thank you Jerry Schwartz and Blog Tieng Viet,
>
>To Viet: Mysql server is up alt lease 1 ye
>-Original Message-
>From: Carlos Williams [mailto:carlosw...@gmail.com]
>Sent: Monday, July 06, 2009 9:59 AM
>To: mysql@lists.mysql.com
>Subject: How To Clean Old Table Data
>
>I have an application that crates a users email info in MySQL every time
>they login into the application. The
>-Original Message-
>From: Carlos Williams [mailto:carlosw...@gmail.com]
>Sent: Monday, July 06, 2009 10:53 AM
>To: mysql@lists.mysql.com
>Subject: How To Clean Old Table Data
>
>I have an application that crates a users email info in MySQL every time
>they login into the application. The
>-Original Message-
>From: OKAN ARI [mailto:okan...@aribem.com]
>Sent: Monday, July 06, 2009 10:54 AM
>To: mysql@lists.mysql.com
>Subject: Dramatic performance problem
>
>Hi to every body, I am newbie for mysql lists. I have a mysql server
>with 2GB of ram and Core2Duo cpu. Until today my
>-Original Message-
>From: Jason Todd Slack-Moehrle [mailto:mailingli...@mailnewsrss.com]
>Sent: Friday, June 26, 2009 1:10 PM
>To: mysql@lists.mysql.com
>Subject: Default Date and Time
>
>Hi All,
>
>I want to create a table that defaults to current_date and current_time.
>
[JS] Would a t
Oops, my spell checker got the better of me: it should be "Fibre" Channel.
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
>-Original Message-
gt;Login mysql client. Do the following commands.
>tee ie.txt;
>...
>notee;
>
[JS] A more useful way is to redirect the output of the MySQL CLI into a
file. That will give you a tab-delimited file:
>mysql .... < query.sql > queryoutput.txt
Regards,
Jerry Schwartz
The Infoshop
>-Original Message-
>From: Moon's Father [mailto:yueliangdao0...@gmail.com]
>Sent: Friday, June 26, 2009 4:12 AM
>To: mos
>Cc: mysql@lists.mysql.com
>Subject: Re: Indexing dynamics in MySQL Community Edition 5.1.34
>
>Who can please tell me what is mean of "The db storage is on fiber
>cha
>-Original Message-
>From: Mike Spreitzer [mailto:mspre...@us.ibm.com]
>Sent: Thursday, June 25, 2009 1:38 AM
>To: mysql@lists.mysql.com
>Subject: Re: Indexing dynamics in MySQL Community Edition 5.1.34
>
>Actually, my characterization of the current state is wrong. It appears
>that one
>-Original Message-
>From: hezjing [mailto:hezj...@gmail.com]
>Sent: Thursday, June 18, 2009 5:04 AM
>To: mysql@lists.mysql.com
>Subject: How to specify CHAR column to accept specific characters
>
>Hi
>I'm using MySQL 5.1.
>
>How do we create a constraint on char column to accept only chara
e
application code to tell the MySQL server to stop. I'm pretty sure you could
create a "tired of waiting" button for the user, but I haven't done it
myself.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.
>> [JS] So far as I know, Windows supports mount points but not symbolic
>> links.
>
>You are correct Jerry, Windows does not support symbolic links but for
>MySQL purposes you can create an .sym file containing the full path to
>the
>new location and MySQL will re
>-Original Message-
>From: John Daisley [mailto:john.dais...@mypostoffice.co.uk]
>Sent: Tuesday, June 02, 2009 6:30 AM
>To: Foo JH
>Cc: schackenb...@termindoc.de; mysql@lists.mysql.com
>Subject: Re: AW: creating databases in different folders
>
>MySQL represents each database by means of
>-Original Message-
>From: mugisha moses [mailto:mossp...@gmail.com]
>Sent: Thursday, May 28, 2009 12:11 AM
>To: Arthur Fuller
>Cc: mysql
>Subject: Re: Can a MyISAM DB hold /everything/?
>
>what if you had no issues of scaling, which would have less access
>time, file system or database?
>-Original Message-
>From: Sebastien Moretti [mailto:sebastien.more...@unil.ch]
>Sent: Thursday, May 28, 2009 2:38 AM
>To: Baron Schwartz; mysql@lists.mysql.com
>Subject: Re: innodb_file_per_table cost
>
>> Hi Sebastian,
>>
>> It depends. In general, no. In some filesystems and operatin
I'm not running with replication, but I AM often running the CLI against the
production and test environments at the same time. I found it invaluable to
add the line
prompt=\h >
to my.ini (I'm running on Windows). That adds the host name to the prompt,
and has saved my butt more than once.
>
You might even want to plan for longer MAC addresses. I don't follow
developments in that area, but they had to go from IP4 to IP6 and they might
have to introduce longer MAC addresses.
It isn't hard to change a MySQL field definition, but your applications
would be more of a problem.
>-Origi
Thanks, I knew it had to be something simple. Now I can clean out my "save
this in case you make a mistake" tables.
>-Original Message-
>From: Steve Edberg [mailto:sbedb...@ucdavis.edu]
>Sent: Tuesday, May 05, 2009 11:00 AM
>To: Jerry Schwartz; mysql@lists.mysql.com
At the risk of getting spanked for not finding this in the documentation,
I'm asking a simple question:
Can I tell when a table was created?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796
=
`t3`.`y`;
Table `t3` won't have any indices, even if table `t2` does, is that correct?
(Assume that the sub-select is really much more complicated that my
example.) Wouldn't it be a lot faster to replace the sub-select with a
temporary table that does have a key on `y`?
Regards
>-Original Message-
>From: shawn.gr...@sun.com [mailto:shawn.gr...@sun.com]
>Sent: Saturday, April 11, 2009 3:50 PM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: LEFT JOIN with third-table key
>
>Jerry Schwartz wrote:
>> This is a question
work okay.
Of course, there was a price difference. :<)
As others said, the major bottlenecks are likely to be internal (to the DB)
locking and disk access speed.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 /
ct_id
SET D.product_price = 2 * D.product_price;
Is that the right / best way to handle this?
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-
>-Original Message-
>From: Martin Gainty [mailto:mgai...@hotmail.com]
>Sent: Monday, March 23, 2009 11:49 AM
>To: Jerry Schwartz; wagnerbian...@yahoo.com.br
>Cc: mysql@lists.mysql.com
>Subject: RE: Error -1
>
>
>
>SELECT bunch_of_columns FROM bun
>-Original Message-
>From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com]
>Sent: Saturday, March 21, 2009 9:57 PM
>To: 'MySql'
>Subject: Error -1
>
>I'm running 5.1.31-community on WinXP.
>
>Im getting
>
>ERROR 1030 (HY000): Got er
From: Wagner Bianchi [mailto:wagnerbian...@yahoo.com.br]
Sent: Monday, March 23, 2009 7:57 AM
To: Jerry Schwartz
Subject: Res: Error -1
Hi friend,
You can use this, but, the -1 Error you got on the situation in you use InnoDB
and it's crash.
[JS] I'm not using InnoDB for this table
mer_id
ORDER BY note_timestamp DESC LIMIT 1) OR memos.note_id IS NULL) LIMIT 0,25;
The error -1 isn't very helpful, does anyone have a clue? Perhaps I can't
use MATCH in a JOIN condition?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington
keys: customer_id
key: customer_id
key_len: 4
ref: giiexpr_customers.temp_del_ids.cust_id
rows: 3
Extra: Using index
==
Am I right to be surprised, or am I just misinterpreting what's going on?
Regards,
Jerry Schwartz
The
>-Original Message-
>From: Paul McCullagh [mailto:paul.mccull...@primebase.com]
>Sent: Monday, March 09, 2009 6:34 PM
>To: Mattia Merzi
>Cc: MySql
>Subject: Re: InnoDB deadlocks
>
>Hi Mattia,
>
>On Mar 9, 2009, at 6:21 PM, Mattia Merzi wrote:
>
>> Hi everyone,
>>
>> I've got some problems w
When I upgraded from 5.0 to 5.1, I fetched the 5.1 reference manual. Is it
my imagination, or is this thing messed up? Searching for a term comes up
with nothing (try "Varchar"), and the index is not in alphabetical order.
Regards,
Jerry Schwartz
The Infoshop by Global I
Sorry, I should know better.
>-Original Message-
>From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk]
>Sent: Thursday, February 26, 2009 1:51 PM
>To: Jerry Schwartz
>Cc: 'PJ'; 'Gary W. Smith'; 'MySql'; php-gene...@lists.php.net
>Su
e specific
database changes. You can make yourself more independent of the specific
database by using the PDO abstraction, although I would save that for a
rainy weekend.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FA
>-Original Message-
>From: PJ [mailto:af.gour...@videotron.ca]
>Sent: Thursday, February 26, 2009 12:28 PM
>To: php-gene...@lists.php.net; MySql
>Subject: catch the error
>
>What is wrond with this file? same identical insert works from console
>but not from this file :-(
>
>
>
>Untit
>-Original Message-
>From: PJ [mailto:af.gour...@videotron.ca]
>Sent: Thursday, February 26, 2009 11:27 AM
>To: Jerry Schwartz
>Cc: a...@ashleysheridan.co.uk; 'Gary W. Smith'; 'MySql'; php-
>gene...@lists.php.net
>Subject: Re: [PHP] RE: non-auto i
>-Original Message-
>From: walterh...@gmail.com [mailto:walterh...@gmail.com] On Behalf Of
>Walter Heck
>Sent: Wednesday, February 25, 2009 11:43 PM
>To: Jerry Schwartz
>Cc: Gary W. Smith; Claudio Nanni; MySql
>Subject: Re: Upgrade story / request for insight
>
&g
record that has an auto-increment field, you can retrieve the value that got
inserted with "SELECT LAST_INSERT_ID()". It is connection-specific, so
you'll always have your "own" value. You can then save it to reuse, either
as a session variable or (more easily) as a hidden f
ry,
>accessed by user/password login... so there's really very little
>possibility of 2 people accessing at the same time.
[JS] Being rather old to all this, I can tell you that if something is even
remotely possible it will happen just before your performance review. Never
depend u
From: Gary W. Smith [mailto:g...@primeexalia.com]
Sent: Wednesday, February 25, 2009 4:36 PM
To: Claudio Nanni; Jerry Schwartz
Cc: MySql
Subject: RE: Upgrade story / request for insight
Jerry,
To touch a little more on Claudio's statement, you are trying to compare
monkey's
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Wednesday, February 25, 2009 3:51 PM
To: Jerry Schwartz
Cc: MySql
Subject: Re: Upgrade story / request for insight
Hi Jerry,
probably does not help you very much and excuse me in advance for this,
[JS] No apology necessary.
but
there on I was able to run mysql_upgrade
and get myself back on the air.
Can anyone guess where I went astray?
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
>-Original Message-
>From: Hagen Finley [mailto:finha...@comcast.net]
>Sent: Monday, February 23, 2009 11:41 AM
>To: 'MySql'
>Subject: Record IDs
>
>I have a number of duplicate records in my table which are identical
>hence,
>I can't do a delete on the columns without deleting both recor
>-Original Message-
>From: PJ [mailto:af.gour...@videotron.ca]
>Sent: Sunday, February 22, 2009 2:39 PM
>To: MySql
>Subject: book categories
>
>Here's a tough one...
>In my library I have some 62 categories where a number of books can be
>in several categories.
>Now, to relate the "catego
>-Original Message-
>From: Peter Brawley [mailto:peter.braw...@earthlink.net]
>Sent: Friday, February 13, 2009 3:02 PM
>To: Yusuf Khan
>Cc: mysql@lists.mysql.com
>Subject: Re: Codd's rule 8 (physical data idependence)
>
>>*Applications should not be logicaly impaired when the physical sto
>-Original Message-
>From: Yariv Omer [mailto:yar...@jungo.com]
>Sent: Wednesday, February 04, 2009 10:50 AM
>To: mysql@lists.mysql.com
>Subject: like isn't behave as expected
>
>Hi
>
>i have one row in the cpe_id column of the cpe_users table in my
>database with the value: "d\d".
>
>when
>-Original Message-
>From: John Daisley [mailto:john.dais...@mypostoffice.co.uk]
>Sent: Wednesday, February 04, 2009 10:41 AM
>To: mysql@lists.mysql.com
>Cc: Jerry Schwartz
>Subject: Re: WHERE vs. ON
>
>Never tried it in MySQL and Im not
>in a position to d
>-Original Message-
>From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
>Behalf Of Baron Schwartz
>Sent: Wednesday, February 04, 2009 10:03 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: WHERE vs. ON
>
>On Tue, Feb 3, 2009
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Tuesday, February 03, 2009 1:03 PM
To: Jerry Schwartz; mysql@lists.mysql.com
Subject: RE: WHERE vs. ON
ON condition uses the same columnname from both source and target tables
whereas any column expressions can go in the WHERE
_type: SIMPLE
table: prod
type: ref
possible_keys: pub_id
key: pub_id
key_len: 46
ref: giiexpr_db.pub.pub_id
rows: 112
Extra: Using where
2 rows in set (0.06 sec)
Are the results the same because my query is too simple?
Why use a cannon on a gnat?
Your data is already in an Excel spreadsheet, so why not use Excel to do
this?
=ISODD(LEFT(A1,SEARCH(" ",A1)-1))
Will be true if the street number is odd; then you can just filter on that
column to select the "TRUE" rows, and copy them to wherever you need them.
>---
>IMO, offering a variety of input formats just creates one big mess.
>How often have you read some date notation and wondered which format was
>used - if all values are in the 1 to 12 range, you have to guess.
>
[JS] I agree 100%. I have to deal with dates from all over the world, and I
often have
>-Original Message-
>From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On
>Behalf Of Vikram Vaswani
>Sent: Monday, January 26, 2009 11:29 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Help with formatting of 1:n relationship
>
>
>-Original Message-
>From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On
>Behalf Of Vikram Vaswani
>Sent: Monday, January 26, 2009 7:02 AM
>To: mysql@lists.mysql.com
>Subject: Help with formatting of 1:n relationship
>
>Hello all
>
>I have a database with a 1:n relationshi
>-Original Message-
>From: Claudio Nanni [mailto:claudio.na...@gmail.com]
>Sent: Wednesday, January 14, 2009 4:50 AM
>To: Brent Clark
>Cc: mysql@lists.mysql.com
>Subject: Re: Unused and empty tables -> what impact on mysql
>
>Empty files, like empty tables is not synonym for useless or un
>-Original Message-
>From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
>Behalf Of Baron Schwartz
>Sent: Wednesday, January 07, 2009 9:54 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Limit within groups
>
>On Tue, Jan 6, 2009
>-Original Message-
>From: freedc@gmail.com [mailto:freedc@gmail.com] On Behalf Of
>Phil
>Sent: Tuesday, January 06, 2009 3:41 PM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Limit within groups
>
>How about something like
>
>
"GROUP BY account, customer LIMIT 20", I'll get the first 20
customers for the first account. If I try "GROUP BY account, customer ORDER
BY SUM(sale_amount) DESC LIMIT 20", I'll get the top 20 customers.
What am I missing?
Regards,
Jerry Schwartz
The Infoshop
>-Original Message-
>From: c...@l-i-e.com [mailto:c...@l-i-e.com]
>Sent: Tuesday, January 06, 2009 9:47 AM
>To: mysql@lists.mysql.com
>Subject: RE: how to design book db
>
>
>Just theories here:
>
>
>
>The same book re-issued by another publisher might have a different
>ISBN.
>
>
>
>A book
>-Original Message-
>From: Lola J. Lee Beno [mailto:l...@his.com]
>Sent: Thursday, January 01, 2009 5:08 PM
>To: 'MySQL'
>Subject: How to Use Cascade Delete Properly
>
>I'm trying to understand how to use cascade delete properly but not sure
>if I have this backwards or not. Here's an ex
>-Original Message-
>From: Johnny Withers [mailto:joh...@pixelated.net]
>Sent: Wednesday, December 31, 2008 1:13 PM
>To: MySQL General List
>Subject: Compare DATETIME to DATE
>
>Hi,
>I don't quite understand (or even know) what the "proper" way to compare
>a
>DATETIME column to a given DA
r to
Calc spreadsheets, and save them as CVS files.
Opening an Access database in Base is a little confusing, you have to
"connect" to it rather than open it directly, but you don't need any ODBC or
JDBC at all.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorp
//www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-
9B72-EF94E038C891&displaylang=en#Instructions
If that is true (that it doesn't require Access to be installed), you can
write a simple program to read the .accdb file and write it out as anything
you want.
Regards,
I'm late to the game, but many Windows installers run the actual installer
for required applications. Have your application's installer run the normal
installation package for MySQL.
That's all I can give you, my knowledge of installers is too old to be of
real use.
Regards,
Jer
>-Original Message-
>From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On
>Behalf Of Vikram Vaswani
>Sent: Thursday, December 25, 2008 5:47 AM
>To: mysql@lists.mysql.com
>Subject: Question on default database for stored functions
>
>Hi
>
>According to the MySQL manual, "By
>-Original Message-
>From: Andy Shellam [mailto:andy-li...@networkmail.eu]
>Sent: Wednesday, December 17, 2008 3:29 PM
>To: Lamp Lists
>Cc: mysql@lists.mysql.com
>Subject: Re: need help with query...
>
>Hi Afan
>
>Why not prefix your field names with the table name?
>
>select
> p.first_nam
les in which a particular person_id is
found.
I don't know if this suits your needs.
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
() < .1) ORDER BY score
DESC;
That should give you a random sample of approximately 10% of your original
table, in descending order by score.
Regards,
Jerry Schwartz
The Infoshop by 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, December 05, 2008 8:50 AM
>To: MySQL
>Subject: SELECT with replacement chars
>
>Hi
>how can i replace, in a SELECT query, the last 3 numbers with asterisks?
>from 0123456789 to 0123456***
>
[JS]
SELECT CONCAT(LE
ng Windows version 5.0.45-community-nt and it did not come with cp1252
(at least by that name).
I get a lot of data that has "special" cp1252 characters in it (used in MS
Word, typically) and they drive me crazy nine ways from Sunday.
Regards,
Jerry Schwartz
The Infoshop by Global Info
I have a table with a memo field, and I want to build a table of all words
used in all rows of that memo field.
Suggestions?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the
>-Original Message-
>From: Mike Blezien [mailto:[EMAIL PROTECTED]
>Sent: Sunday, November 23, 2008 4:59 PM
>To: MySQL List
>Subject: Special Characters
>
>Hello,
>
>we are in the process of setting up a database with members data and
>other info.
>We'll need to enter names with special ch
"Many MySQL APIs (such as PHP) allow you to treat the result returned from a
SHOW statement as you would a result set from a SELECT; see Chapter 22, APIs
and Libraries, or your API documentation for more information. In addition,
you can work in SQL with results from queries on tables in the
INFORM
>-Original Message-
>From: Martijn Tonies [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, November 19, 2008 3:33 AM
>To: mysql@lists.mysql.com
>Subject: Re: Finding not quite duplicates
>
>> [JS] If there were one row that had prod_discont = 1, and another that
>had
>> prod_discont = 0, and
scont = 0 OR a.prod_discont IS NULL)
ORDER BY b.prod_pub_prod_id;
The problem is with 3). It seems like I should be able to do this with one
query, but I'm beginning to think that I need a separate query and a third
table.
Suggestions, anyone?
Regards,
Jerry Schwartz
The Infoshop by
201 - 300 of 859 matches
Mail list logo
