RE: How MyISAM handle auto_increment

-Original Message- From: Lucio Chiappetti [mailto:lu...@lambrate.inaf.it] Sent: Thursday, October 06, 2011 3:18 AM To: Jerry Schwartz Cc: Mysql List Subject: RE: How MyISAM handle auto_increment On Wed, 5 Oct 2011, Jerry Schwartz wrote: Can't you use CREATE TABLE LIKE

FW: MySQL Indexes

book (key f1/f2) is useless. If you want to find someone by their first name, the second book (f2/f1) is useless. Does that help explain it? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp

RE: Community Support better than Official Support? (was: Can I Develop using Community Edition and Deploy onto Enterprise Edition??)

users, some beta testers, and (because the product is used world-wide) a response time measured in hours. What it doesn't have is any presence from the company. As you can imagine, if not for the other users this program would be just a bad memory. Regards, Jerry Schwartz Global Information

RE: asking question

that wasn't valid. Prepared statements use a more complicated sequence. I hope that helps. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.giiresearch.com -Original Message

RE: asking question

, and PDO are on page http://www.php.net/manual/en/mysqli.overview.php. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.giiresearch.com -Original Message- From: valery

RE: table design question

of experience with that.) Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.giiresearch.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: locked non-existent row

wins. The ability to lock non-existent records is critical. Try it, you'll see. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.giiresearch.com -- MySQL General Mailing

RE: locked non-existent row

am not a mental health professional, nor do I play one on TV. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.giiresearch.com -- MySQL General Mailing List For list

RE: Hungarian Notation [Was Re: Too many aliases]

I was a reluctant convert, and still don't use Hungarian notation consistently; but in something like MS Access, where you might want to associate a label with a field, things like lblCompany and txtCompany make a lot of sense. Regards, Jerry Schwartz Global Information Incorporated 195

RE: Too many aliases

routinely pay the price of extra keystrokes for readability: not just with things such as column names, but with parentheses and the like as well. Like you, I only use aliases when necessary. If I want brain-teasers, I'll do a crossword puzzle. But that's just me. Regards, Jerry Schwartz Global

RE: How to Shuffle data

is that in an external program you can effectively renumber your rows as you remove them, so that it won't get harder and harder to find an actual row. Even then, a random shuffle is likely to be time-consuming. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

RE: Facebook Trapped In MySQL a 'Fate Worse Than Death'

Let this be a lesson to all of those designers who say That will never happen. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -- MySQL General Mailing

RE: SELECT records less than 15 minutes old

snip -Original Message- From: sono...@fannullone.us [mailto:sono...@fannullone.us] Sent: Monday, June 20, 2011 6:01 PM To: mysql@lists.mysql.com Cc: wha...@bfs.de; Jerry Schwartz Subject: Re: SELECT records less than 15 minutes old On Jun 20, 2011, at 10:11 AM, Jerry Schwartz wrote

RE: SELECT records less than 15 minutes old

. [JS] If you do that, you can't use an automatic timestamp field. You have to set the field yourself. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com

RE: Encoding Table Name and Filed Name

the application. There are books on this. You always have to trust somebody, and that somebody is always the weak link. Somebody must be using the application, and that someone is a bigger risk that your DB manager. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington

RE: optimization strategies based on file-level storage

] They will be too small, or the wrong type, or there won't be enough of them. Based upon 30+ years of database design, I'd bet money on it. ;-) Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site

RE: Data missing after field optimization

integrity. The goal is not to lose data, but to make sure your applications are doing what they are supposed to do. You would program your applications to trap and report errors. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

RE: Doubt regarding Mysqlsump

the data to find out what did and didn't happen before the crash, back out step 1, and re-run that transaction in the application. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site

Timestamp value

`,'my_local_time zone','their_local_time_zone`) Am I right? So, what if they do not know my local time zone? Is there a way to create a timestamp field that is always in UTC? I don't think there is, without using a trigger. Am I right about that? Regards, Jerry Schwartz Global Information Incorporated

