MySQL Database Forum

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

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

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

------_=_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...

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

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_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, How do i insert binary data into a BLOB field??? Like , if i have a table with say 3 fields of which 1 is blob type, now how do i store some binary file in that particular field??? Please help me out as i have to look put for some corresponding function in C++ API after that.Thank You ___________________________________________________...

Hey all, I was trying to compile, test and install MySQL-4.0.13. Compile went well and it was configured with --with--innodb --enable-assembler --prefix=/usr and nothing else. However when I make test it goes through to create, passes that then stops for 30 seconds and give the error that the '/master.pid file was not created in 30 seconds;...

I am currently using MySQL 3.23 for a live web site. I have new queries that need UNION provided in v4.0.0+. It's a simple db with 5 tables and doesn't perform any e-commerce type transactions. All of the 7 tables are of type MyISAM. So I have to upgrade MySQL on the live server. Q: Do I install to 4.0.12, or 4.1, or 5.x ? Because the...

Hey all, I was trying to compile, test and install MySQL-4.0.13. Compile went well and it was configured with --with--innodb --enable-assembler --prefix=/usr and nothing else. However when I make test it goes through to create, passes that then stops for 30 seconds and give the error that the '/master.pid file was not created in 30 seconds;...

I am trying to figure how to make a single select query in one table between two fields to see if they are similiar. I need the second one to have a wildcard. I can easily do this with no wildcard to see if they are the same but I can't get anything to work when it should be LIKE. Example: Table: test Field1 = "testing 123"...

I am currently using MySQL 3.23 for a live web site. I have new queries that need UNION provided in v4.0.0+. It's a simple db with 5 tables and doesn't perform any e-commerce type transactions. All of the 7 tables are of type MyISAM. So I have to upgrade MySQL on the live server. Q: Do I install to 4.0.12, or 4.1, or 5.x ? Because the...

------=_NextPart_000_004A_01C34977.7C6908A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable =20 After I downloaded the Ver 5 Dev tree how do I get it active. I tried = the Windows stuff on the Mysql site with no luck.

When I execute the following SQL statement at the mysql> prompt, I get a random result: SELECT proxy FROM proxies WHERE active = 1 ORDER BY RAND() LIMIT 1; When I wrap it in my perl code, I always get the first row in the database. my $dbh = DBI->connect("dbi:mysql:$db:host=$db_host", $db_user, $db_pass); my $sql = "SELECT proxy FROM...

While doing a couple of grant statements I suddenly got the message that user.MYD could not be opened. So I copied it back from yesterdays backup but no luck. I restored user.MYD, user.MYI and user.frm and after that the whole mysql directory in /var/lib/mysql but the server now refuses to start. What can I do? Thanks and cheers, Konrad

trying to add a FK to an existing table, to see table structures, alter table syntax and error refer to http://sourcepost.sytes.net/sourceview.aspx?source_id=6332 ===== David L. Corsaut dcorsaut@yahoo.com mobile: 206.790.0969 __________________________________

I have a table containg say subjects with an id field: Table subjects: id integer primary key name varchar(30) other fields Some subjects may be associated. This is handled by another table, containing two fields:

I would like to select data from a table where the table name is located in another table, and I am using the following query: select t1.* from (select tbl_name from user_table where user="guy") t1; This should return the data from table 'tbl_name', but I only get results from the subquery (ie. the query as a whole returns 'tbl_name', not...

I ran a search through the mySQL manual and google and could not find a satisfactory answer. Does mySQL support the declaration of a boolean data type? Currently I am using VARCHAR(6)s with either 'TRUE' or 'FALSE' and would like to cut down on the storage. Thanks in advance, Dan Anderson