RE: How long is my piece of string?

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 ph

RE: Embarrassing: can't log in

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 machi

RE: date conversion problem

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 convers

RE: trouble with LOAD command

I'd pick up the text file and search/replace all end of line character(s) with a end of line"00 "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

RE: Count Rows in two tables

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 > > > > Ala

RE: Count Rows in two tables

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

RE: last_insert_id()

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: [EM

RE: How to port MS Access to MySQL ??

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

RE: Newbie Question - Query works in access but not MySQL

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 i

RE: PHP bias (Way OT)

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 po

RE: little problem, I need some help...

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: 3mip1s4l

RE: mysqld refuse to die

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 name

RE: mysqld refuse to die

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

RE: Copy Records in a table...

e into which you are inserting." > - http://www.mysql.com/doc/en/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

RE: How to port MS Access to MySQL ??

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 manua

RE: Copy Records in a table...

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 eve

RE: MySQL and amanda

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!

RE: Removal of Primary Key in Mysql

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: Um

Error Code Question

This error comes up when altering table structure BUT it times out after a while. Error: 7 - Error on rename of '.\DBNAME\tablename.MYI' to '.\DBNAME\#sql2-61-19.MYI' (Errcode: 13) Some have said - "oh yeah, that's a permissions problem" but if it times out and finally the command executes after

RE: Access2MySQL

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, > > Aft

RE: Altering Table errors

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 M

RE: Altering Table errors

:38 > To: Alan McDonald > Cc: [EMAIL PROTECTED] > Subject: Re: Altering Table errors > > > Error 13 is an operating system privilege violation error. > the user 'mysql' does not own or have access to something in > the database. > > Alan McDonald wrote: > > &

Altering Table errors

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 there

Import from files

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 --

adUseClient

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

FW: The request properties can not be supported by this ODBC Driver.

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

error in the list?

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

RE: timestamp bug increments by one day

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 recientl

FW: Select statment

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) Tit

RE: a mysql question

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

RE: Inserting Master and Details records

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: R

RE: Inserting Master and Details records

? 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 > &g

Inserting Master and Details records

to grab 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.m