RE: Timestamp value

-Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Monday, June 06, 2011 12:57 PM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Timestamp value I may be mistaken, but isn't UTC pretty much GMT if you don't want subsecond precision? Set your server's

RE: timezone

that statement is confusing – at least, it is to me. Unless you specify otherwise, NOW() returns the current system time in the system’s time zone. Your comment could be interpreted to mean that it doesn’t use any time zone: i.e., that it returns the UTC. Regards, Jerry Schwartz Global

Renaming a database?

think I have a database that isn’t being used (don’t ask), and I want to hide it to see if anything blows up. Suggestions? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: mailto:je

RE: Renaming a database?

-Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Tuesday, May 24, 2011 11:52 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Renaming a database? - Original Message - From: Jerry Schwartz je...@gii.co.jp It looks like there's no way

RE: Renaming a database?

-Original Message- From: Andrew Moore [mailto:eroomy...@gmail.com] Sent: Tuesday, May 24, 2011 11:31 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Renaming a database? Instead of renaming it, revoke permissions to it. If it's being used you should see some problems

RE: Renaming a database?

From: Andrew Moore [mailto:eroomy...@gmail.com] Sent: Tuesday, May 24, 2011 2:56 PM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Renaming a database? Could you try restoring the other db with another name and changing the connection string in the app? [JS] I could

RE: DBA Mentor?

Folks, I have no skin in this game whatsoever; but I thought the original question was reasonable (given that the person was new to the list), and I thought the first answer was rude. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796

RE: Join based upon LIKE

-Original Message- From: Nuno Tavares [mailto:nuno.tava...@dri.pt] Sent: Tuesday, May 03, 2011 6:21 PM To: mysql@lists.mysql.com Subject: Re: Join based upon LIKE Dear Jerry, I've been silently following this discussion because I've missed the original question. But from your last

RE: Join based upon LIKE

-Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Tuesday, May 03, 2011 5:31 AM To: Jerry Schwartz Cc: Jim McNeely; mysql mailing list; Johan De Meersman Subject: Re: Join based upon LIKE http://www.gedpage.com/soundex.html offers a simple explanation of what

RE: Join based upon LIKE

seem like there's a ready solution. Fortunately our database is small, and most feeds are only a few hundred products. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the

RE: Join based upon LIKE

-Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Sunday, May 01, 2011 4:01 AM To: Jerry Schwartz Cc: Jim McNeely; mysql mailing list Subject: Re: Join based upon LIKE - Original Message - From: Jerry Schwartz je...@gii.co.jp I shove those modified

RE: Join based upon LIKE

-Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Friday, April 29, 2011 5:56 AM To: Jerry Schwartz Cc: mysql mailing list Subject: Re: Join based upon LIKE - Original Message - From: Jerry Schwartz je...@gii.co.jp [JS] This isn't the only place I

RE: Join based upon LIKE

-Original Message- From: Jim McNeely [mailto:j...@newcenturydata.com] Sent: Thursday, April 28, 2011 6:43 PM To: Jerry Schwartz Subject: Re: Join based upon LIKE It just smells wrong, a nicer system would have you joining on ID's of some kind so that spelling wouldn't matter. I don't know

ERROR 2006 (HY000)

to fix the problem the right way. I looked at all of the system variables, and none of them seemed to apply. I probably missed something obvious. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je

RE: ERROR 2006 (HY000)

-Original Message- From: Larry Martell [mailto:larry.mart...@gmail.com] Sent: Friday, April 29, 2011 5:31 PM To: Jerry Schwartz Cc: mysql mailing list Subject: Re: ERROR 2006 (HY000) On Fri, Apr 29, 2011 at 3:23 PM, Jerry Schwartz je...@gii.co.jp wrote: I'm getting ERROR 2006 (HY000

FW: Join based upon LIKE

