last_insert_id() value not updated

2004-06-01 Thread paqogomez
I am trying to build a stored procedure in v. 5. This is what I have so far. delimiter | create procedure get_id(out oid int) begin insert into mercury.merchant (name) values(null); select last_insert_id() into @mid; insert into mercury.customers( address1 ) values (null); select

INTO OUTFILE error

2004-06-01 Thread John Mistler
Can anyone guess why I am getting this error: ERROR 1: Can't create/write to file '/Users/johnmistler/Desktop/TestFile.txt' (ERRCODE 13) when using this statement: mysql SELECT * INTO OUTFILE '/Users/johnmistler/Desktop/TestFile.txt' FROM theTable WHERE column1 != 'thisString'; ? I am logging

Re: INTO OUTFILE error

2004-06-01 Thread Egor Egorov
John Mistler [EMAIL PROTECTED] wrote: Can anyone guess why I am getting this error: ERROR 1: Can't create/write to file '/Users/johnmistler/Desktop/TestFile.txt' (ERRCODE 13) when using this statement: mysql SELECT * INTO OUTFILE '/Users/johnmistler/Desktop/TestFile.txt' FROM theTable

Re: INTO OUTFILE error

2004-06-01 Thread John Mistler
Would there be any obvious reasons for its inability to access the desktop? I have used that desktop directory many times before in UNIX. Thanks, John on 6/1/04 12:49 AM, Egor Egorov at [EMAIL PROTECTED] wrote: John Mistler [EMAIL PROTECTED] wrote: Can anyone guess why I am getting this

Re: Lots of databases...how wrong is it?

2004-06-01 Thread Thomas Spahni
On Sat, 29 May 2004, Yannick Warnier wrote: - how wrong is creating 20 databases (total 400 tables) when you know you could create just one (total around 200 tables)? For linux ext2, I'd rather have 20db 20table than 1db 200 table. Neither approach practical limits tho. Well...

RE: Extending mySQL

2004-06-01 Thread Yiannis Mavroukakis
Thank you :) -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED] Sent: 29 May 2004 15:08 To: Yiannis Mavroukakis Cc: [EMAIL PROTECTED] Subject: Re: Extending mySQL Hi! On May 25, Yiannis Mavroukakis wrote: Hello, I'm hoping this is the correct list to post my

RE: 4.1 Beta

2004-06-01 Thread Alec . Cawley
Donny Simonton [EMAIL PROTECTED] wrote on 01/06/2004 03:12:43: We have been using 4.1 in a production environment since about a month after 4.1.0 was released. And we have run into a bug or two now and then, but that usually happens the first day we try something out. Overall, I

Re: Perl arrays into MySQL

2004-06-01 Thread Richard Clarke
A perhaps more perlish way would be, my $table = MyTable; my $sql = join ',', map {$_=?} keys % - Original Message - From: Daniel Kasak [EMAIL PROTECTED] To: Nik Belajcic [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 5:15 AM Subject: Re: Perl arrays into MySQL

Repost: Order by RAND + join problem

2004-06-01 Thread Gerske, Sebastian
Hello list, im having a hughe problem with the RAND() function first of all im using mysql 3.23 so subquerys are impossible. Im having three tables which are joined by ID's now i want to select a single row random out of the join set whats the best way to do it? My Table structure is: table1

Re: Perl arrays into MySQL

2004-06-01 Thread Richard Clarke
Crap sorry about the double post.. where's that damn undo send e-mail button :( A 'better' way imo would be, my %record; #full of my stuff my $table = MyTable; my $sql = join ',', map {$_=?} keys %record; $dbh-do(insert into $table set $sql,undef,values %record); Richard - Original

REPAIR TABLE f_ivairus_bodies;

2004-06-01 Thread php
Hello, @@@ please help me! @@@ mysql REPAIR TABLE f_ivairus_bodies; +++--++ | Table | Op | Msg_type | Msg_text |

short term rental

2004-06-01 Thread fconst
Buna ziua... In cazul in care cineva din echipa dvs.are de rezolvat probleme in Bucuresti pentru citeva zile si ar avea nevoie de cazare,va propunem o solutie alternativa la cazarea hoteliera. Firma Casa Sagitarius va ofera cazare in apartamente sau garsoniere mobilate

Re: REPAIR TABLE f_ivairus_bodies;

2004-06-01 Thread Egor Egorov
php [EMAIL PROTECTED] wrote: @@@ please help me! @@@ mysql REPAIR TABLE f_ivairus_bodies; +++--++ | Table | Op | Msg_type | Msg_text

Re: update synopsis error

2004-06-01 Thread saiph
What version of MySQL are you using? i use: mysql Ver 12.22 Distrib 4.0.18, for pc-linux-gnu (i386). UPDATE t1, t2 SET t1.name=t2.name WHERE t1.id=1 AND t2.id=1; it works :), tnx again. -- here are more things in heaven and earth, horatio, than are dreamt of in your philosophy. --

