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

Dan

07-14-2003 07:46 AM
Sergei Golubchik

No success either, thank you anyway. reuleaux% mysql -u root -p*** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection...

Andreas Reuleaux

07-14-2003 07:35 AM
Andreas Reuleaux

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

George Georgeus

07-14-2003 07:31 AM
Sergei Golubchik

"Alex82" <alex_82 (AT) tin (DOT) it> wrote: CHECK clause does nothing. It's just parsed. -- For technical support contracts, goto...

Egor Egorov

07-14-2003 07:00 AM
Egor Egorov

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 :

Yann GAUTHERON

07-14-2003 06:36 AM
Victoria Reznichenko

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

Krasimir_Slaveykov

07-14-2003 05:54 AM
Krasimir_Slaveykov

Hello Shazia, Friday, July 11, 2003, 10:25:56 PM, you wrote: This is a tipical CROSSTAB...

Krasimir_Slaveykov

07-14-2003 05:10 AM
Krasimir_Slaveykov

Ive searched the archives, read the books front to back, still haven't gotten a solution, hoping someone can help here. mysqld has been running great...

Ryan Schuermann

07-14-2003 04:57 AM
Ryan Schuermann

Andrey <leyandrew (AT) yahoo (DOT) com> wrote: Use SELECT .. LIMIT 1000, 1000 to retrieve the next 1000...

Victoria Reznichenko

07-14-2003 04:47 AM
Krasimir_Slaveykov

------=_NextPart_000_0024_01C34812.8D662A40 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi there. I...

Phil Evans

07-14-2003 04:31 AM
Rudy Metzger

From what I know is, that MySQL always locks the MyISAM table before you insert, update or delete something from it. So the key here is not so much...

Rudy Metzger

07-14-2003 04:22 AM
Rudy Metzger

I checked the archives, so I think this is the proper list to post this on. I'm not altogether sure, though, so if I'm mistaken feel free to,...

Dancing Tree

07-14-2003 04:14 AM
Rudy Metzger

i think this should be no problem... i'd think of some table layout like this: date int PRIMARY student_id int PRIMARY status ...

07-14-2003 03:46 AM
Rudy Metzger

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

Sreesekhar Palaparthy

07-14-2003 03:25 AM
Thomas Spahni

------_=_NextPart_001_01C349DA.E4B7E120 Content-Type: text/plain; charset="iso-8859-1" Hi, As a newcomer to this mailing list -- and to the MySQL...

Gijsbert Noordam

07-14-2003 02:45 AM
Gijsbert Noordam

------=_NextPart_000_003E_01C34934.FBC032B0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hello, I'm...

Alexander Newald

07-14-2003 02:01 AM
Sergei Golubchik

Hi MySQL Fans ;-) I would like to list all courses with have less than lets say 10 participants. Does anybody know how I would have to modify the...

Nils Valentin

07-14-2003 12:21 AM
Nils Valentin

Hey all, I was trying to compile, test and install MySQL-4.0.13. Compile went well and it was configured with --with--innodb...

Jamie Krasnoo

07-13-2003 10:58 PM
Jamie Krasnoo

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

Will

07-13-2003 10:58 PM
Will

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

ParisTheDog

07-13-2003 09:59 PM
ParisTheDog

Hi, I'm looking at buying a new production server, as soon as i mentioned mysql the Dell salesmen started pushing 3-4Gb of ram, i'm not sure if...

Brad Brad

07-13-2003 08:25 PM
Ow Mun Heng

------=_NextPart_000_004A_01C34977.7C6908A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable =20 After I...

Andy Hartman

07-13-2003 07:48 PM
Andy Hartman

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

Joe Blower

07-13-2003 06:06 PM
dw

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

Konrad Mathieu

07-13-2003 04:47 PM
Aggro

In the last episode (Jul 11), Nicholas Elliott said: MyISAM doesn't have a hard 4gb table size... It may default to a 4gb limit if you forgot to...

Dan Nelson

07-13-2003 03:42 PM
Heikki Tuuri

