You need indexes as soon as (or rather just before) they provide a
performance difference.
Alan
-Original Message-
From: Iain Lang [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 22 December 2002 11:15 AM
To: [EMAIL PROTECTED]
Subject: How long is my piece of string?
.
Dear List,
I'm using
it only takes a few minutes to uninstall and install...
-Original Message-
From: Amittai Aviram [mailto:[EMAIL PROTECTED]]
Sent: Monday, 2 December 2002 9:37
To: Mysql
Subject: Embarrassing: can't log in
I've got an embarrassing problem. I installed MySQL on my WinXP machine
this might give you some ideas
select
CONCAT(DAYOFMONTH(p.DATEGOLIVE),'.',MONTH(p.DATEGOLIVE),'.',YEAR(p.DATEGOLIV
E)) DATEGOLIVEF
from my table p
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Friday, 22 November 2002 13:01
To: MYSQL
Subject: date conversion
I'd pick up the text file and search/replace all end of line character(s)
with a end of line00 comma combination so it reads
00,Abe,Lincoln,8347
on each line and try your first method. If that fails, I would drop the ID
field off the table, then do the import with original file, then atlter the
Do you have a space between PartNumber and Like?
Also there's not need to ORDER BY - the GROUP BY does that anyway (I know
that's the case elsewhere)
and finally, I have to guess that it's objecting to Obsolete not being in
the main select.. have you tried including it and grouping by it? you can
MySQLFront will create the tables and pump the data with one button
press
Alan
-Original Message-
From: Terry [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 12 November 2002 22:02
To: [EMAIL PROTECTED]
Subject: RE: How to port MS Access to MySQL ??
MyODBC works fine,
but what to
The .Neta Adapter.. does it make a persistent connection?
If the connection drops between the first insert and the call to select,
then the return would be zero
Alan
-Original Message-
From: Cain O'Sullivan [mailto:cos;iinet.net.au]
Sent: Wednesday, 13 November 2002 16:13
To: [EMAIL
You can't count the join?
Alan
-Original Message-
From: Rick Baranowski [mailto:rickb;baranconsulting.com]
Sent: Wednesday, 13 November 2002 12:10
To: [EMAIL PROTECTED]
Subject: Count Rows in two tables
Hello all,
Does anybody have a SQL string to count the rows in two
Ah, yes - sorry
Alan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:murad;godel.bioc.columbia.edu]On Behalf Of Murad Nayal
Sent: Wednesday, 13 November 2002 12:58
Cc: [EMAIL PROTECTED]
Subject: Re: Count Rows in two tables
Alan McDonald wrote:
You can't count
I agree mostly,... but why is ASP worthless?
Alan
-Original Message-
From: [EMAIL PROTECTED] [mailto:vanboers;why.dedserius.com]On
Behalf Of Van
Sent: Monday, 11 November 2002 6:21
To: Paul DuBois
Cc: MySQL
Subject: Re: PHP bias (Way OT)
Paul:
Not sure why my post didn't cc
As Far As I Know
-Original Message-
From: Gelu Gogancea [mailto:ggelu;arctic.ro]
Sent: Saturday, 9 November 2002 23:37
To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
Subject: Re: mysqld refuse to die
Yes.All processes are named mysqld...less one mysqld_safe
which is main
Also
In My Humble Opinion (IMHO)
For What It's Worth (FWIW)
-Original Message-
From: Gelu Gogancea [mailto:ggelu;arctic.ro]
Sent: Saturday, 9 November 2002 23:37
To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
Subject: Re: mysqld refuse to die
Yes.All processes are named
Every SQL database requires the ability to locate a record which is unique
in some way. You can't have two records which look the same.
That's why you need to define a primary KEY on a column or coumns.
You need to read a primer on SQL databases
Alan
-Original Message-
From:
MySQLfront does it all
-Original Message-
From: tmb [mailto:topmailbox;yahoo.com]
Sent: Friday, 8 November 2002 23:18
To: [EMAIL PROTECTED]
Subject: How to port MS Access to MySQL ??
Is there a tool for doing a quick port from MS Access
to MySQL?
Or must you manually create
/INSERT_SELECT.html
On Thursday, November 7, 2002, at 08:56 PM, Alan McDonald wrote:
insert into mytable(field1, field2, field3) select field1, field2,
newvalue
from mytable where productcode=xx
-Original Message-
From: Doug Coning [mailto:lists;coning.com]
Sent: Friday, 8
insert into mytable(field1, field2, field3) select field1, field2, newvalue
from mytable where productcode=xx
-Original Message-
From: Doug Coning [mailto:lists;coning.com]
Sent: Friday, 8 November 2002 14:35
To: [EMAIL PROTECTED]
Subject: Copy Records in a table...
Hi everyone,
I was under the impression that hotbackup was only available with innodb
tables
where do you get amanda from?
Alan
-Original Message-
From: Lewis Watson [mailto:lists;visionsix.com]
Sent: Wednesday, 6 November 2002 14:22
To: mysql
Subject: MySQL and amanda
Hey MySQL users!
I have
Because a primary key is a table property and the index of the key is a
property of the primary key. If you want ot drop a primary key you alter the
table
-Original Message-
From: Eric Frazier [mailto:ef;kwinternet.com]
Sent: Tuesday, 5 November 2002 15:26
To: Paul DuBois
Cc: Uma
Then, why..., if I wait a little longer, does the alter command work? I do
not change the the permissions in the meantime. I just wait.
Alan
-Original Message-
From: gerald_clark [mailto:gerald_clark;suppliersystems.com]
Sent: Tuesday, 29 October 2002 1:38
To: Alan McDonald
Cc
I use MySQLFront and is creats the tables and imports the data with one
click
never had a problem
Alan
-Original Message-
From: [EMAIL PROTECTED] [mailto:Sam4Software;aol.com]
Sent: Wednesday, 30 October 2002 9:15
To: [EMAIL PROTECTED]
Subject: Access2MySQL
Hi all,
After setting
MySQL
I asume that when I add a field or rename a field etc and get the errcode
13, that I must wait til a connection timeout has occurred to be able to
make this structural change. While I'm developing, is there a quicker way to
do this?
Stopping/starting the service is not that quick.. Is
But after a while it does, cause I only have to wait a while with no
activity on the database, and the command executes. So it's not permissions
Alan
-Original Message-
From: gerald_clark [mailto:gerald_clark;suppliersystems.com]
Sent: Tuesday, 29 October 2002 1:38
To: Alan McDonald
Is it possible to update a field using SQL with the contents of a text file
previoously written to disk?
I want to update a mediumtext field with the contents of c:\data\mytext.txt
file.
update mytable set mymediumtext= filecontents where id=number... ?
Alan
SQL
ASP
I can't seem to find any examples of saving text area form inputs to TEXT
type fields.
They all seem to be text inputs or strings being saved to varchar fields...
Can someone point me to an example of saving large text quantities to a TEXT
Type field in ASP?
Thanks
Alan McDonald
http
SQL
The docs say that recordset1.RecordCount will return the correct value if
adUseClient is used as the cursorlocation setting. I find that this is not
correct - is there another setting which needs to be mae to make this return
correctly - my return matching rows setting is also set.
Alan
John,
StudioName?
GenreName?
F_Name?
L_Name?
DatabaseName?
ServerName?
Alan
I can't seem to figure out the select statement to get the name. Do I need
the the StarID or ActorID in Titles table? Thank you.
I am using PHP and MYSQL.
Studios (StudioName, StudioID)
Genres (GenreName, GenreID)
isn't that the month changing?
it's changing from october to january...??
Alan
-Original Message-
From: Jay X [mailto:sparqz50;hotmail.com]
Sent: Monday, 21 October 2002 12:20
To: [EMAIL PROTECTED]
Subject: timestamp bug increments by one day
Hi There,
Just reciently (after
can someone tell me why I get this error back from postings?
Your message was not delivered for the following reason:
E-mail Account: lists-mysql is over the limit of 31457280 bytes.
Automated Postmaster
Alan McDonald
http://www.meta.com.au
I think you need to give us the SQL you are using to do the search - we'll
ba ble to see what your are trying to do better
Alan
-Original Message-
From: µÑ ¶Ì [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 17 October 2002 15:37
To: [EMAIL PROTECTED]
Subject: a mysql question
I'm a
a generator ID and using that (guaranteed to
be unique) for both the primary key of the master and the foreign key of the
detail records. Surely there is a good method for use with MySQL?
Alan McDonald
http://www.meta.com.au
? Or
does insert_id() return another connections last insert?
Alan
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 17 October 2002 0:59
To: Alan McDonald; [EMAIL PROTECTED]
Subject: RE: Inserting Master and Details records
Hi
insert_id returns
Sorry your second link makes that claim a little clearer - it's on a
per-connection basis
Alan
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 16 October 2002 23:58
To: [EMAIL PROTECTED]
Cc: Alan McDonald
Subject: Re: Inserting Master and Details
32 matches
Mail list logo