No takers? -Original Message- From: Jerry Schwartz [mailto:je...@gii.co.jp] Sent: Monday, April 25, 2011 2:34 PM To: 'Mailing-List mysql' Subject: Join based upon LIKE I have to match lists of new publications against our database, so that I can replace the existing publications in our

RE: Join based upon LIKE

-Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Thursday, April 28, 2011 4:18 PM To: Jerry Schwartz Cc: mysql mailing list Subject: Re: Join based upon LIKE - Original Message - From: Jerry Schwartz je...@gii.co.jp No takers? Not willingly, no :-p

RE: Error in accept: Too many open files

per process. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Brent Clark [mailto:brentgclarkl...@gmail.com] Sent: Tuesday

RE: mysql deal with specail character problem

From: 赵琦 [mailto:tyzha...@gmail.com] Sent: Thursday, April 21, 2011 9:19 PM To: Jerry Schwartz Cc: Johan De Meersman; sstap...@mnsi.net; mysql Subject: Re: mysql deal with specail character problem thanks for reply! The charater set is latin1,and the key field is mangled by the email

RE: Memory Usage.

with 3. As any performance consultant worth his salt will tell you, It depends. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -- MySQL General

Join based upon LIKE

-300) of new products; but now I've been handed a list of over 15000 to stuff into the table `new_titles`! This motivates me to wonder if there is a better way, since I expect this to take a very long time. Suggestions? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave

RE: mysql deal with specail character problem

-Original Message- From: ?? [mailto:tyzha...@gmail.com] Sent: Thursday, April 21, 2011 7:09 AM To: mysql Subject: mysql deal with specail character problem Hi: I have a table that the field a is primary key; I insert a record like this insert into table(a,b,c) values('?',1,1) Then i

RE: mysql deal with specail character problem

-Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Thursday, April 21, 2011 9:56 AM To: sstap...@mnsi.net Cc: ??; mysql; Jerry Schwartz Subject: Re: mysql deal with specail character problem - Original Message - From: Steve Staples sstap...@mnsi.net

RE: efficient use of varchar?

Std: NULL Optimal_fieldtype: TINYTEXT NOT NULL 1 row in set (0.23 sec) == Aside from Max_value, which I'll wonder about later, why is the Optimal_fieldtype TINYTEXT? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

RE: efficient use of varchar?

By the way, the weird-looking title is in Japanese (the database/table/field are UTF-8). Some of you might be able to read that. Is it possible that this is upsetting the ANALYSE procedure? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave

RE: IF

. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: best practice: mysql_multi, VMs w/single instance per or doesn't matter?

time you want to make sure that your development isn't accidentally playing with the live data. Since I'm running a *AMP application, I can just use localhost and not worry about forgetting to change the database name references. Regards, Jerry Schwartz Global Information Incorporated 195

RE: how to RE-add innoDB storage?

-Original Message- From: ed [mailto:eth...@earthlink.net] [JS] snip I guess wordwrap is going to mess this up; mysql show engines ; [JS] Next time, try SHOW ENGINES\G Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796

RE: Get MySQL server IP address in SQL