trying to add a FK to an existing table, to see table structures, alter table syntax and error refer...

David Corsaut

07-13-2003 03:34 PM
Heikki Tuuri

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

Dan Anderson

07-13-2003 02:42 PM
Dan Nelson

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

Dan Anderson

07-13-2003 02:38 PM
Jim McAtee

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

RHO

07-13-2003 01:41 PM
RHO

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

Shawn McGinn

07-13-2003 12:31 PM
Dan Anderson

I've read through the archives and spent hours on Google but I still can't figure this out. I must extract the data from a SQL Server *.DB file. ...

Becoming Digital

07-13-2003 11:00 AM
UID_0

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

anders

07-13-2003 09:47 AM
anders

I have a table of daily information (tips, # of deliveries, etc.). Does anyone know of an easy way using SQL to extract all weekly sums of a...

Trevor Smith

07-13-2003 08:45 AM
Veysel Harun Sahin

I'm trying to help a friend with this. When I run this everything is fine SELECT * from clicks, urls WHERE clicks.url=urls.url AND urls.description...

Craig Westerman

07-13-2003 12:02 AM
Craig Westerman

Hi, I have noticed recently that every time I go to the MySQL manual page I get prompted to install Gator spyware. If MySQL condones or is going...

C. Reeve

07-12-2003 10:25 PM
Informal Data Systems

We have the three tables below and for each customer, we need the following information; Result expected: Month | Sales total |...

Barry Olly

07-12-2003 02:00 PM
Barry Olly

Ralph Freshour <ralph (AT) primemail (DOT) com> wrote I would recommend buying the book below; Mysql Cookbook by Paul Dubois

Barry Olly

07-12-2003 01:44 PM
Barry Olly

I have written a database for a quote of the day. When my php script pulls it into a table, it doesn't wrap. The cell that it is in is wrappable. ...

Erik Thompson

07-12-2003 01:19 PM
Erik Thompson

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

ParisTheDog

07-12-2003 11:27 AM
ParisTheDog

Hi All, I want to bring back my mysql original database as well as root GRANTS as was during the installation because i installed an application...

Sohail Hasan

07-12-2003 07:46 AM
Sohail Hasan

I am trying to develop a web based database application to manage a Scout group. I need to control the level of access different visitors to the...

Murray

07-12-2003 03:19 AM
Murray

Hi, I just joined this list and would like to search the archives before I ask a = question. I there a way to search. Thanks=20 -- MySQL General...

Ernest Pianalto

07-12-2003 03:17 AM
Victoria Reznichenko

Hello, Is there a way to specify MyISAM for all tables in a given file rather than having to specify it at the end of each table declaration. I...

Neil Zanella

07-12-2003 02:52 AM
Victoria Reznichenko

Sorry Nils sent in hast.=20 -----Original Message----- From: Mike =20 Sent: Friday, July 11, 2003 9:08 PM To: 'Nils Valentin' Subject: RE: What's up...

Mike

07-11-2003 11:45 PM
Mike

Hi Brian, thats fine. You can always convert between the different table formats. As= =20 long as you know some rules there will be no data...

Nils Valentin

07-11-2003 08:10 PM
Nils Valentin

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

ParisTheDog

07-11-2003 05:40 PM
ParisTheDog

Hi, I'm trying to setup a webpage that will allow me to use similar results to that of show tables, show index from table_name, describe table_name...

Jeff North

07-11-2003 05:07 PM
Jeff North

have a table CREATE TABLE `pics2003` ( `ID` int(11) NOT NULL auto_increment, `Title` varchar(255) NOT NULL default '', `ShortDesc` text, `LongDesc`...

Ray

07-11-2003 03:43 PM
Ray

I'm having a debate with a co-worker whether or not I need to normalize this situation. I have an "Artist" table. I have an "Album" table. I then...

Rader

07-11-2003 02:16 PM
Rader

------=_NextPart_000_0022_01C347A5.67020F30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding:...

Dathan Vance Pattishall

07-11-2003 02:03 PM
Dathan Vance Pattishall