Why is This version 3.51.6 ?

2004-06-01 Thread Arthur Maloney
Hello mysql, Recently downloaded myODBC for use Win2k SP4 initially used EXE version (MySQL Connector/ODBC 3.51) when installed Looking at its properties myodbc3.dll shows that it 3.51.6 ?? Tried again with MSI install MyODBC-standard-3.51.07-win.msi myodbc3.dll also shows version 3.51.6

Re: Stop Scrolling

2004-06-01 Thread kc68
When I do mysqlSHOW TABLES \p less; I get the error message You have an error in your SQL syntax near 'less' in line 1 I am using dos, not unix. Ken ** On Mon, 31 May 2004 21:19:28 -0700, Robert J Taylor [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: Ultimately simple, but I don't

Re: redhat9 multiple instances walkthrough

2004-06-01 Thread Thierno Cisse
Hi, If you plan to use RPM installation, you could encounter some difficulties. Because RPM overrides the existing one. To avoid this , you can do a BINARY install with which you can choose the directories of two MySQL servers. After finishing to download the MySQL BINARY distribution that

mysql_server_init

2004-06-01 Thread Bono, Saroj AA R62
I have the call to mysql_server_init() cided exactly as it appears in the mysql manual sample. It returns 0 (success), yet the server is never sarted . I check that its not running by trying to type in the mysql command line (I had started the server normally before, started mysql, shutdown the

Re: INTO OUTFILE error

2004-06-01 Thread Egor Egorov
John Mistler [EMAIL PROTECTED] wrote: Would there be any obvious reasons for its inability to access the desktop? I have used that desktop directory many times before in UNIX. Check permissions on that dir. It must be writeable by the user you run mysqld as ('mysql' by default). on

RE: 4.1 Beta

2004-06-01 Thread Donny Simonton
You could always buy Oracle and charge an extra million or two. :)) Donny -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 4:20 AM To: [EMAIL PROTECTED] Cc: 'Jonathan Soong'; [EMAIL PROTECTED] Subject: RE: 4.1 Beta

RE: 4.1 Beta

2004-06-01 Thread Alec . Cawley
But then I would have to do without the excellent MySQL support. Donny Simonton [EMAIL PROTECTED] wrote on 01/06/2004 13:26:00: You could always buy Oracle and charge an extra million or two. :)) Donny -Original Message- Donny Simonton [EMAIL PROTECTED] wrote on

Error 1146 Table mysql.proc doesn't exist

2004-06-01 Thread Bungarz, Kai
Hi! I'm using mysql-max-nt, Version 5, running on Windows 2000. While inserting rows into a table from a perl script, i get error 1146: table mysql.proc doesn't exist. The application ran without any error with mysql, version 4. Any ideas? best regards, Kai Bungarz Wissenschaftliches Institut

RE: 4.1 Beta

