RE: normalised designs: customer database

If all you want to do is to restrict a field to certain values, and aren't concerned with cascading operations, is a set more efficient than a foreign key? Regards,   Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032   860.674.8796

RE: normalised designs: customer database

>-Original Message- >From: metastable [mailto:[EMAIL PROTECTED] >Sent: Friday, November 14, 2008 8:49 AM >To: mysql >Subject: normalised designs: customer database > [JS] My first suggestion, and I am entirely sincere, is that you use either an off the shelf solution or an external service.

RE: Row before and after?

>-Original Message- >From: Waynn Lue [mailto:[EMAIL PROTECTED] >Sent: Wednesday, November 12, 2008 3:14 AM >To: MySQL List >Subject: Row before and after? > >I'm trying to find the first row before and the first row after a >specific >row. Essentially I want to do these two queries, and

Joining subqueries

`prod_discont` = 0. I think the query makes sense to a human, but I get ERROR 1137 (HY000): Can't reopen table: 'mrc_titles' from MySQL 4.1.22-standard. I didn't see anything about this limitation in the 4.x documentation (although somehow it seems to ring a bel

RE: Finding gaps

Thanks. Although I've been around SQL for quite a while, I've never really gotten the hang of self-joins. From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 8:22 PM To: US Data Export; mysql@lists.mysql.com Subject: Re: Finding gaps Jerry,

RE: Finding gaps

od_num < min(b.prod_num) -1 ; ERROR 1054 (42S22): Unknown column 'a.prod_num' in 'having clause' I must be missing something obvious; or does this not work in 4.1.22? Regards,   Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06

RE: Finding gaps

Alas, the gaps are as large as 500. Normally, products are never deleted from the system; but I put in some corrupt data that I did not want to pass along, even if I marked them as discontinued. They complain about that, too. Regards,   Jerry Schwartz The Infoshop by Global Information

RE: Finding gaps

Yes, that would have been a very good idea. I did not design this. Even if we used auto-increment, my current problem would be the same: finding gaps in the numbering. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

RE: Finding gaps

>-Original Message- >From: Stut [mailto:[EMAIL PROTECTED] >Sent: Wednesday, September 17, 2008 6:30 PM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >Subject: Re: Finding gaps > >On 17 Sep 2008, at 22:34, Jerry Schwartz wrote: >> Our Japanese partners wil

RE: Finding gaps

Our Japanese partners will notice and will ask. Similar things have come up before. I want to be pro-active. 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

Finding gaps

I have records that should be sequentially (not auto-increment) numbered, but there are gaps. Is there any elegant way of finding the gaps? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

RE: Selecting a column with a regular expression applied to it?

>-Original Message- >From: Darryle Steplight [mailto:[EMAIL PROTECTED] >Sent: Thursday, September 11, 2008 10:00 AM >To: Ryan Stille >Cc: mysql@lists.mysql.com >Subject: Re: Selecting a column with a regular expression applied to it? > >Hi Ryan, > >MySql does have regular expressions. See L

RE: Erro 1406 Data too long

From: Roland Kaber [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2008 11:24 PM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Erro 1406 Data too long It looks like it is really a character set conflict. The copyright character © is ascii 169 and is part of latin-1

RE: Erro 1406 Data too long

It is a character set conflict between the source of the data and the column. I run into this all of the time when using the CLI. Programmatically it can be avoided. Regards,   Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032   860.674.8796

RE: Large Query Question.

>-Original Message- >From: Brent Baisley [mailto:[EMAIL PROTECTED] >Sent: Wednesday, September 03, 2008 5:35 PM >To: Jim Leavitt >Cc: mysql@lists.mysql.com >Subject: Re: Large Query Question. > >That's a lot of data to return, make sure you factor in data load and >transfer time. You may tr

RE: Normalization vs. Performance

>-Original Message- >From: Kevin Hunter [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 28, 2008 10:59 PM >To: John Smith >Cc: MySQL General List >Subject: Re: Normalization vs. Performance > >At 2:11pm -0400 on Tue, 26 Aug 2008, John Smith wrote: >> So how bad is this? The mentioned quer

RE: Huge temporary file

From: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2008 1:58 AM To: Jerry Schwartz Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: Huge temporary file do, show varaibles like '%tmp%'. show variables like '%tmp%'; | tmpdir

TEXT(n)

e and went? Was the documentation wrong? (I downloaded a compiled Windows help file.) Regards, 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-i

RE: Huge temporary file

>-Original Message- >From: news [mailto:[EMAIL PROTECTED] On Behalf Of >[EMAIL PROTECTED] >Sent: Tuesday, August 26, 2008 2:36 AM >To: mysql@lists.mysql.com >Subject: Re: Huge temporary file > >In infinite wisdom "Jerry Schwartz" <[EMAIL PROTECTED]>

RE: Huge temporary file

From: Johnny Withers [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 9:37 AM To: Jerry Schwartz Subject: Re: Huge temporary file You are using the defaults then, I'm not sure what they are, but you can view the location of the temp directory (probably /tmp) and the maximum si

RE: Huge temporary file

>-Original Message- >From: news [mailto:[EMAIL PROTECTED] On Behalf Of >[EMAIL PROTECTED] >Sent: Tuesday, August 26, 2008 2:36 AM >To: mysql@lists.mysql.com >Subject: Re: Huge temporary file > >In infinite wisdom "Jerry Schwartz" <[EMAIL PROTECTED]&g

RE: Huge temporary file

From: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 12:09 AM To: Jerry Schwartz Cc: mysql Subject: Re: Huge temporary file what is the value for tmpdir parameter in you my.cnf. [JS] I don't have one. The /tmp file system is what is being consumed. I should add

Huge temporary file

ment, `stage_name` varchar(15) default NULL, PRIMARY KEY (`stage_id`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 I can supply the structures of the other tables, but I wanted to keep this post reasonably short. Regards,   Jerry Schwartz The Infoshop by Global Information Incorpor

RE: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

>-Original Message- >From: Jim Lyons [mailto:[EMAIL PROTECTED] >Sent: Sunday, August 24, 2008 12:00 PM >To: Deniss Hennesy >Cc: mysql >Subject: Re: ERROR 1050 ( ) at line : Table 'columns_priv' already >exists > >correction, the command that's failing evidently is the 'create table >columns

RE: Zip Codes with Leading Zeros

>-Original Message- >From: Andy Shellam [mailto:[EMAIL PROTECTED] >Sent: Friday, August 22, 2008 4:39 AM >To: mysql@lists.mysql.com >Subject: Re: Zip Codes with Leading Zeros > >FYI, we have the same issue with exporting phone numbers from MS SQL. >All phones numbers >in the UK start with z

RE: Zip Codes with Leading Zeros

>-Original Message- >From: Keith Spiller [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 21, 2008 10:12 PM >To: mysql@lists.mysql.com >Subject: Zip Codes with Leading Zeros > >Hi, > >RE: Zip Codes with Leading Zeros > >We need to export a MySQL table with a zip code field to Excel. We >

RE: Need help to query with timestamp in C++

:03, what is it that you want to return? 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: Kand

RE: Unique Id generation

>I try to generate a unique id for each row in a Mysql-InnoDB Table. >Because of many deletes I can't use an auto_increment column. >After a Mysql restart, the next value for an auto_increment-column is >max(auto_increment-column)+1, and I need a really unique id. > [JS] See if the UUID() functio

RE: looking for "ready made" address management

and has ongoing community support. I maintain a home-brew CRM system, and it is a never-ending source of grief. Our sales and marketing people are always asking for very reasonable extensions that are increasingly hard to shoe-horn in. Regards, Jerry Schwartz The Infoshop by Global Information

RE: Transplanting table structure changes

Thanks, but I decided to grunt through it using PHPMyAdmin. This doesn't happen very often, so I can't see investing in a tool at this point. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 86

RE: Transplanting table structure changes

>You might want to try our Schema Compare tool inside Database Workbench. >This tool also has a "script recorder" that can record any changes you >make >to (meta)data in order to help you keep your change scripts. > [JS] Ah! I just discovered that if I hit what looks like the "record" button, I get

RE: Transplanting table structure changes

>-Original Message- >From: Martijn Tonies [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 07, 2008 1:46 AM >To: mysql@lists.mysql.com >Subject: Re: Transplanting table structure changes > >Hello Jerry, > >> I've added about a dozen new colu

Transplanting table structure changes

S Access to view and filter these tables. Regards, 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: SET vs. ENUM

>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perrin >Harkins >Sent: Thursday, July 31, 2008 11:25 AM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >Subject: Re: SET vs. ENUM > >On Thu, Jul 31, 2008 at 9:46 AM, Jerry Schwartz ><[EMAIL PROTECTED]&

RE: Re-arranging fields

>-Original Message- >From: Mr. Shawn H. Corey [mailto:[EMAIL PROTECTED] >Sent: Thursday, July 31, 2008 10:54 AM >To: Jerry Schwartz >Cc: 'Ranjeet Walunj'; mysql@lists.mysql.com >Subject: RE: Re-arranging fields > >On Thu, 2008-07-31 at 10:24 -0400, Jerry

RE: Re-arranging fields

>-Original Message- >From: Martijn Tonies [mailto:[EMAIL PROTECTED] >Sent: Thursday, July 31, 2008 10:37 AM >To: mysql@lists.mysql.com >Subject: Re: Re-arranging fields > >> >> [JS] I added a dozen or so columns for a special purpose, and >although >> >MySQL >> >> doesn't care I wanted them

RE: SET vs. ENUM

>-Original Message- >From: Martijn Tonies [mailto:[EMAIL PROTECTED] >Sent: Thursday, July 31, 2008 10:32 AM >To: mysql@lists.mysql.com >Subject: Re: SET vs. ENUM > >Jerry, > >> >> Other than the fact that an ENUM can have many more values than a >

RE: Re-arranging fields

>-Original Message- >From: Mr. Shawn H. Corey [mailto:[EMAIL PROTECTED] >Sent: Thursday, July 31, 2008 10:02 AM >To: Jerry Schwartz >Cc: 'Ranjeet Walunj'; mysql@lists.mysql.com >Subject: RE: Re-arranging fields > >On Thu, 2008-07-31 at 09:56 -0400, Jerry S

RE: SET vs. ENUM

>-Original Message- >From: Martijn Tonies [mailto:[EMAIL PROTECTED] >Sent: Thursday, July 31, 2008 9:51 AM >To: mysql@lists.mysql.com >Subject: Re: SET vs. ENUM > >Jerry, > >> Other than the fact that an ENUM can have many more values than a SET, >is

RE: COUNT returned rows of a SELECT

>-Original Message- >From: Fish Kungfu [mailto:[EMAIL PROTECTED] >Sent: Thursday, July 31, 2008 12:41 AM >To: mysql@lists.mysql.com >Subject: COUNT returned rows of a SELECT > >Using MySQL commands only (not PHP's mysql_num_rows), is there a way to >COUNT the number of rows returned from a

RE: Re-arranging fields

>-Original Message- >From: Mr. Shawn H. Corey [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 30, 2008 4:06 PM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >Subject: Re: Re-arranging fields > >On Wed, 2008-07-30 at 14:42 -0400, Jerry Schwartz wrote: >> Is

RE: Re-arranging fields

>-Original Message- >From: Rob Wultsch [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 30, 2008 3:56 PM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >Subject: Re: Re-arranging fields > >Something like >ALTER TABLE [TABLE] MODIFY [COLUMN] col_name column

RE: Re-arranging fields

>-Original Message- >From: Ranjeet Walunj [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 30, 2008 3:55 PM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >Subject: Re: Re-arranging fields > >Jerry Schwartz wrote: >> Is there any reasonable way of re-arran

SET vs. ENUM

Other than the fact that an ENUM can have many more values than a SET, is there any particular reason to choose one over the other? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

Re-arranging fields

Is there any reasonable way of re-arranging the order of columns in a table without losing their data? The best I could come up with was to copy the table, empty it, and then do an INSERT . SELECT specifying the new order of the fields. Regards, Jerry Schwartz The Infoshop by Global

RE: How do I (can I) use aggregate functions inside a select

>-Original Message- >From: David Ruggles [mailto:[EMAIL PROTECTED] >Sent: Friday, July 25, 2008 10:53 AM >To: 'mysql' >Subject: RE: How do I (can I) use aggregate functions inside a select > >I get: >Error Code : 1140 >Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns

RE: Log

>-Original Message- >From: Pedro [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 23, 2008 6:48 PM >To: Dan Nelson >Cc: mysql@lists.mysql.com >Subject: Re: Log > >I need to pass the user of my application pro bank. >I want to log the user's application and value of new fields or fields >upd

RE: Spaces in sourced file names?

Thanks, but I guess I wasn't clear. I meant the MySQL command line client. 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

Spaces in sourced file names?

In the CLI, is there any way to source a file whose name has whitespace in it (particularly spaces)? Regards, 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.

RE: counting by countrycode

How are you storing phone numbers? I don't think there are leading zeroes in country codes, and country codes are not all the same length. Are you padding them with leading zeroes to five characters? If you have padded them so that the first five characters are always the country code, then you ca

RE: Multi-Language Web Content

I guess I don't understand the issue. Do you want to display the text equivalent of the occupation code in the language associated with the person in the database, or in the putative language used by the web browser? >-Original Message- >From: Ben A. Hilleli [mailto:[EMAIL PROTECTED] >Sent

RE: Very large temporary file(s)

I know I shouldn't repost, but it's been a week since the last response and I still don't have a resolution to my problem. In a nutshell, a have an INSERT query that is taking up over 800mB of file space even though the tables involved aren't anywhere near that size. Regards,

RE: Queues on MySQL?

>-Original Message- >From: Waynn Lue [mailto:[EMAIL PROTECTED] >Sent: Tuesday, July 01, 2008 5:26 PM >To: Jerry Schwartz >Cc: MySQL List >Subject: Re: Queues on MySQL? > >>>Thanks for the suggestion--is that essentially using >>>http://www.php.net/p

RE: force row to appear at top of results using order by

>-Original Message- >From: Andrew Martin [mailto:[EMAIL PROTECTED] >Sent: Tuesday, July 01, 2008 9:20 AM >To: mysql@lists.mysql.com >Subject: force row to appear at top of results using order by > >Hello, > >I have an order by question... > >This is the "raw" data... > >mysql> SELECT events

RE: Queues on MySQL?

>-Original Message- >From: Waynn Lue [mailto:[EMAIL PROTECTED] >Sent: Monday, June 30, 2008 8:01 PM >To: Jerry Schwartz >Cc: MySQL List >Subject: Re: Queues on MySQL? > >Thanks for the suggestion--is that essentially using >http://www.php.net/posix_mkfifo wit

RE: Very large temporary file(s)

temporary space. >-Original Message- >From: Jerry Schwartz [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 25, 2008 9:54 AM >To: 'Ananda Kumar' >Cc: mysql@lists.mysql.com >Subject: RE: Very large temporary file(s) > >From: Ananda Kumar [mailto:[EMAIL PROTECTED]

RE: Queues on MySQL?

>-Original Message- >From: Waynn Lue [mailto:[EMAIL PROTECTED] >Sent: Monday, June 30, 2008 6:04 AM >To: MySQL List >Subject: Queues on MySQL? > >Hey, > >I'm looking to write a queue backed by MySQL to enable batch updates >of a system I'm writing. Essentially what I wanted to do was every

RE: convertion to utf-8

>-Original Message- >From: Pooly [mailto:[EMAIL PROTECTED] >Sent: Sunday, June 29, 2008 5:52 PM >To: mysql@lists.mysql.com >Subject: convertion to utf-8 > >Hi, > >I'm trying to convert my tables to UTF8 but I'm getting the following >error: >ERROR 1062 (23000): Duplicate entry 'Zorglüb' fo

RE: Very large temporary file(s)

From: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2008 10:55 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Very large temporary file(s) True, if you explicitly use group by and order by, there would a group operation after which sorting happens, but the

RE: Very large temporary file(s)

From: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2008 10:50 PM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Very large temporary file(s) In mysql, GROUP BY also by default does sorting using "ORDER BY", so you an avoid it by including "ORDER

Re: Very large temporary file(s)

IN stage ON customers.stage_id = stage.stage_id LEFT JOIN cust_topics ON customers.customer_id = cust_topics.customer_id GROUP BY customers.customer_id; Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.879

RE: Very large temporary file(s)

Double nuts! I corrected the wrong number. This time, I am reading my message more carefully. The temporary space used is indeed 800 MEGABYTES! I still need help, though. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

RE: Very large temporary file(s)

Nuts: not only did I write a huge message, but I made a booboo up at the top! I won't repost the whole thing. >I'm running MySQL 4.1.22-standard Community on CentOS. My problem is a >query >that is using about 800mb for what I assume is a temporary sort file, [JS] That should be 800Gb. -- MyS

Very large temporary file(s)

: ref possible_keys: topic_id key: topic_id key_len: 4 ref: giiexpr_customers.customers.customer_id rows: 4 Extra: = Here are the number of rows in each table: Rows in stage: 9 Rows in customers: 46764 Rows in account: 14 Rows in cust_topics: 94994

RE: Very slow inserts into InnoDB tables

Ian Simpson > >On Fri, 2008-06-13 at 10:40 -0400, Jerry Schwartz wrote: >> >Disk usage: the older server (the one that's running fine) is running >> >more transactions per second, but has lower blocks written and read >per >> >second than the new s

RE: Very slow inserts into InnoDB tables

>Disk usage: the older server (the one that's running fine) is running >more transactions per second, but has lower blocks written and read per >second than the new server: [JS] That, to me, suggests that the difference might be in the way the systems themselves are configured. Unfortunately, I do

RE: Fulltext index -first query slow, subsequent queries fast

>From: Rory McKinley [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 12, 2008 4:57 PM >To: Jerry Schwartz; mysql >Subject: Re: Fulltext index -first query slow, subsequent queries fast > >Jerry Schwartz wrote: >> File system, or disk caching, uses some kind of algorithm to

RE: Fulltext index -first query slow, subsequent queries fast

>-Original Message- >From: Rory McKinley [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 12, 2008 3:20 PM >To: mysql >Subject: Fulltext index -first query slow, subsequent queries fast > >Hi List > >I have a table with a fulltext index across five fields, with about 2.2 >million records and

RE: mysqld-nt Windows service: delay btwn svc running and accepting conx

>-Original Message- >From: Les Schaffer [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 04, 2008 9:23 PM >To: mysql@lists.mysql.com >Subject: mysqld-nt Windows service: delay btwn svc running and accepting >conx > >We are having a small technical glitch about which we would like to have >s

RE: Match/No Match query

>-Original Message- >From: Yong Lee [mailto:[EMAIL PROTECTED] >Sent: Wednesday, May 21, 2008 3:10 PM >To: 'Chris W'; 'Jerry Schwartz'; 'MYSQL General List' >Subject: RE: Match/No Match query > >chris, > >you're going to need

RE: Match/No Match query

>-Original Message- >From: Chris W [mailto:[EMAIL PROTECTED] >Sent: Wednesday, May 21, 2008 1:14 PM >To: Jerry Schwartz; MYSQL General List >Subject: Re: Match/No Match query > >Jerry Schwartz wrote: >>> From: Chris W [mailto:[EMAIL PROTECTED] >>>

RE: Match/No Match query

>From: Chris W [mailto:[EMAIL PROTECTED] >Sent: Wednesday, May 21, 2008 12:25 PM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >Subject: Re: Match/No Match query > >Jerry Schwartz wrote: >> I have a list of codes. Some, but not all, of these codes will match >the

Match/No Match query

s mostly a curiosity question. 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 -- MySQL General Mailing List For

RE: improving random record selection

>-Original Message- >From: Rob Wultsch [mailto:[EMAIL PROTECTED] >Sent: Monday, May 19, 2008 11:20 AM >To: Jerry Schwartz >Cc: Scott Haneda; mysql@lists.mysql.com >Subject: Re: improving random record selection > >On Mon, May 19, 2008 at 7:24 AM, Jerry Schwartz &g

RE: improving random record selection

>-Original Message- >From: Rob Wultsch [mailto:[EMAIL PROTECTED] >Sent: Saturday, May 17, 2008 6:47 PM >To: Scott Haneda >Cc: mysql@lists.mysql.com >Subject: Re: improving random record selection > >On Sat, May 17, 2008 at 2:32 PM, Scott Haneda <[EMAIL PROTECTED]> >wrote: >>

RE: improving random record selection

>From: Scott Haneda [mailto:[EMAIL PROTECTED] >Sent: Saturday, May 17, 2008 5:32 PM >To: mysql@lists.mysql.com >Subject: improving random record selection > >I posted this a month or so ago, and was helped a little, but I am now >back. > >Currently I use select x, y, z from images where (condition)

RE: Slave Server

>-Original Message- >From: Shanmugam, Dhandapani [mailto:[EMAIL PROTECTED] >Sent: Friday, May 16, 2008 4:01 AM >To: Phani; Ananda Kumar >Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com >Subject: RE: Slave Server > > >Ok..But if I do any changes on slave databases for testing it will >affect Ma

RE: Floor Decimal Math

en a problem at the hardware design level. The best way to handle this is to make sure all of your operators are type DECIMAL. You might have to cast them. Apparently MySQL 5+ introduced some algorithms that helped with these problems, although not with yours. Regards, Jerry Schwartz The

RE: comparison operations in IN subquery

>Hi guys, > > look at the following test case: > > mysql> create table temp1( id int)ENGINE=innodb; >Query OK, 0 rows affected (0.18 sec) > >mysql> create table temp2( tid varchar(10))ENGINE=innodb; >Query OK, 0 rows affected (0.07 sec) > >mysql> insert into temp1 values(1); >Query OK, 1 row affe

RE: how to escape new lines using select * into outfile

So far as I've been able to figure out, there's no form of escaping that will convince Excel to do what you want. The only thing I can think of is to replace * with a list of fields, and use MySQL functions to replace the \n with something else. Regards, Jerry Schwartz The Infoshop

RE: Help needed

address in the whole world. There are exceptions, but they would be mistakes. For your purposes, you can assume that it is a unique string of 32 hexadecimal digits. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

RE: latin1 vs UTF-8

I used not only the PHP functions but also the native MySQL HEX() function to see exactly what was going into my database. You can also set always_populate_raw_post_data = On in php.ini and examine $HTTP_RAW_POST_DATA to see exactly what the web server is seeing. Regards, Jerry Schwartz The

RE: Help needed

programming languages, although not in PHP. 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:

RE: latin1 vs UTF-8

Are you using mysqli, PDO, or mysql? There are differences in the way the character set is determined, as I discovered after much the same experience as yours. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

LEFT JOIN without temporary table?

pub_prod_id = prod.prod_pub_prod_id WHERE (prod.prod_discont = 0 OR prod.prod_discont IS NULL) ORDER BY prod_exists.prod_pub_prod_id; This works fine, but is there a better way to do it? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 0

RE: PHP Question

In general, if I have a PHP-generated page that produces a blank page, I execute the PHP code from the command line. It will probably fall over dead somewhere along the line, but you'll know if there are any syntax errors. Regards, Jerry Schwartz The Infoshop by Global Information Incorpo

RE: Problem with character set and connection collation

S for Windows Japanese | eucjpms_japanese_ci | 3 | +--+-+-++ 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: Problem with character set and connection collation

latin1 is CP-1252. I couldn't get that to work, either. I don't know how it would apply directly to your situation, but I think you are running into a similar kind of problem. I also can't guarantee that my conclusions were entirely correct. Perhaps someone else can add to this.

RE: Php-mssql connection problems on Windows XP

>-Original Message- >From: Jerry Schwartz [mailto:[EMAIL PROTECTED] >Sent: Thursday, April 24, 2008 10:01 AM >To: 'Padiyath Sreekumaran'; mysql@lists.mysql.com >Subject: RE: Php-mssql connection problems on Windows XP > >When using odbc_connect, you don&

RE: Php-mssql connection problems on Windows XP

river (*.mdb)}; DBQ=server\\access\\subtable_usa.mdb'); ... $db_access = odbc_connect(ODBC_CONNECT, "", "") or exit; The part between the braces is the same as what you would select when defining a DSN. Regards, Jerry Schwa

RE: Symlink InnoDB tables without stopping MySQL

t the effect of accessing a "stale" copy of the file will do. 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 >

Handling special characters

xe2\x80\x9c" => "\"", "\xe2\x80\x9d" => "\"" ); This is not a perfect solution for everyone, but it suits our needs. The data we work with comes in higgledy-piggledy, and we want it consistent whether someone sends

RE: data truncation warnings by special characters

>-Original Message- >From: C.R.Vegelin [mailto:[EMAIL PROTECTED] >Sent: Friday, April 18, 2008 8:42 AM >To: mysql@lists.mysql.com >Subject: data truncation warnings by special characters > >Hi List, > >I get strange "Data truncated for column Description" warnings >when loading a tab separa

RE: data truncation warnings by special characters

>-Original Message- >From: C.R.Vegelin [mailto:[EMAIL PROTECTED] >Sent: Friday, April 18, 2008 8:42 AM >To: mysql@lists.mysql.com >Subject: data truncation warnings by special characters > >Hi List, > >I get strange "Data truncated for column Description" warnings >when loading a tab separa

RE: \x96 in column value?

>-Original Message- >From: Tim McDaniel [mailto:[EMAIL PROTECTED] >Sent: Wednesday, April 16, 2008 2:32 PM >Cc: 'Mysql' >Subject: RE: \x96 in column value? > >On Wed, 16 Apr 2008, Jerry Schwartz <[EMAIL PROTECTED]> wrote: >> I'm running afou

RE: \x96 in column value?

ng it into a Windows-based editor preserves the character as 0x96. 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

\x96 in column value?

ile it looks like this: Disposable Paper Products - Uruguay You may not be able to see it, but that is actually an n-dash (\x96). 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: CHARACTER SET

The production system is running 4.1.22. Does it supports schemas? In any event, I'm not familiar with using 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-infosho

RE: CHARACTER SET

Bingo! You get a cookie. Thanks, I knew there had to be a way. 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

CHARACTER SET

When you create a table, you can specify a character set for a column. How can you tell what character set was used when the column was created? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

<    1   2   3   4   5   6   7   8   9   >