Do you have to worry about named pipes? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Claudio Nanni [mailto:claudio.na

RE: Query help

. And, as Claudio said, SELECT ip_address, GROUP_CONCAT(login_id, ', ') AS list_of_login_ids will give you the IP addresses as well. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site

RE: Query help

ON basic_table.ip_address = x.ip_address; Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Tompkins Neil [mailto:neil.tompk

RE: How to export data with column names?

but with the column names. I need the column names because the import utility will use that to create the table in another (non-MySQL) database. [JS] mysql -hxxx -uyyy -pzzz -e select * from table1 myfile.txt Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

RE: Replacing MS SQL with MySql

You should probably take this over to the MyODBC list. I suggest that you get the Bullzip programs and look at what they do by way of transferring the database structure. You'll learn a lot from that. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT

RE: Replacing MS SQL with MySql

is synchronized with the MySQL database. That's where I'm having trouble. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com On Wed, Feb 9, 2011 at 6:36 AM, Y z yan

RE: Replacing MS SQL with MySql

From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Wednesday, February 09, 2011 1:10 PM To: Jerry Schwartz Cc: Y z; mysql@lists.mysql.com Subject: Re: Replacing MS SQL with MySql On Wed, Feb 9, 2011 at 7:02 PM, Jerry Schwartz je...@gii.co.jp wrote

RE: How do increase memory allocated to MySQL?

was just SELECT * FROM wasfoundin WHERE yakoright LIKE '%geography%' [JS] I think it is the leading % that is causing the problem. I don't have a ready solution. Perhaps a full-text index would help, but I'm not sure. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave

RE: map polygon data for popular us cities

. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Geert-Jan Brits [mailto:gbr...@gmail.com] Sent: Thursday, February 03, 2011 3:44 AM

RE: InnoDB and rsync

at the disk-image level. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy

RE: CURRENT insert ID

I'll have to investigate how to do a transaction from Access. I guess pass-through queries might do it, but I'm not sure. -Original Message- From: Carsten Pedersen [mailto:cars...@bitbybit.dk] Sent: Sunday, January 23, 2011 9:36 AM To: Jerry Schwartz Cc: 'mysql.' Subject: Re: CURRENT

RE: CURRENT insert ID

, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com Donovan -- D Brooke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: best way to have a unique key

: as Pratchett put it, one-in-a-million chances tend to pop up nine times out of ten. [JS] A UUID (what Microsoft calls a GUID) is based in part on the MAC address of the generating device. Since MAC addresses are supposed to be unique across the known universe, so should a UUID. Regards, Jerry Schwartz

CURRENT insert ID

description of the problem: CREATE TABLE t ( id INT(11) AUTO-INCREMENT PRIMARY, xxx INT(11) ); When a record is added to table `t`, I need to set `xxx` to the value generated for `id`. (`xxx` might be changed later.) Is there anything clever I can do? Regards, Jerry Schwartz Global

RE: best way to have a unique key

-Original Message- From: Michael Dykman [mailto:mdyk...@gmail.com] Sent: Friday, January 21, 2011 11:35 AM To: Johan De Meersman Cc: Anthony Pace; mysql. Subject: Re: best way to have a unique key One of the components of the UUID is drawn form the mac address of the server.. While in

RE: CURRENT insert ID

yield you the previous value (which might not even related to your table. Having siad that.. odd requirement. [JS] You don't know the half of it. Thanks. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail

RE: CURRENT insert ID

-Original Message- From: Jerry Schwartz [mailto:je...@gii.co.jp] Sent: Friday, January 21, 2011 11:56 AM To: 'Michael Dykman'; 'MySql' Subject: RE: CURRENT insert ID -Original Message- From: Michael Dykman [mailto:mdyk...@gmail.com] Sent: Friday, January 21, 2011 11:50 AM

RE: CURRENT insert ID

I made a typo in my previous message. -Original Message- From: Jerry Schwartz [mailto:je...@gii.co.jp] Sent: Friday, January 21, 2011 12:20 PM To: 'Jerry Schwartz'; 'Michael Dykman'; 'MySql' Subject: RE: CURRENT insert ID -Original Message- From: Jerry Schwartz [mailto:je

RE: CURRENT insert ID

, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -- João Cândido de Souza Neto Darryle Steplight dstepli...@gmail.com escreveu na mensagem news:AANLkTim+fjYUoU

RE: CURRENT insert ID

-Original Message- From: Michael Dykman [mailto:mdyk...@gmail.com] Sent: Friday, January 21, 2011 1:27 PM To: Jerry Schwartz Cc: MySql Subject: Re: CURRENT insert ID You don't need to do an update: ... new.xxx = new.id ... [JS] I wish it were that easy. new.id is null until after

RE: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

. This scheme is infinitely extendable. To get the entire hierarchy, you simply SELECT tag_number, tag_name FROM tags ORDER BY tag_number; Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site

RE: Can't read dir of '.' (errno: 13)

-Original Message- From: Joerg Bruehe [mailto:joerg.bru...@oracle.com] Sent: Thursday, January 20, 2011 6:54 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Can't read dir of '.' (errno: 13) Hi! Jerry Schwartz wrote: [[...]] [[...]] [JS] Sorry, that still doesn't make

RE: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

-Original Message- From: Dotan Cohen [mailto:dotanco...@gmail.com] Sent: Thursday, January 20, 2011 11:25 AM To: Jerry Schwartz Cc: mysql.; php-general. Subject: Re: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist As for setting up

RE: [PHP] RE: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

to be a pain to add nodes. [JS] Not at all. Somebody, somehow, has to assign a name to the tag and designate its place in the hierarchy. I don't see how you can avoid that being done by a human. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

RE: Can't read dir of '.' (errno: 13)

authenticate a user if file system permissions won't let it read any databases? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com Thanks Regards Adarsh

RE: Can't read dir of '.' (errno: 13)

-Original Message- From: Joerg Bruehe [mailto:joerg.bru...@oracle.com] Sent: Wednesday, January 19, 2011 10:43 AM To: mysql@lists.mysql.com Cc: Jerry Schwartz Subject: Re: Can't read dir of '.' (errno: 13) Hi! Jerry Schwartz wrote: -[[...]] [JS] I have a related question: how can

RE: Can't read dir of '.' (errno: 13)

Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Joerg Bruehe [mailto:joerg.bru...@oracle.com] Sent: Wednesday, January 19

RE: Rewrite SQL to stop table scan

on a timestamp would help. Theoretically, each record could have a unique value for the timestamp; so the index would have an entry for each record. Would MySQL really use that in preference to, or in combination with, an index on devid? Regards, Jerry Schwartz Global Information Incorporated 195

RE: Incorrect key file for table

for table '/tmp/#sql_5f8_0.MYI'; try to repair it It seem rather meaningless to try to repair a temporary table... So is this a bug in MySQL, or? [JS] Check for space in /tmp. I've seen temporary files that are 10x the size of the actual table(s). Regards, Jerry Schwartz Global Information

RE: Rewrite SQL to stop table scan

a key on `stamp` doesn't make sense. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com Bruce P.S. I've tried it this way: select count(*) as count from

RE: export result from select statement

to accidentally invoke the test command, which can really make you scratch your head. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com Jerry Schwartz wrote

RE: export result from select statement

, if your SELECT is easy to type you can use the -e parameter on the MySQL command line. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com - michael dykman

RE: export result from select statement

The technique I've settled on is this: mysql blah blah blah the_select_query.sql the_output_i_want.txt That gives you a tab-delimited text file with column headings. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

RE: This just seems to slow

I did wind up using LOAD DATA INFILE. When I started, I was afraid that I was going to process about 20 tables every day; but I redid the data exchange to avoid that. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

RE: This just seems to slow

of many lines and it will speed up data insertion. [bian...@mysql.com]# mysqldump -u root -p --all-databases -e file.dump [JS] If only I were using mysqldump :-(. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E

RE: This just seems to slow

of that, but unfortunately this is just one of 25-odd tables (each in a different format, of course). Also delete your INDEX / KEYs and add them at the very end instead. [JS] Wouldn't it take as long to build the indices? I guess it probably wouldn't. Regards, Jerry Schwartz Global Information Incorporated 195

RE: This just seems to slow

Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: mos [mailto:mo...@fastmail.fm] Sent: Sunday, January 02, 2011 11:42 PM To: mysql

mysqlimport doesn't work for me

| +--+--++ 4 rows in set (0.03 sec) This does not work: localhost TRUNCATE t_dmu_history; localhost quit C:\Users\Jerry\Documents\Access MySQL Productionmysqlimport --columns=`dm_history_dm_id`,`dm_history_customer_id` --fields-terminated=',' --local --password=xxx

RE: This just seems to slow

-Original Message- From: Gavin Towey [mailto:gto...@ffn.com] Sent: Monday, January 03, 2011 1:47 PM To: Jerry Schwartz; 'mos'; mysql@lists.mysql.com Subject: RE: This just seems to slow I much prefer LOAD DATA INFILE to mysqlimport. The issue looks like you have a file with two columns

RE: mysqlimport doesn't work for me

-Original Message- From: Carsten Pedersen [mailto:cars...@bitbybit.dk] Sent: Monday, January 03, 2011 1:48 PM To: Jerry Schwartz Cc: 'mos'; mysql@lists.mysql.com Subject: Re: mysqlimport doesn't work for me It's been a long time sine I used mysqlimport, but you might want to try: - using

RE: This just seems to slow

. Thanks for your help. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: mos [mailto:mo...@fastmail.fm] Sent: Monday, January 03

This just seems to slow

was. Is that autocommit a problem? This is a bulk load into an empty table, so I'm not worried about ACID. Any suggestions? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the

RE: Trigger?

a default value So I'm missing something important. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Michael Dykman [mailto:mdyk

RE: Trigger?

was triggered. Contrariwise, I assume that an “AFTER” trigger would be executed last, after everything has been done. Am I correct? By the way, SET NEW.foo = IFNULL(NEW.foo, 'ok') works just fine. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave

Corrupted TRG file?

almost jumped out of my skin. Then I typed in SHOW CREATE TRIGGER TC_Products_Date_Trigger; and that worked just fine. I didn’t find any bug reports that seemed relevant, but I can’t believe I’m first one to stumble on this. Regards, Jerry Schwartz Global Information Incorporated

Trigger?

). Thanks. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: Access to MySQL

-Original Message- From: Jesper Wisborg Krogh [mailto:my...@wisborg.dk] Sent: Friday, December 17, 2010 6:07 AM To: Jerry Schwartz Cc: 'MySQL' Subject: Re: Access to MySQL On 17/12/2010, at 9:02 AM, Jerry Schwartz wrote: I have to move the back-end of an Access application to MySQL

RE: Access to MySQL

as a default value. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -- João Cândido de Souza Neto Jerry Schwartz je...@gii.co.jp escreveu na mensagem news

RE: Access to MySQL

-Original Message- From: Shawn Green (MySQL) [mailto:shawn.l.gr...@oracle.com] Sent: Friday, December 17, 2010 10:35 AM To: Jerry Schwartz Cc: j...@consultorweb.cnt.br; mysql@lists.mysql.com Subject: Re: Access to MySQL Hi Jerry, On 12/17/2010 09:34, Jerry Schwartz wrote: -Original

Access to MySQL

be a significant PITA. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: mailto:je...@gii.co.jp je...@gii.co.jp Web site: http://www.the-infoshop.com/ www.the-infoshop.com

RE: Design: how to prioritise 1-to-many fields

to me, but don't use a sequence like 1, 2, 3. Use 10, 20, 30. You never know when you'll have to squeeze in a new priority level, and you don't want to have to renumber them all. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

RE: localhost vs domain for connection string

-Original Message- From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Thursday, November 25, 2010 3:29 AM To: Jerry Schwartz Cc: Brent Clark; mysql mailing list Subject: Re: localhost vs domain for connection string On Wed, Nov 24, 2010 at 4:44 PM

RE: localhost vs domain for connection string

-Original Message- From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Wednesday, November 24, 2010 2:39 AM To: Jerry Schwartz Cc: Brent Clark; mysql mailing list Subject: Re: localhost vs domain for connection string On Tue, Nov 23, 2010 at 7:55 PM

  1   2   3   4   5   6   7   8   9   >