2004-06-01 Thread Donny Simonton
Well, in that case, download the source. Modify the source to no longer include the word alpha. So instead of calling it, 4.1.2-alpha-standard-log, call it 4.1.2-super-duper-standard-log. 99% of the code is the same core code that is in 4.0.x and 3.23.x. It just has a few more features. Donny

mysqldump under cron

2004-06-01 Thread adam
Hello. I am using mysql 4.0.18 on rh3, and I would like to daily save db state. I have this small script under the cron directory that when executed from the prompt works fine. Basically the dump is done by: mysqldump --user=root --password=root-password --opt bugs

Re: Error 1146 Table mysql.proc doesn't exist

2004-06-01 Thread Josh Trutwin
On Tue, 1 Jun 2004 14:50:11 +0200 Bungarz, Kai [EMAIL PROTECTED] wrote: Hi! I'm using mysql-max-nt, Version 5, running on Windows 2000. While inserting rows into a table from a perl script, i get error 1146:table mysql.proc doesn't exist. The application ran without any error with mysql,

problem restoring backup made from mysqlhotcopy

2004-06-01 Thread Abuzar Chaudhary
Hi, Using a sample database, I have tablea and tableb. I populate tablea with some records and I can see the tablea.MYD file size increase on the drive, while tableb.MYD remains at zero bytes. Then I make a backup: mysqlhotcopy -u username -p password sample ./backup Next I modify the database:

RE: 4.1 Beta

2004-06-01 Thread Boyd E. Hemphill
I just installed 4.0.18 under Windows XP Home (I know, I know). After searching my hard drive I cannot find my.cnf or my.ini Where do I find the file? What is its name? Thanks Boyd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: mysqldump under cron

2004-06-01 Thread Brad Tilley
Here's a simple python script that I use to do mysql backups. I wrote it myself. It works great. Cron it to run however you like: def db_backup(): import os, time # Change db_list contents to reflect the names of your databases. db_list =

Re: mysqldump under cron

2004-06-01 Thread Chris Elsworth
On Tue, Jun 01, 2004 at 09:28:37AM -0400, adam wrote: mysqldump --user=root --password=root-password --opt bugs $BACKUPDIR$BACKUPSQLFILE My problem is that it does not seem to work when the crond calls the script. The result of the dump is a zero size sql file. Don't you get the output

Re: Perl arrays into MySQL

2004-06-01 Thread Tim Cutts
On 1 Jun 2004, at 2:55 am, Nik Belajcic wrote: This may be a silly question, but I am wondering if there is something opposite to: @row = $sth-fetchrow_array In other words, instead of fetching rows from MySQL and loading them into an array that can be accessed from Perl, I want to do the opposite

CRITICAL bug in 4.1.2 if one specifies innodb_file_per_table in Unix!

2004-06-01 Thread Heikki Tuuri
Hi! MySQL/InnoDB-4.1.2 is totally broken and useless if one has specified innodb_file_per_table in my.cnf on Unix! In crash recovery, InnoDB scans the database directories under the datadir, and opens files in in the read-only mode. But the exclusive file lock that InnoDB uses on the files fails

[BUG] Error: Mem area size is 0. Possibly a memory overrun

2004-06-01 Thread Horváth Ágoston János
My mysql server just died after ~1 months of continous run. It's a vanilla mysql 4.0.17 downloaded in binary form from mysql.com. The underlying HWSW was an athlon-xp cpu, vanilla 2.4.23 kernel, debian sid. It is proved to be stable otherwise. I've included the error log. Sorry for sending here,

MySQL Warnings

