-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
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
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
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
, 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
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
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
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
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
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
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
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
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
.
[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
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
] 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
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
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
`,'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
-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
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
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
-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
-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
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
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
-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
-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
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
-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
-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
-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
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
-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
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
-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
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
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
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
-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
-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
-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
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
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
.
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
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
-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
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
. 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
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
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
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
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
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
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
.
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
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
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
,
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
: 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
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
-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
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
-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
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
,
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
-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
. 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
-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
-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
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
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
-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
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
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
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
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
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
, 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
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
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
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
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
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
|
+--+--++
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
-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
-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
.
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
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
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
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
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
).
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
-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
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
-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
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
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
-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
-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 - 100 of 846 matches
Mail list logo