MySQL Database Forum

------_=_NextPart_001_01C349DA.E4B7E120 Content-Type: text/plain; charset="iso-8859-1" Hi, As a newcomer to this mailing list -- and to the MySQL database environment -- my main field of interest is the use of Spatial data. Before I start dropping my questions (a have a few) all over this list, two quick ones to start with:

Hi, does anybody know how to copy a record within one table? I am looking for some simple method similair to INSERT INTO orders SELECT * FROM orders WHERE Order_ID=256; Actually, this method does not work and I can not believe that MySQL does not offer some simple method how to do it. Keep in mind that I have a 60-field table. So, naming...

------_=_NextPart_001_01C349DA.E4B7E120 Content-Type: text/plain; charset="iso-8859-1" Hi, As a newcomer to this mailing list -- and to the MySQL database environment -- my main field of interest is the use of Spatial data. Before I start dropping my questions (a have a few) all over this list, two quick ones to start with:

------_=_NextPart_001_01C349EC.F2635A68 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable _________ _______ _ __ /___ ___/ / ___ / / \ / / / / / / / / / ^ v /

------_=_NextPart_001_01C349EC.F2635A68 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable _________ _______ _ __ /___ ___/ / ___ / / \ / / / / / / / / / ^ v /

Hi all. I have a MyISAM table ( MySQL-4.0.13) that will get truncated every month, and around 1,000,000 records imported into it. The import process consists of a 'load data infile' operation, followed by some updates to extract data and dump it somewhere where it is easier to access ( in the same table ). The problem is that each time I...

Hi all. I have a MyISAM table ( MySQL-4.0.13) that will get truncated every month, and around 1,000,000 records imported into it. The import process consists of a 'load data infile' operation, followed by some updates to extract data and dump it somewhere where it is easier to access ( in the same table ). The problem is that each time I...

Hello George, Monday, July 14, 2003, 11:46:06 AM, you wrote: Read this: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html

What works for me with mysql 3.23.49 of Debian GNU/Linux (Woody), does not any more with mysql 3.23.56 of fink (current-stable, for fink cf. fink.sf.net) - I am not sure, if this problem is caused by the mysql version (some security changes between .49 and .56) or by the fink configuration - I might ask at the fink-users list later. I am...

Hi, does anybody know how to copy a record within one table? I am looking for some simple method similair to INSERT INTO orders SELECT * FROM orders WHERE Order_ID=256; Actually, this method does not work and I can not believe that MySQL does not offer some simple method how to do it. Keep in mind that I have a 60-field table. So, naming...

------_=_NextPart_001_01C349FB.3DE177A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable g'day listers i run a mysql 4.0.13 master and slave on linux rh 7.3 servers. every now = and then i get a error on the slave. the error is that it cannot insert = data into a table that does not exist. the...

Hello George, Monday, July 14, 2003, 11:46:06 AM, you wrote: Read this: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html

What works for me with mysql 3.23.49 of Debian GNU/Linux (Woody), does not any more with mysql 3.23.56 of fink (current-stable, for fink cf. fink.sf.net) - I am not sure, if this problem is caused by the mysql version (some security changes between .49 and .56) or by the fink configuration - I might ask at the fink-users list later. I am...

------_=_NextPart_001_01C349FB.3DE177A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable g'day listers i run a mysql 4.0.13 master and slave on linux rh 7.3 servers. every now = and then i get a error on the slave. the error is that it cannot insert = data into a table that does not exist. the...

------_=_NextPart_001_01C34A01.33763174 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable The MySQL manual mentions that one could specify the column and value = separators and the end of file marker explicitly in the LOAD DATA = statement. =20 I'm looking for the syntax of this statement to...

Hello group, For everyone who thinks about moving from MySQL to PostgreSQL I have a realy bad news - It's not worth. Why, You may ask... A few days ago I have installed and tested PostgreSQL, becouse I realy need UTF-8 support and subselects. I thought that PostgreSQL will be as good as MySQL but also will give me that features, which aren't...

------_=_NextPart_001_01C34A01.33763174 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable The MySQL manual mentions that one could specify the column and value = separators and the end of file marker explicitly in the LOAD DATA = statement. =20 I'm looking for the syntax of this statement to...

Hello group, For everyone who thinks about moving from MySQL to PostgreSQL I have a realy bad news - It's not worth. Why, You may ask... A few days ago I have installed and tested PostgreSQL, becouse I realy need UTF-8 support and subselects. I thought that PostgreSQL will be as good as MySQL but also will give me that features, which aren't...

------_=_NextPart_001_01C34A15.850E4CF5 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Does mysqlhotcopy work with innoDB? I only get it to work with MyISAM tables... For innoDB only the structure is saved but not the data =20 Thanks for some answers, Moritz

------=_NextPart_000_0019_01C2D0F9.BFBD6610 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello There, I try to compiling Mysql V4.0 in the Alpha/Tru64 Unix V5.1a. I have installed in the Alpha C++ and C version 6.5, and gcc 3.3 and GNU MAKE 3.8.

------_=_NextPart_001_01C34A15.850E4CF5 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Does mysqlhotcopy work with innoDB? I only get it to work with MyISAM tables... For innoDB only the structure is saved but not the data =20 Thanks for some answers, Moritz

------=_NextPart_000_0019_01C2D0F9.BFBD6610 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello There, I try to compiling Mysql V4.0 in the Alpha/Tru64 Unix V5.1a. I have installed in the Alpha C++ and C version 6.5, and gcc 3.3 and GNU MAKE 3.8.

Hello all, Is it possible to LEFT JOIN a table to itself? I want to see all records in a table where the year of the sales date is 2003 and where the salesman sold an item to a customer to which he did not sell that item to in 2002. The following is an example table (SALES):

I need to query multiple (15) tables to build a data entry screen. Is better to create 15 separate SELECT statements and query each table independently or create 1 large SELECT and query one time? Thanks!

Hello all, Is it possible to LEFT JOIN a table to itself? I want to see all records in a table where the year of the sales date is 2003 and where the salesman sold an item to a customer to which he did not sell that item to in 2002. The following is an example table (SALES):