MySQL Database Forum

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

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

I'm running MySQL 4.0 on SuSE Linux 7.3 Pro. I accidentally granted priveledges to a user with the following user label, quotes are part of the user label: // NOTE: replace with @, this was done to keep the mail client from turning it into a "mailto:" link. "someuser180.150.2.%" I did this by enclosing the entire user label in quotes...

Hi all, I have run into a bit of a problem. I recently setup mysql to run on a Debian Linux box I setup. I am by no means an expert on either linux or mysql. I know enough to just be dangerous. =) I had it set up so I could read and write to the database through my perl code, connect with phpmyadmin, etc. Not one to be happy I attempted...

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

I am curious about the internal representation of VARCHARS. I cannot find any documentation on it in the mySQL manual. Will a VARCHAR(10) take up less space then a VARCHAR(80), even though they are variable? Thanks in advance, Dan --

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

Hello, I would like to know the status of the UTF8 support in MySQL 4.1. I tried to create a table using utf8 charset, and inserting hebrew text into it. it seems like it still treats this text as binary - for example the length() function returns 8 on 4 chars string, or when cretting a column using varchar(4) i can only insert 2 letters...

What is the better approach in MySQL from a performance point of view? I have approx 1000 stock market fond titles that I want to insert in MySQL on daily basis and keep them in there for some years, I'll then use the data for presentations, analysis,… the data I save is the name, the date, the lowest, highest and last value and the volume....

Hello, I would like to know the status of the UTF8 support in MySQL 4.1. I tried to create a table using utf8 charset, and inserting hebrew text into it. it seems like it still treats this text as binary - for example the length() function returns 8 on 4 chars string, or when cretting a column using varchar(4) i can only insert 2 letters...

Hi, ID_LOGIN is an integer Can anyone say me if this : WHERE index1=ID_LOGIN OR index2=ID_LOGIN must be slower than those 2 queries :