Is there any way to find a column name (or, better yet, a partial column
name) in all tables within a data base?
I inherited a complex and totally undocumented data base, and need to find
out (for example) which tables have a column name like xxx_exported.
Regards,
Jerry Schwartz
Global
irst table is named ORDER,
and I thought there was something wrong with my plan.
Thanks.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: George Law [mailto:[EMAIL PROTECTED]
Sent: Tu
I haven't ventured into MySQL 5.x, I have enough trouble working with this
house of cards I was handed. I'll try to remember this for the future,
though.
Thanks to all.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.
thing?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Actually, by default a full text search ignores words that are three
characters or less, not less than three characters.
I found this out by searching on "red".
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 86
More than likely, the OS file system is caching the files that make up the
tables.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Ratheesh K J [mailto:[EMAIL PROTECTED]
Sent
en-source spell checkers
(http://www.thefreecountry.com/sourcecode/spellcheckers.shtml, et al). I
don't know what language you are using, so I can't go further than that.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674
You might come close by using a combination of tee, select, and notee
commands. You didn't say if this was for debugging, which would tolerate a
lot of ugly, or not.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674
Yeah, my customer wasn't too pleased when his product search could only find
certain colors. ;<)
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Chris [mailto:[EMAIL P
= mysql_fetch_row($result); /* DELETE THIS ROW */
while ($row=mysql_fetch_row($result)){
By the way, I think I read that using WHERE is more efficient than HAVE.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
The only reason that I can think of is to balance the load among systems.
This might be because you want to split the load between the data base
server and the application, or because you want to run the application on
more than one server.
Regards,
Jerry Schwartz
Global Information Incorporated
at some of the farm-land areas cover a lot of territory with
very few zip codes.
I don't know how the mapping software does it, really. They must have big
tables of some sort.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FA
Automatically? Don't know. I did it by hand using Dia, a free alternative to
MS Visio. It was tedious.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: news [mailto:[
I don't see the form.
Unless one of your included files sets the values of your variables, this
code will insert a row of empty strings every time it executes.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674
their loops with "< x + 1"
rather than "= x". That gets past the problem, but if you are adding
together many values the final answer may be wrong.
Look at 23.1 of the manual.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington,
oblem for any reasonable amount, but now you're
back to the rounding issue caused by the fact that .01 is not exactly
representable as a binary fraction.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
---
quot;. I do not know
how that would work for characters that have no Latin equivalent.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Charlie Schaubmair [mailto:[EMAIL PRO
as one of the silent conversions - varchar(256) would be
converted to text, but not varchar(255). What's going on?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
You are absolutely right. The entire data base is UTF-8.
That explains why the examples I found were not in English.
Thanks.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From
FULLTEXT can only be used with ISAM tables.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Lakshmi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 12, 2006 3:29 AM
To: mysql
I am receiving some messages an extra time, also. It seems that something is
wrong with the list server.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Nico Sabbi [mailto:[EMAIL
Overnight (Monday night US time) I was receiving some duplicate messages
(not ones addressed to me specifically). Has this been fixed?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
I'm not sure I understand where the other field data (that you say you have
to enter manually) is coming from, but what I often do when confronted with
data that needs to be massaged before entry is put it in an Excel
spreadsheet and use a formula to build the MySQL statements.
Regards,
This may be the blind leading the one-eyed, but wouldn't
SELECT FieldID FROM TableA, TableB WHERE TableA.FieldID = TableB.FieldID AND
TableA.Enabled != TableB.Enabled;
Work?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796
I don't think you can do this with mysqlimport. It wouldn't be hard to do
with Perl or PHP, though, and that could be automated any way you want with
a shell script.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.
t have matching records in tableb.
Unless I'm mistaken....
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
>André Hänsel skrev:
>>Hello list,
>>I have two tables:
>>Table A
>>a_id n
Have you tried using parentheses around your last line?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: molemenacer [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 21, 2006
all writes to the data bases. The reads were distributed simply by having
the clients open different copies of the data base.
Ugly, but it works.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original
Have you dumped out your variables to make sure none of them is a
zero-length string? That would surely cause your problem.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Ed
Your first query returns a scalar (single value), right? You can put its
value into a variable, and use that in the second query. It's not exactly
what you wanted, but it will work without external programming.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmingto
s, and can
then export to a tab-separated file.
Ugly, but as I said my data comes in all kinds of nasty formats, such as web
pages.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
&
The default engine is configurable: default-storage-engine=INNODB in my.ini.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
We have multiple Western languages in our UTF-8 data base, without a
problem. Right now I'm working on adding Chinese data, but my major problem
is reading back what's in there to find out if it went in correctly :<(
Regards,
Jerry Schwartz
Global Information Incorporated
195 F
cords with the MySQL client.
Now I'm chasing that hare.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Michael Monaghan [mailto:[EMAIL PROTECTED]
> Sent: Thursda
of inserts / updates / deletes, and
not about retrievals, then don't index anything. A SELECT will have to
serially access the table, while a write will have to shuffle the indices.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 /
I'm a newbie, for sure, but can't you use OR to accomplish this?
SELECT * FROM release_hack WHERE BID IN (5749, 7355, 6454)
OR oBID IN (5749, 7355, 6454);
Could it be as simple as I am?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington
tself in the topic_index table and quickly
pull all of the corresponding records for the different languages from
topic_detail. You can also easily find all topics that have entries in a
particular language, or that do not have entries in a particular language,
etc.
Regards,
Jerry Schwartz
G
It probably uses a single lock to handle a JOIN, and two locks to handle a
sub-SELECT. I doubt that it helps, but if I'm right it will change what you
see when you poking around.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796
Based on my experience, that wouldn't quite work. You'd need to preface each
word with a plus sign:
+olive +oil*
and it would return records regardless of the order in which the two words
appear, nor how far apart they are. That might be desirable, or it might
not.
Regards,
Jerr
query
gave me the inverse of what I wanted. This shouldn't be impossible to do,
Access has a "find duplicates" wizard; but come to think of it, that lists
both records and I never tried to limit it to just the older.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmin
e the data.
Thanks for your help.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Brent Baisley [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 12, 2006 2:14 PM
&
You might want to check for an empty string ("") rather than null. From what
I can tell, HTML forms don't give you NULL values if you leave fields empty,
they return "". Unless your programs internally convert empty strings to
NULL, you won't find NULL in your ta
.
I can't speak for OpenOffice.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Ferindo Middleton [mailto:[EMAIL PROTECTED]
> Sent: Saturday, October 14, 200
This may be too obvious, but what is in that text field?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Ted Johnson [mailto:[EMAIL PROTECTED]
> Sent: Monday, O
I wonder if this is a permissions problem.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: mdpeters [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 16, 2006 9:1
I would think that with so few possible values for all but the ip field,
indexing the other fields would accomplish nothing. In fact, I'd be
surprised if the optimizer didn't realize that and do a sequential read
anyways.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farm
I didn't think of that (combinations). You are probably right. Due to my
background, I tend not to think a lot about multi-column indices.
I would think that you want field with the most possible values first, then
the next, etc. Is that what you were thinking?
Regards,
Jerry Schwartz
G
That's what Dan (and I) meant.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: William R. Mussatto [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 17, 200
open data base!\n");
This might be in the including script, if any, since the error message shows
a suggestively-named file name.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message---
d. Alternatively, you can
insert the USE statement into your spreadsheet (adjusting the row numbers
accordingly) or directly into your text file, and redirect the input file
for mysql on the command line.
Once you get the hang of it, this is all simpler than it sounds.
Regards,
Jerry Schwartz
d any text
values with an extra pair of single quotes:
"... SET col1 = '", 'Sheet1'!A1, "', ...")
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Origin
Can't you just keep track of which page you are on, and multiply by 20
(except for the last page)? I must be missing something.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message
I'm still confused, are you saying that you want to know what page a team
would be on if you did a listing?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: n
ng it
until it was shut down.
"UNIX don't care..."
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Dan Buettner [mailto:[EMAIL PROTECTED]
> Sent: Wednes
How about the UUID() function. As I recall, the differences between a UUID
and Microsoft's GUID are trivial.
INSERT INTO Inv_Id SET id = UUID();
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -
I don't now your application at all. That being said, if you are running a
single-threaded application I don't see how MySQL could have more than one
thread running on one CPU.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.
Is "9640" a word by itself? A full-text search wouldn't find "abc9640",
you'd need to use LIKE for that.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Messag
Is a sub-select more efficient than an outer join?
SELECT cust_id FROM customers LEFT JOIN orders on customers.cust_id =
orders.cust_id WHERE orders.cust_id IS NULL;
Or am I missing something (as usual)?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington
ng data is, and how
picky you are about the results.
You can probably do what you want with a combination of REGEXP, IF,
SUBSTRING, and CONCAT; but it would take more time than I have to work it
out.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington
cimal arithmetic, on the other hand, requires more data
manipulations. The size of the column probably is outweighed by the more
complex data handling.
No doubt someone whose internals experience is more recent than mine will
chime in.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmi
than with integer types.
Sorry, that's about as far as I can guess.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>
Most likely the UTF8 is still in the data base, but whatever program you are
using to view it is not displaying UTF8 properly. MySQL's command line
program will not, for example, even if you SET NAMES "utf8".
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington
s I see it, is that the engine already believes the data is UTF8 so it
might not work.
SELECT COUNT(*) FROM table1 WHERE CONVERT(field1 USING utf8) != field1;
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
>
I inherited a system in which the code was writing the string "NULL" into a
CHAR field. It took me a long time to figure out what MySQL CLI was showing
me.
These kids today...
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.
Y clause
I had a feeling that I couldn't just use id in the outer select, but how do
I get it? I tried adding GROUP BY t.prod_id, but that just gave me the same
error.
Please help me find my way.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 0603
ly) the records whose count
is the maximum. It seems tantalizingly out of reach. I know what MySQL is
telling me (I can use MAX without a GROUP only if I don't use other columns
that aren't functions), but not how to fix it.
Regards,
Jerry Schwartz
Global Information Incorporated
195 F
I have a table with a memo field, and I want to build a table of all words
used in all rows of that memo field.
Suggestions?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the
ng Windows version 5.0.45-community-nt and it did not come with cp1252
(at least by that name).
I get a lot of data that has "special" cp1252 characters in it (used in MS
Word, typically) and they drive me crazy nine ways from Sunday.
Regards,
Jerry Schwartz
The Infoshop by Global Info
>-Original Message-
>From: spacemarc [mailto:[EMAIL PROTECTED]
>Sent: Friday, December 05, 2008 8:50 AM
>To: MySQL
>Subject: SELECT with replacement chars
>
>Hi
>how can i replace, in a SELECT query, the last 3 numbers with asterisks?
>from 0123456789 to 0123456***
>
[JS]
SELECT CONCAT(LE
() < .1) ORDER BY score
DESC;
That should give you a random sample of approximately 10% of your original
table, in descending order by score.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
les in which a particular person_id is
found.
I don't know if this suits your needs.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www
>-Original Message-
>From: Andy Shellam [mailto:andy-li...@networkmail.eu]
>Sent: Wednesday, December 17, 2008 3:29 PM
>To: Lamp Lists
>Cc: mysql@lists.mysql.com
>Subject: Re: need help with query...
>
>Hi Afan
>
>Why not prefix your field names with the table name?
>
>select
> p.first_nam
>-Original Message-
>From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On
>Behalf Of Vikram Vaswani
>Sent: Thursday, December 25, 2008 5:47 AM
>To: mysql@lists.mysql.com
>Subject: Question on default database for stored functions
>
>Hi
>
>According to the MySQL manual, "By
I'm late to the game, but many Windows installers run the actual installer
for required applications. Have your application's installer run the normal
installation package for MySQL.
That's all I can give you, my knowledge of installers is too old to be of
real use.
Regards,
Jer
//www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-
9B72-EF94E038C891&displaylang=en#Instructions
If that is true (that it doesn't require Access to be installed), you can
write a simple program to read the .accdb file and write it out as anything
you want.
Regards,
r to
Calc spreadsheets, and save them as CVS files.
Opening an Access database in Base is a little confusing, you have to
"connect" to it rather than open it directly, but you don't need any ODBC or
JDBC at all.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorp
>-Original Message-
>From: Johnny Withers [mailto:joh...@pixelated.net]
>Sent: Wednesday, December 31, 2008 1:13 PM
>To: MySQL General List
>Subject: Compare DATETIME to DATE
>
>Hi,
>I don't quite understand (or even know) what the "proper" way to compare
>a
>DATETIME column to a given DA
>-Original Message-
>From: Lola J. Lee Beno [mailto:l...@his.com]
>Sent: Thursday, January 01, 2009 5:08 PM
>To: 'MySQL'
>Subject: How to Use Cascade Delete Properly
>
>I'm trying to understand how to use cascade delete properly but not sure
>if I have this backwards or not. Here's an ex
>-Original Message-
>From: c...@l-i-e.com [mailto:c...@l-i-e.com]
>Sent: Tuesday, January 06, 2009 9:47 AM
>To: mysql@lists.mysql.com
>Subject: RE: how to design book db
>
>
>Just theories here:
>
>
>
>The same book re-issued by another publisher might have a different
>ISBN.
>
>
>
>A book
"GROUP BY account, customer LIMIT 20", I'll get the first 20
customers for the first account. If I try "GROUP BY account, customer ORDER
BY SUM(sale_amount) DESC LIMIT 20", I'll get the top 20 customers.
What am I missing?
Regards,
Jerry Schwartz
The Infoshop
>-Original Message-
>From: freedc@gmail.com [mailto:freedc@gmail.com] On Behalf Of
>Phil
>Sent: Tuesday, January 06, 2009 3:41 PM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Limit within groups
>
>How about something like
>
>
>-Original Message-
>From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
>Behalf Of Baron Schwartz
>Sent: Wednesday, January 07, 2009 9:54 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Limit within groups
>
>On Tue, Jan 6, 2009
>-Original Message-
>From: Claudio Nanni [mailto:claudio.na...@gmail.com]
>Sent: Wednesday, January 14, 2009 4:50 AM
>To: Brent Clark
>Cc: mysql@lists.mysql.com
>Subject: Re: Unused and empty tables -> what impact on mysql
>
>Empty files, like empty tables is not synonym for useless or un
>-Original Message-
>From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On
>Behalf Of Vikram Vaswani
>Sent: Monday, January 26, 2009 7:02 AM
>To: mysql@lists.mysql.com
>Subject: Help with formatting of 1:n relationship
>
>Hello all
>
>I have a database with a 1:n relationshi
>-Original Message-
>From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On
>Behalf Of Vikram Vaswani
>Sent: Monday, January 26, 2009 11:29 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Help with formatting of 1:n relationship
>
>
>IMO, offering a variety of input formats just creates one big mess.
>How often have you read some date notation and wondered which format was
>used - if all values are in the 1 to 12 range, you have to guess.
>
[JS] I agree 100%. I have to deal with dates from all over the world, and I
often have
Why use a cannon on a gnat?
Your data is already in an Excel spreadsheet, so why not use Excel to do
this?
=ISODD(LEFT(A1,SEARCH(" ",A1)-1))
Will be true if the street number is odd; then you can just filter on that
column to select the "TRUE" rows, and copy them to wherever you need them.
>---
_type: SIMPLE
table: prod
type: ref
possible_keys: pub_id
key: pub_id
key_len: 46
ref: giiexpr_db.pub.pub_id
rows: 112
Extra: Using where
2 rows in set (0.06 sec)
Are the results the same because my query is too simple?
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Tuesday, February 03, 2009 1:03 PM
To: Jerry Schwartz; mysql@lists.mysql.com
Subject: RE: WHERE vs. ON
ON condition uses the same columnname from both source and target tables
whereas any column expressions can go in the WHERE
>-Original Message-
>From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
>Behalf Of Baron Schwartz
>Sent: Wednesday, February 04, 2009 10:03 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: WHERE vs. ON
>
>On Tue, Feb 3, 2009
>-Original Message-
>From: John Daisley [mailto:john.dais...@mypostoffice.co.uk]
>Sent: Wednesday, February 04, 2009 10:41 AM
>To: mysql@lists.mysql.com
>Cc: Jerry Schwartz
>Subject: Re: WHERE vs. ON
>
>Never tried it in MySQL and Im not
>in a position to d
>-Original Message-
>From: Yariv Omer [mailto:yar...@jungo.com]
>Sent: Wednesday, February 04, 2009 10:50 AM
>To: mysql@lists.mysql.com
>Subject: like isn't behave as expected
>
>Hi
>
>i have one row in the cpe_id column of the cpe_users table in my
>database with the value: "d\d".
>
>when
>-Original Message-
>From: Peter Brawley [mailto:peter.braw...@earthlink.net]
>Sent: Friday, February 13, 2009 3:02 PM
>To: Yusuf Khan
>Cc: mysql@lists.mysql.com
>Subject: Re: Codd's rule 8 (physical data idependence)
>
>>*Applications should not be logicaly impaired when the physical sto
>-Original Message-
>From: PJ [mailto:af.gour...@videotron.ca]
>Sent: Sunday, February 22, 2009 2:39 PM
>To: MySql
>Subject: book categories
>
>Here's a tough one...
>In my library I have some 62 categories where a number of books can be
>in several categories.
>Now, to relate the "catego
>-Original Message-
>From: Hagen Finley [mailto:finha...@comcast.net]
>Sent: Monday, February 23, 2009 11:41 AM
>To: 'MySql'
>Subject: Record IDs
>
>I have a number of duplicate records in my table which are identical
>hence,
>I can't do a delete on the columns without deleting both recor
there on I was able to run mysql_upgrade
and get myself back on the air.
Can anyone guess where I went astray?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-in
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Wednesday, February 25, 2009 3:51 PM
To: Jerry Schwartz
Cc: MySql
Subject: Re: Upgrade story / request for insight
Hi Jerry,
probably does not help you very much and excuse me in advance for this,
[JS] No apology necessary.
but
From: Gary W. Smith [mailto:g...@primeexalia.com]
Sent: Wednesday, February 25, 2009 4:36 PM
To: Claudio Nanni; Jerry Schwartz
Cc: MySql
Subject: RE: Upgrade story / request for insight
Jerry,
To touch a little more on Claudio's statement, you are trying to compare
monkey's
ry,
>accessed by user/password login... so there's really very little
>possibility of 2 people accessing at the same time.
[JS] Being rather old to all this, I can tell you that if something is even
remotely possible it will happen just before your performance review. Never
depend u
record that has an auto-increment field, you can retrieve the value that got
inserted with "SELECT LAST_INSERT_ID()". It is connection-specific, so
you'll always have your "own" value. You can then save it to reuse, either
as a session variable or (more easily) as a hidden f
1 - 100 of 656 matches
Mail list logo
