meone by their last name, the first 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:
>-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
has many experienced 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 Sc
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:
e been a SELECT 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
our vacation. The last thing you want to hear is "Richard, before you leave I
need you to..." (I have 45 years 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...@g
andard answer for "Why does it work that way?" is "I 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 sit
regardless of whether or not `x` is a key. Otherwise you have no way of
knowing who 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
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 Inf
ps,
every keystroke was precious.
Now I 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.
. The difference 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 F
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
--
MyS
>-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
t;statement works properly.
>>
>> Marc
>
>You should use UTC time zone or you will run into trouble with DST.
>
[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
them later :)
>
> -Bennett
>
[JS] 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 0
unicate with each other -- ever!
You will need those two people (or companies) forever if you ever want to
change 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
ve to analyze 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
te an error. Two examples are required fields (no
default value) or referential 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
>-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'
`,'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 Info
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
G
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, but it
>-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 be
>-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"
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
>-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 misse
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
he plug on this discussion. It doesn't 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
>-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
>-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 S
>-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 wrote:
>> I'm
al%Strategic SWOT Analysis Review'),
('21LADY Co., Ltd. (3346) - Financial and Strategic SWOT Analysis Review',
'21LADY Co%Ltd%(3346)%Financial%Strategic SWOT Analysis Review'),
==
... and so on for about 15000 rows.
Before I go through changing thi
>-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 tha
>-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&qu
>-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&q
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 publicati
and 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
`pub_id`),
KEY `prod_title` (`prod_title`),
FULLTEXT KEY `prod_title_fulltext` (`prod_title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
=
This works reasonably well for a small number (perhaps 200-300) of new
products; but now I've been handed a list of over 15000 to stuff into the
tab
ake some choices with 4, you can go
back and tinker 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
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
>-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 -
>-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)
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
Empties_or_zeros: 0
Nulls: 0
Avg_value_or_avg_length: 54.0701
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 Schw
>
[JS] Also some optimizers (and I don't know if MySQL is that clever) will
figure out which term is the cheapest to evaluate, and will change the order
of evaluation.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674
>-Original Message-
>From: ed [mailto:eth...@earthlink.net]
[JS]
>
>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
same 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
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:clau
1) AS x
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 [mai
s
HAVING
COUNT(*) > 1;
is what you want. You don't need to group on login_id. 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 Incorpor
nd have it export the data as tab delimited 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
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 wrote:
[JS] Actually
stly when it needs to make
sure that its local data cache 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.j
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.
Farmingto
S]
>
>the query 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,
d versions.
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, Feb
ur files, even if the volume images were not identical;
in fact, they almost certainly will NOT be identical 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
as
I know). I guess maybe I could do that with pass-through queries, but I'm not
sure.
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
>Donovan
>
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
>
>-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
>...
>
how to retrieve last_insert_id.
I should ask in the myodbc forum.
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
&
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...@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...
ert_id() in the argument list would
>likely 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 Farming
>-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.. Whi
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
across
the known universe, so should a UUID.
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 code should have bits for handling duplicate primarie
adds or subtracts 2
>from an int) then it looks 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
>-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 solutio
>-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 wr
#x27;10.%') or
tag_number LIKE ('10.05%')
and so forth. 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,
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, J
>-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
gt;My Mysql data dir is /hdd2-1/myisam_data/*
>
>Mysql is the owner and group of myisam_data folder.
>
>Can I know why it occurs and how to debug it.
>
[JS] I have a related question: how can MySQL authenticate a user if file
system permissions won't let it read any
>>
[JS] I don't understand how an index 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?
Regard
in advance,
>
[JS] I didn't see a key on `devid`. That's the only thing I can think of,
since putting 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:
-log file:
>
>Incorrect key feil 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 si
me.
>
[JS] Thanks.
By the way, 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.th
;
/home/me/testing/text.txt
By the way, it is a bad idea to use "test" as a file or directory name. It is
very easy to accidentally invoke the "test" command, which can really make you
scratch your head.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington
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
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
ough this again.
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]
&
>-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
>-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 l
3071 | 299522 |
+--+--++
4 rows in set (0.03 sec)
This does not work:
localhost >TRUNCATE t_dmu_history;
localhost >quit
C:\Users\Jerry\Documents\Access MySQL
Production>mysqlimport --columns=`dm_history_dm_id`,`dm_history_customer_id`
--fields-t
_Customer_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
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: m
gt;That will radically speed up the inserts.
>
[JS] I thought 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 indice
rganized in
>transaction blocks 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.
F
f how clumsy
the method 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.67
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
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 Farm
) VALUES (NULL);
ERROR 1364 (HY000): Field 'foo' doesn't have 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
W
;ll be okay from there (I hope).
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.
>-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/20
I don't think you can use anything but a constant 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 Sou
>-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 mo
code? That would 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
is there another way?
>
[JS] Sounds about right 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
>-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
>
&g
>-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
>
1 - 100 of 859 matches
Mail list logo