2004-06-01 Thread Mike Blezien
Hello, Noticed this morning when restarting MySQL, saw this in the error log file: Version 4.0.20(RPM's) --- 040601 9:17:17 /usr/sbin/mysqld: Normal shutdown 040601 9:17:18 InnoDB: Starting shutdown... 040601 9:17:20 InnoDB: Shutdown completed 040601 9:17:20

Re: MySQL Warnings

2004-06-01 Thread Jigal van Hemert
From: Mike Blezien [EMAIL PROTECTED] 040601 9:17:20 Warning: Asked for 196608 thread stack, but got 126976 Is this type of Warning something to be concerned about or is this common or how best to fix ?? --quote from Sergei Golubchik [EMAIL PROTECTED] I think, this is because

Re: [BUG] Error: Mem area size is 0. Possibly a memory overrun

2004-06-01 Thread Heikki Tuuri
Hi! This is a bug that is fixed in upcoming 4.0.21. See below for a workaround. If you configure innodb_additional_mem_pool_size so small that InnoDB memory allocation spills over from it, then every 4 billionth spill may cause memory corruption. A symptom is a printout like below in the

Re: MySQL Warnings

2004-06-01 Thread Mike Blezien
thx's for the input :) Mike Jigal van Hemert wrote: From: Mike Blezien [EMAIL PROTECTED] 040601 9:17:20 Warning: Asked for 196608 thread stack, but got 126976 Is this type of Warning something to be concerned about or is this common or how best to fix ?? --quote from Sergei Golubchik [EMAIL

Error compiling source for Win

2004-06-01 Thread Nandan Telang
Hi I have been trying to build from the MySQL server source distribution 4.1.2alpha for Windows. I created a Windows source package from the BitKeeper source tree. I then unzipped the mysql-4.1.2-alpha-win-src.zip and started the build using VC++ 6.0. I got the following error: Error

Upgrade 4.1.1 to 4.1.2

2004-06-01 Thread Larry Lowry
I'm running 4.1.1 on RH 9. I want to upgrade this to 4.1.2. I'm using the rpm from the MySQL site. If I just try to install it with rpm -i then I get a bunch of errors about conflicting files from the 4.1.1-1 install. If I try to uninstall first with rpm -e the version 4.1.1 then it tells me

Re: Upgrade 4.1.1 to 4.1.2

2004-06-01 Thread Brad Tilley
Man rpm and read a bit about the *upgrade* option... rpm -Uvh name-of-package Larry Lowry wrote: I'm running 4.1.1 on RH 9. I want to upgrade this to 4.1.2. I'm using the rpm from the MySQL site. If I just try to install it with rpm -i then I get a bunch of errors about conflicting files from

RE: Upgrade 4.1.1 to 4.1.2

2004-06-01 Thread Donny Simonton
Rpm -U xxx -Original Message- From: Larry Lowry [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 9:55 AM To: [EMAIL PROTECTED] Subject: Upgrade 4.1.1 to 4.1.2 I'm running 4.1.1 on RH 9. I want to upgrade this to 4.1.2. I'm using the rpm from the MySQL site. If

c api mysql_query to insert into a column of type datetime.....

2004-06-01 Thread Bono, Saroj AA R62
I am using mysql_query to insert into a column which is of type datetime. My variable is stored in a char string. I need to put it into the query in a way that it can be inserted: myDate = 98-12-12.this is what I have. sprintf (myquery, '%what here? ', myDate);

Re: 4.1 Beta

2004-06-01 Thread Ruben
there isn't a file with that name because there are several examples for different kinds of hardware setup, just rename the example that you think is right for you c:\mysql\ my-huge.cnf my-large.cnf my-medium.cnf my-small.cnf to c:\my.cnf Boyd E. Hemphill wrote: I just installed 4.0.18 under

Re: Upgrade 4.1.1 to 4.1.2

2004-06-01 Thread Larry Lowry
Well that worked quite well, but not until I rebooted the machine. Something was stuck but I sure do not know what. Thanks again. Larry - Original Message - From: Brad Tilley [EMAIL PROTECTED] To: Larry Lowry [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 8:01

Re: Upgrade 4.1.1 to 4.1.2

2004-06-01 Thread Stefan Kuhn
Am Tuesday 01 June 2004 16:54 schrieb Larry Lowry: I'm running 4.1.1 on RH 9. I want to upgrade this to 4.1.2. I'm using the rpm from the MySQL site. If I just try to install it with rpm -i then I get a bunch of errors about conflicting files from the 4.1.1-1 install. If I try to

Re: Questions on index and 'order by'

2004-06-01 Thread Chambon
Thank you Sasha for your answer.0 I still miss-understand index and 'order by'. After creating multiples index on a 'Test' table, the current problem is that mysql optimizer doesn't choose the right index. Here is a small example mysql desc Test ;

Re: Stop Scrolling

2004-06-01 Thread Hassan Schroeder
[EMAIL PROTECTED] wrote: When I do mysqlSHOW TABLES \p less; I get the error message You have an error in your SQL syntax near 'less' in line 1 I am using dos, not unix. 1) that's not the example provided 2) \p != \P 3) `pager` doesn't work in Windows, anyway, per:

RE: update synopsis error

2004-06-01 Thread Laercio Xisto Braga Cavalcanti
Saiph, You can use REPLACE command instead of UPDATE. This command will update all rows with the same primary key. Laercio. -Original Message- From: Michael Kruckenberg [mailto:[EMAIL PROTECTED] Sent: segunda-feira, 31 de maio de 2004 18:33 To: saiph Cc: [EMAIL PROTECTED] Subject: Re:

Starting mysqld at boot up in suse linux

2004-06-01 Thread Chris W
I have SuSE 9.1 and can't find any GUI auto config type option to start mysqld at boot up so I was wondering what was the best way to configure MySQL to start at boot time Chris W Bring Back the HP 15C http://hp15c.org:8080 Not getting the gifts you want? The Wish Zone can help.

Re: problem restoring backup made from mysqlhotcopy

2004-06-01 Thread gerald_clark
Don't EVER copy to database files while the server is running. This is a guaranteed way to crash your database files. Shutdown the server. Copy the files. Start the server. Abuzar Chaudhary wrote: Hi, Using a sample database, I have tablea and tableb. I populate tablea with some records and I can

MySQL 4.1.2 for Win32 issue?

2004-06-01 Thread Rick Robinson
I saw the announcement regarding some sort of issue with getting MySQL 4.1.2 ready for the Win32 platform - so what is the specific problem? I'm not saying that I could fix it, but I bet many others on the list could contribute nad/or fix it if the details of the problem were known. I'm looking

DISTINCT query

2004-06-01 Thread Jack Coxen
I'm having trouble with a query and hope someone of the list can help. I'm running version 4.0.16. I'm trying to query against two tables: mysql DESCRIBE router; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra

Re: DISTINCT query

2004-06-01 Thread SGreen
Jack, I am not sure what you want your output to look like... If you want the same columns (the routerid with the counts of how many interfaces operate at which speed) but broken down by unique descriptions that means to me that you have multiple descriptions for each unique interface ID... Is

locate peak hour

2004-06-01 Thread Niklas Karlsson
Hi everyone, I've got a project where I record measurement data for various objects in 15 minute intervals. A simplified table structure could look like: - objectid Integer - dt DateTime - measurementA Integer - measurementB Integer - measurementC Integer I've got a few thousand different

Server Capabilities

2004-06-01 Thread tachu
Since my previous post has been archived to may posts I will post again. Would mysql server be able to handle about 2000 databases per server. disregard space issues since thats not the case what im trying to see are the capabitilities of the mysql server for a future project. In average my

Trying to set up mySQL on Debian

2004-06-01 Thread Ryne Anderson
I belive ive gotten mySQL installed, but im getting a few errors that I cannot seem to figure out. When I try to test out the database by typing bin/mysqlshow or bin/mysqlshow mysql I get an error that looks like this: ryneanders01:/mysql# bin/mysqlshowbin/mysqlshow: Can't connect to local

Re: MySQL 4.1.2 for Win32 issue?

2004-06-01 Thread Nandan Telang
Hi I tried building and installing MySQL 4.1.2 for Windows (building it in Linux, transfering .zip and so on). Although I finally managed to do that, the purpose was to use the clustering feature of MySQL. But looking at the final directories, it seems there is no ndb ie clustering folder.

RE: DISTINCT query

2004-06-01 Thread Jack Coxen
The output looks like this... +--+-+--+--+ ~snip~ +---+ | Router | 64K | 128K | 192K | ~snip~ | Total | +--+-+--+--+ ~snip~ +---+ | router_1 | 0 |0 |0 | ~snip~ | 6 | | router_2 | 1 |6 |0 | ~snip~ |70 | | router_3 | 0

Combining multiple selects into 1 select.

2004-06-01 Thread Andy
Hello, Is is possible to combine the results of multiple selects into one query/result? And if so, how do you implement it? A simple example follows: Query 1: SELECT * FROM myTable WHERE OnSale = 'Y' Query 2: SELECT * FROM myTable ORDER BY Category Query 3: SELECT * FROM myTable WHERE Closeout

GET_LOCK(str,timeout) behaviour

2004-06-01 Thread Richard Clarke
The manual indicates that a GET_LOCK expires automatically when a new GET_LOCK is issued. Can someone explain to me how this behaviour could possibly be the most useful? I wish to use GET_LOCK in my applications to provide advisory locking on which tables should be used for certain operations. I

Re: Backing up InnoDB MySQL DB

2004-06-01 Thread Jim Nachlin
Victoria Reznichenko wrote: ColdFusion Lists [EMAIL PROTECTED] wrote: we're using MySQL 4.0.12 with InnoDB... please do you have any scripts, comments, suggestions, ideas, tutorials... about how to backup from that DB? It's possible to? You can use mysqldump utility that comes with MySQL

Re: GET_LOCK(str,timeout) behaviour

2004-06-01 Thread gerald_clark
GET_LOCK is just a string lock, and has nothing to do with tables. Use LOCK TABLES instead. Richard Clarke wrote: The manual indicates that a GET_LOCK expires automatically when a new GET_LOCK is issued. Can someone explain to me how this behaviour could possibly be the most useful? I wish to use

New 4.1.2 Startup Trouble

2004-06-01 Thread Greg Willits
I've installed mysql 3 4 a dozen times or more, but I'm having trouble with 4.1.2 on OS X Server (10.3.4). This is a new install, no previous mysql (never did fire up the built-in mysql on this particular box). The /data/{host}.err file shows the following after a machine reboot which should

Re: GET_LOCK(str,timeout) behaviour

2004-06-01 Thread Richard Clarke
I am aware it is a string lock, and this is what I want. LOCK TABLES is not suitable for advisory locking. My question is targetted at the usefulness of the GET_LOCK functionality when you can only lock one 'string' per connection. Richard - Original Message - From: gerald_clark [EMAIL

Re: Error compiling source for Win

2004-06-01 Thread Miguel Angel Solorzano
At 11:50 1/6/2004, Nandan Telang wrote: Hi, Thank you for your bug report. Hi I have been trying to build from the MySQL server source distribution 4.1.2alpha for Windows. I created a Windows source package from the BitKeeper source tree. I then unzipped the mysql-4.1.2-alpha-win-src.zip and

Table handler corruption problem

2004-06-01 Thread François Schiettecatte
Hi I am seeing an interesting (annoying) problem where my myisam tables are getting corrupted when subjected to a heavy update/insert load, generating the following errors: Error 'Got error 127 from table handler' on query 'update content set content=... This error seems to occur randomly,

Re: New 4.1.2 Startup Trouble

2004-06-01 Thread Hassan Schroeder
Greg Willits wrote: I've installed mysql 3 4 a dozen times or more, but I'm having trouble with 4.1.2 on OS X Server (10.3.4). Maybe it's not a MySQL problem -- I just happened to read: http://www.eweek.com/article2/0,1759,1603685,00.asp?kc=ewnws060104dtx1k0100599 ...about problems with 10.3.4

RE: DISTINCT query

2004-06-01 Thread SGreen
Hi Jack, Unless you have some method to identify an interface as historical there will be no way to eliminate the duplicates from your final report. It would be very easy to have a result row for a router with N physical ports show more than N logical ports without that kind of exclude me flag

Left outer join combined with inner join

2004-06-01 Thread Matthew Shalorne
Hi, with the tables eg: Product: id, product, cost ProductTag: productId, TagId Tag: id, tag I have created the ability to selectively assign tags to products if required via a many-to-many relationship. Now I want to join the tables in MySQL so that I can see all products and in the tag column

RE: Stop Scrolling

2004-06-01 Thread David Brodbeck
-Original Message- From: Hassan Schroeder [mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: When I do mysqlSHOW TABLES \p less; I get the error message You have an error in your SQL syntax near 'less' in line 1 I am using dos, not unix. 1) that's not the example

Re: Left outer join combined with inner join

2004-06-01 Thread gerald_clark
Matthew Shalorne wrote: Hi, with the tables eg: Product: id, product, cost ProductTag: productId, TagId Tag: id, tag I have created the ability to selectively assign tags to products if required via a many-to-many relationship. Now I want to join the tables in MySQL so that I can see all

Re: Left outer join combined with inner join

2004-06-01 Thread SGreen
Hi Matthew, There are several combination of things you can query for with the data you have: Only Products with Tags, Only Tags with products, all Products with or without Tags, all Tags with or without Products However you do not have the ability (yet) to query, in a single statement, for

Speed differences between joins and subqueries?

2004-06-01 Thread Daniel Ek
Hi all, I am wondering if anyone have any knowledge if there is speed difference between joins (inner | outer | left | right) and subqueries. Would I actually gain preformance using subqueries (new since 4.1) against using the old joins? Would be interesting to hear comments on this matter,

Equijoin on non-equality barfs!

2004-06-01 Thread Mailing List Receiver
mysql select bademail.email from bademail,noemail where bademail.email noemail.email; bademail has about 30,000 rows and noemail has 13,000. This, by the way, does a good job of bringing your system to its knees! Todd Merriman mailist @ toolz.com -- MySQL General Mailing List For list

Reloading Database with Foreign Keys

2004-06-01 Thread Robert A. Rosenberg
I just tried to reload a mysqldump created dump to a new server and got rejected due to lack of referential integrity. I remember the existence of a command I can insert in the file that will turn off the checking of the Foreign Keys while the recreation is being done but I can not locate it

RE: Reloading Database with Foreign Keys

2004-06-01 Thread Bartis, Robert M (Bob)
See http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html mysql SET FOREIGN_KEY_CHECKS = 0; mysql SOURCE dump_file_name; mysql SET FOREIGN_KEY_CHECKS = 1; Bob -Original Message- From: Robert A. Rosenberg [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 5:56 PM To:

Reloading Database with Foreign Keys

2004-06-01 Thread Robert A. Rosenberg
I just tried to reload a mysqldump created dump to a new server and got rejected due to lack of referential integrity. I remember the existence of a command I can insert in the file that will turn off the checking of the Foreign Keys while the recreation is being done but I can not locate it

Re: 'group by' does a free 'sort by'?

2004-06-01 Thread Udikarni
Michael, You are right - the cycle savings are minimal - usually because once the GROUPing is done - there aren't very many rows to be returned and sorting a few hundred of even a few thousand of them is pretty instantaneous. It's really mostly philosophical - when you only specify GROUP BY -

Bug? MySQL 4.1.2 and OS X 10.3.4

2004-06-01 Thread Greg Willits
This was New 4.1.2 Startup Trouble. The new title seemed more appropriate given my testing. Having installation problems with 4.1.2 on OS X 10.3.4. From previous thread: I've installed mysql 3 4 a dozen times or more, but I'm having trouble with 4.1.2 on OS X Server (10.3.4). Maybe it's not

Re: Cluster and Fulltext indexes?

2004-06-01 Thread Jon Drukman
Santino wrote: Hello, Does the cluster support fulltext indexes? After a quick reading of preliminary documentation it seems NO. Can someone confirm it? i had a meeting with the mysql cluster sales team and they said it is not supported. fulltext is for myisam only. cluster uses NDB storage

Re: Stop Scrolling

2004-06-01 Thread kc68
Thanks to everyone for responses, but the conclusion I'm reaching is that there is no simple command to stop scrolling of the table list in dos. As Hassan Schroder said, pager doesn't work in Windows, anyway. I did try mysqlSHOW TABLES \P less; and got an error message. I just don't

Re: problem restoring backup made from mysqlhotcopy

2004-06-01 Thread Abuzar Chaudhary
Aye, wish the documentation said something to that effect, it only said to restore it, simply copy the files back, without any examples or further explanation. Okay, so I'm not very good at linux, how do I stop and start the server without messing up how it starts or stops when the server is

RE: Combining multiple selects into 1 select.

2004-06-01 Thread Leo
Hi Andy, First of all you can make a temporary table.. Query 1: CREATE TABLE t_mytable SELECT * FROM myTable WHERE OnSale = 'Y' Query 2: INSERT INTO t_mytable SELECT * FROM myTable ORDER BY Category Query 3: INSERT INTO t_mytable SELECT * FROM myTable WHERE Closeout = 'Y' Query 4: SELECT *

RE: Reloading Database with Foreign Keys

2004-06-01 Thread Robert A. Rosenberg
At 18:01 -0400 on 06/01/2004, Bartis, Robert M (Bob) wrote about Re: Reloading Database with Foreign Keys: See http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html mysql SET FOREIGN_KEY_CHECKS = 0; mysql SOURCE dump_file_name; mysql SET FOREIGN_KEY_CHECKS = 1; Bob Thanks - that

Error on Outfile

2004-06-01 Thread [EMAIL PROTECTED]
input: select firstname,middlename,lastname,county,state,dob,ssn into outfile '/Users/user/temp/test.csv' fields terminated by ',' lines terminated by '\n' from iffinet.subjects where client_id='1' and ostatus='complete'; output: ERROR 1: Can't create/write to file '/Users/timbest/test.csv'

Re: problem restoring backup made from mysqlhotcopy

2004-06-01 Thread venkata ramana
On Tue, 1 Jun 2004 18:33:53 -0700 (PDT), Abuzar Chaudhary [EMAIL PROTECTED] wrote: Aye, wish the documentation said something to that effect, it only said to restore it, simply copy the files back, without any examples or further explanation. Okay, so I'm not very good at linux, how do I

Short Passwords in 4.1.2

2004-06-01 Thread Greg Willits
I'm trying to force 4.1.2 to use the old short passwords for now during some experimental stages. The discussion here (specifically the fourth set of bullets): http://dev.mysql.com/doc/mysql/en/Password_hashing.html and, this paragraph: The Password column must be wide enough to hold

Re: Bug? MySQL 4.1.2 and OS X 10.3.4

2004-06-01 Thread Greg Willits
On Jun 1, 2004, at 5:04 PM, Greg Willits wrote: So, - G4/OS X Server: 4.0.20 installs fine, but 4.2.1 does not on 10.3.4 - G3/OS X Standard: 4.2.1 installs fine on 10.3.2, but after 10.3.4 Standard was installed, 4.2.1 did not work, yet 4.0.20 continues to install fine The fact that 4.0.20 will

Re: MySQL Warnings

2004-06-01 Thread Heikki Tuuri
Mike, - Original Message - From: Mike Blezien [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, June 01, 2004 5:29 PM Subject: MySQL Warnings Hello, Noticed this morning when restarting MySQL, saw this in the error log file: Version 4.0.20(RPM's) ... Also, we