Re: DELETE from more than one table

On Mon, 07 Jun 2004 12:36:47 + shaun thornburgh [EMAIL PROTECTED] wrote: Hi, Is it possible to DELETE from more than one table in one command? Thanks for your help DROP TABLE IF EXISTS table1, table2, table3; http://dev.mysql.com/doc/mysql/en/DROP_TABLE.html Josh -- MySQL General

Re: Comma Delimited Import Error

David Blomstrom wrote: I just discovered that one of my MySQL tables is incomplete. I created it by importing a comma delimited file I had made from a spreadsheet, but it appears as many as 3,000 rows or so were missing. So I decided to give it another try. MySQL Front refused to import it

RE: Select double value

The problem is that in my java.sql.ResultSet.getDouble(strength) a zero amount throws a number format exception. Hi Paul, Not a Java user so I haven't tested this. You could try... SELECT abs( strength ) FROM data ; It 'might' stop the exception! Cheers Dean -- MySQL General Mailing

RE: Select double value

Are you catching the error? Are you sure the value returned is what you are expecting? -Original Message- From: Dean Urmson To: 'Paul McNeil'; [EMAIL PROTECTED] Sent: 6/7/04 8:16 AM Subject: RE: Select double value The problem is that in my java.sql.ResultSet.getDouble(strength) a

Re: Initiate perl script in linux from a Windows VBA program

Thanks for the response. Does this mean that I would not use perl and only program in VBA? If I do need perl does it have to be installed on the Windows side? Where can I get some examples with ODBC in VBA? thanks. Mike Hillyer [EMAIL PROTECTED] wrote: Annie Law wrote: Hi,I would

Re: Backing Up a Database

Thanks, but I have innodb tables as well. I don't see any caveats in the docs for mysqldump, so I'm *assuming* it'll work correctly, but I'd like to hear from someone who is counting on it in a production environment, just to be sure. Thanks, Lou - Original Message - From: McKeever

Re: Spatial extensions and GIS

In both cases you will have to write your own code. MySQL, so far, only can store Spatial data and do very simple (still, r-tree optimized) GIS queries (like: all objects inside rect). mirza Terry Pothecary wrote: Hi. This may be a daft question, so forgive me: I am just starting out with the

RE: DELETE from more than one table

Hi Paul, Thanks for the reply. I actually need to delete data from about 10 tables, is this possible? From: Paul McNeil [EMAIL PROTECTED] To: shaun thornburgh [EMAIL PROTECTED] Subject: RE: DELETE from more than one table Date: Mon, 7 Jun 2004 08:47:04 -0400 I believe you can use... Delete from

4.1.2 regression failure: error reading communicaton packets

Description: I have just built 4.1.2 from source (in order to include OpenSSL), and find that the regression testing fails on the first test. The master.err contains the following: CURRENT_TEST: alias /usr/local/src/db/mysql-4.1.2-alpha/sql/mysqld: ready for connections. Version:

RE: Endless primary key build

You're right - it is a data related issue. I finally made it work with the live data on high speed but in a way that puzzles me. Do you know the explanation ? (I'm using mySQL 4.1.1a-max-nt on Win2K) The index of the primary key is using the same data set (content and size) for both the test and

4.1.2 myisamchk chokes on a fulltext

Hi. I'm having this problem on 4.1.2, when I run myisamchk -o on my table I get a bunch of these lines: Duplicate key 3 for record at 56134200 against new record at 244828223 then it segfaults. key 3 is a fulltext. I tried the same thing on the same data with 4.0.14 and it worked fine, I

Re: Select double value

Paul McNeil wrote: Good morning to all. I have a problem with a workaround but I wanted to know if others have run into this. Are you sure the problem is with mysql? If so, which version do you have? I have 4.0.20, and I get different (expected) results. Table DATA Column strength [double]

Re: Stop query on first match

This doesn't quite make sense. You seem to say that several rows will match but then you say only one will. It must be one or the other. Perhaps I've misunderstood you. You also seem to imply that with BETWEEN you get a full table scan even though there is only one match for each row. That

mysqldump causes slave to stop

Hello, I am dumping a single innodb DB using mysqldump. Everytime I do it, it crashes the slave thread. Below are the commands I'm using to dump [I also have tried --delete-master-logs command in the actual data dump too (second line) with the same problem.] I am willing to hear advice on the

Re: [mysql-php] mysqlimport error

is that a problem? I want to avoid ftp db.txt files and then mysqlimport them - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 4:38 PM Subject: Re: [mysql-php] mysqlimport error nikos [EMAIL PROTECTED] wrote: I'm trying

Re: Select double value

Paul McNeil wrote: Thank you very much for the response. According to MySQL Control Center the MySQL DB I am connecting to is version 4.0.17. Possibly that is the problem. You'll get quicker (and, on average, better) responses if you keep the thread on the list. I have mysql 4.0.17 running on

Fwd: Comma Delimited Import Error

On Jun 5, 2004, at 11:40 PM, David Blomstrom wrote: Here are a few rows from the comma delimited file I imported. Do you have a hunch what might be going on here? Thanks. gd,oat,239,,Grenada,nat gp,oat,240,,Guadeloupe,dep ht,oat,241,,Haiti,nat is,oat,242,,Iceland,nat jm,oat,243,,Jamaica,nat Do you

Re: Asterisks in Integer Columns

David, Daniel is exactly right. In general, it is not a good idea to try to cram two pieces of data into one column. Your questions at the end of your post are good examples of why you don't do it that way. With a population column and a separate population_note column, you can easily answer

GRANT PRIVILEGES doesn't perform the way I expect it to....??

I'm having a little trouble with granting the correct privilege to the user with one database instead of all databases. When I do this with all databases, it work great.. --snip-- //Issued SQL Command... GRANT ALL ON *.* TO 'Username'@'localhost.domain.com'

RES: GRANT PRIVILEGES doesn't perform the way I expect it to....? ?

Hi Scott, Really in user table not modify nothing, but in db table the privileges appear ok. Your user get message of access denied? Regards, Renato Cramer. -Mensagem original- De: Scott Fletcher [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 7 de junho de 2004 17:29 Para: [EMAIL

Re: error 2013 : Lost connection to MySQL server during query

Ok, it seems I fixed my problem before anybody was available to help me. The error was due to bad code -- the program was trying to send multiple queries through the same connection. Even though it was compiled as thread safe, you still have to find some way to prevent concurrent queries on

RE: DELETE from more than one table

At 14:01 + on 06/07/2004, shaun thornburgh wrote about Re: DELETE from more than one table: Hi Paul, Thanks for the reply. I actually need to delete data from about 10 tables, is this possible? If the field in the tables is defined as a Foreign Key (with ON DELETE CASCADE), deleting the

Re: OT: Errors from Extra Spaces in Spreadsheets

At 22:33 -0700 on 06/06/2004, David Blomstrom wrote about OT: Errors from Extra Spaces in Spreadsheets: I've been having a tough time importing comma-delimited files into my database tables. I just discovered that most of the errors are similar to this one: 060 is not a valid integer value I

mysqldump causes slave to stop

Hello, I am dumping a single innodb DB using mysqldump. Everytime I do it, it crashes the slave thread. Below are the commands I'm using to dump [I also have tried --delete-master-logs command in the actual data dump too (second line) with the same problem.] I am willing to hear advice on the

Re: Production release of MySql 4.1

Emmanuel van der Meulen wrote: Hello all, Does anyone have an estimate of when MySql 4.1 will be released for production. MySql.cm says soon. Please advise, would that likely be weeks/months? Kind regards Emmanuel Months. I'd say at least 6 months. -- Daniel Kasak IT Developer NUS Consulting

Problems maintaining large high-availability search

I have been maintaining a mod-perl/MySQL4 web search engine with about 3M records, which gains and drops about 100k records daily. It runs on a dual-Opteron 242 system with 8GB RAM, 15k SCSI driv, SUSE Professional for AMD64. It recently grew to this size (from about 1M records), and I am

Re: Problems maintaining large high-availability search

Hi, 1. The timeout is set to 5 min, because of the number of queries, there are a lot of unused http processes that linger with connections, and the only way to seeminly keep MySQL connections available is to keep timeouts short. What about using a connection-pool? Like Apache::DBI. It should

Idea to speed up multiple jdbc connections?

Hi, I would appreciate any help on this: I got approximate same timing on following two: case 1: create 1 jdbc connection and issue 4 queries sequentially case 2: create 4 jdbc connections and issue 4 queries via 4 different threads at the same time The timing is done around

RE: Problems with MySQL 4.0.20

Thank you very much for your bug report! And sorry if I doubted your report at the beginning; I hadn't thought of the rpm script. No problem. I sometimes get bug reports that I know are impossible! Yet they weren't. This one I would have barely noticed if it had not knocked the slaves all

RE: Problems maintaining large high-availability search

1. The timeout is set to 5 min, because of the number of queries, there are a lot of unused http processes that linger with connections, and the only way to seeminly keep MySQL connections available is to keep timeouts short. What about using a connection-pool? Like Apache::DBI. It

RE: Idea to speed up multiple jdbc connections?

AFAIK, creation of connection from DB is expensive. This is one of the reasons why we need connection pooling. Best Regards, Jonathan Chiu OOCL Logistics Unit 1, 4/F., Sun Hung Kai Centre, 30 Harbour Road, Wanchai TEL: 852 . 2990 0174 FAX: 852 . 28249017 -Original Message- From: Haitao

delete record that passed 1 day

Hi all, I have mysql table that has a field named 'crea_dt' (it records the creation date of data)... I want to delete records that have passed for more than a day description like this : if now()-crea_dt 0 then delete But I just can't find the suitable mysql command for this function.

Re: Idea to speed up multiple jdbc connections?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: AFAIK, creation of connection from DB is expensive. This is one of the reasons why we need connection pooling. Jonathan, While that might be true for other databases, it's not true for MySQL (connections are a few ms.

Re: delete record that passed 1 day

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 07 June 2004 08:36 pm, starofframe wrote: description like this : if now()-crea_dt 0 then delete select date_sub(crea_dt, interval 1 day) - -- If you're like me, and I know *I* am... -- Joel Robinson -BEGIN PGP SIGNATURE-

Re: delete record that passed 1 day

Hi Jeff, you mean I can use sql like this DELETE FROM table where date_sub(crea_dt, interval 1 day) thanks a lot Sukanto - Original Message - From: Jeff Smelser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 8:55 AM Subject: Re: delete record that passed 1 day

Re: delete record that passed 1 day

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 07 June 2004 09:25 pm, starofframe wrote: Hi Jeff, you mean I can use sql like this DELETE FROM table where date_sub(crea_dt, interval 1 day) Add: crea_dt - -- Anything worth fighting for is worth fighting dirty for.

Re: delete record that passed 1 day

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 07 June 2004 09:22 pm, Jeff Smelser wrote: On Monday 07 June 2004 09:25 pm, starofframe wrote: Hi Jeff, you mean I can use sql like this DELETE FROM table where date_sub(crea_dt, interval 1 day) Add: crea_dt Could be .. Damn,

Re: delete record that passed 1 day

Yes, I did found out just now... but delete from table where date_sub(crea_dt, interval 1 day)crea_dt should delete all data right??? All I want is compared to date_now eg : now is 2004-6-8 and all I want to delete is data that hav passed 1 or more days... such as L 2004-6-7,2004-6-6,

Re: delete record that passed 1 day

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 07 June 2004 10:03 pm, starofframe wrote: but delete from table where date_sub(crea_dt, interval 1 day)crea_dt should delete all data right??? All I want is compared to date_now eg : now is 2004-6-8 and all I want to delete is

mysql memory optimization - AMD 64 - odd crashes

I just started setting up a dual opteron system with Suse 9.1 (x86_64). At this point, I am sticking with the Suse provided rpms. I am having some odd mysql restarts (crashed with immediate restart by safe_mysqld). Odd part about it: not a single line in the error log. The connections just drop

Re: Idea to speed up multiple jdbc connections?

Yes. The time I measure like I said is purely around statement.execQuery() call. Connection creation is not a factor here at all. My database has 1.64 million rows and 4 queries are all selects, which are identical in both serial and parallel cases. In serial cases: Query 0 took 590 Query 1

Re: delete record that passed 1 day

Jeff Smelser wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 07 June 2004 10:03 pm, starofframe wrote: but delete from table where date_sub(crea_dt, interval 1 day)crea_dt should delete all data right??? All I want is compared to date_now eg : now is 2004-6-8 and all I want

RE: Idea to speed up multiple jdbc connections?

Oppz! Sorry for overlooking your timing method. In this case, I believe if you run the query in four different machines at the same time, the statistics should almost the same as running four consecutive queries in the same machine. I believe the multi-threading implemented in the JVM and the OS

Re: delete record that passed 1 day

Thanks a lot Mike... what's a clear explanation... Actually I have used WHERE crea_dt + interval 1 day curdate() before I read ur reply ...but now I guess I better change it to WHERE crea_dtcurdate-interval 1 day again thanks a lot... and thanks to Jeff too. Sukanto -- MySQL General Mailing

Re: Idea to speed up multiple jdbc connections?

On Mon, 7 Jun 2004, Haitao Jiang wrote: Yes. The time I measure like I said is purely around statement.execQuery() call. Connection creation is not a factor here at all. My database has 1.64 million rows and 4 queries are all selects, which are identical in both serial and parallel cases.

Re: delete record that passed 1 day

starofframe wrote: Thanks a lot Mike... what's a clear explanation... You're welcome. Actually I have used WHERE crea_dt + interval 1 day curdate() before I read ur reply ...but now I guess I better change it to WHERE crea_dtcurdate-interval 1 day That's probably just a typo, but just in case,

mysqld_multi

Hi, Can someone tell me how I can use mysqld_multi to have one RPM installation of MySQL(default with RedHat9) to run multiple mysqlds? Thanks -Minuk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Boolean mode, Fulltext,utf8

Hi All! Does works fulltext index on utf8 columns on boolean mode correctly on MySql 4.1.2 ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

myisampack, check: already compressed ?

Hello * Question: Is there a (cheap) way to find out if a MyISAM Table is already compressed, before running a myisampack on it ? Goal: -In a script that regularly compresses Tables i'd like to check before packing. In case the script has previously been started and already done the

Production release of MySql 4.1

Hello all, Does anyone have an estimate of when MySql 4.1 will be released for production. MySql.cm says soon. Please advise, would that likely be weeks/months? Kind regards Emmanuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Configure MySQL on Jboss 3.2.3

Does anyone know how to configure MySQL on JBoss 3.2.3? This is what I have done: (i) copy /jboss3.2.3/docs/examples/jca/mysql-ds.xml to jboss3.2.3/server/default/deploy/ where ECPerfDS is the dtabase jndi name: ++ datasources local-tx-datasource

innoDB

Hi, Anybody know how do I know if innoDB is enabled? I have MySQL 3.23 installed. The MySQL document says the simplest way to install MySQL-Max is to replace the executable mysqld server with the corresponding executable from the MySQL-Max distribution. Where can I get the mysqld of MySQL-Max?

Re: innoDB

[EMAIL PROTECTED] wrote: Anybody know how do I know if innoDB is enabled? SHOW VARIABLES LIKE have_innodb; If InnoDB is enabled, you will see 'YES' in the output. I have MySQL 3.23 installed. The MySQL document says the simplest way to install MySQL-Max is to replace the executable

Re: FreeBSD 5.x

Hi. SQL I use mysql-4.0.X under FreeBSD-5.2.1 There is no problem with libc_r. But under heavy loading with kse mysqld doesn't shutdown. This problem isn't only with kse. It was discussed some weeks ago. And if I remember it is exist with any other pthreads and under linux too. With kse mysql do

Can't start server: Bind on TCP/IP port: Address already in use

Hi! I have restarted the Linux server. Typing mysqld result: 040607 11:32:47 Can't start server: Bind on TCP/IP port: Address already in use 040607 11:32:47 Do you already have another mysqld server running on port: 3306 ? 040607 11:32:47 Aborting 040607 11:32:47 mysqld: Shutdown Complete

key_buffer or key_buffer_size

Hi, Can somebody tell me if 'key_buffer' and 'key_buffer_size' are the same variables ? Perhaps it is just a question of syntax, I mean, in the my.cnf you write key_buffer=100M or you write set-variable = key_buffer_size=100M Same question for sort_buffer and sort_buffer_size, thread_cache

URGENT !! InnoDB Constraint problem !

i dont have that section in my status report (ill tried it before) here's the report *** 1. row *** Status: = 040607 10:04:41 INNODB MONITOR OUTPUT = Per second averages

Spatial extensions and GIS

Hi. This may be a daft question, so forgive me: I am just starting out with the Spatial extensions and I am wondering how I can use it to determine the distances between any 2 landmarks that have been entered as POINTs in the database. The POINTs are entered with longitude and lattitude

AW: Can't start server: Bind on TCP/IP port: Address already in use

Hi Tobias Got the same problem on my local machine. Try @ps -aux And kill all mysql stuff manually Worked for me Cheers jan -Ursprüngliche Nachricht- Von: Tobias Bohlin [mailto:[EMAIL PROTECTED] Gesendet: Montag, 07. Juni 2004 11:30 An: [EMAIL PROTECTED] Betreff: Can't start server:

Re: [MySQL] Can't start server: Bind on TCP/IP port: Address already in use

Tobias Bohlin wrote: I have restarted the Linux server. Typing mysqld result: 040607 11:32:47 Can't start server: Bind on TCP/IP port: Address already in use 040607 11:32:47 Do you already have another mysqld server running on port: 3306 ? 040607 11:32:47 Aborting You don't ever start

RE: Can't start server: Bind on TCP/IP port: Address already in use

You are only listing processes owned by you. ps -e will show all processes, add -f for a full listing. -Original Message- From: Tobias Bohlin [mailto:[EMAIL PROTECTED] Sent: 07 June 2004 11:30 To: [EMAIL PROTECTED] Subject: Can't start server: Bind on TCP/IP port: Address already

My first post!

Hello guys, I'm new with MySQL and i'm facing problem with the installation! I've Windows XP pro and when i install MySQL(mysql-4.1.2-alpha-win) it work but when i try to connect or even open mysqladmin.exe it works but not in windows mode it only work in command mode! Also when i tried to

ANN: Advanced Data Generator 1.1.0 released

Dear ladies and gentlemen, Upscene Productions is happy to announce a new version of the database developer tool: Advanced Data Generator (version 1.1.0) A fast test-data generator tool that comes with a library of real-life data, presets and much more. This new release consists of four

Multiple locks

I need to do some operations which insert mass amounts of records which then must be sorted, and would like to use table locking. The flow I'm looking for is: LOCK TABLE A WRITE LOW_PRIO DELETE FROM TABLE A (This used to be TRUNCATE TABLE A, but that complained when I started locking) LOAD DATA

Re: Errors from Extra Spaces in Spreadsheets

David: Microsoft has a converter for Works files at http://www.microsoft.com/downloads/details.aspx?FamilyID=b9e11e83-f51b-4977-b572-8c042df802c1displaylang=en I did'nt see any online documentation HTH, Martin - Original Message - From: David Blomstrom [EMAIL PROTECTED] To: [EMAIL

Re: mySQL daemon fails after setting root password

Jesse [EMAIL PROTECTED] wrote: anyone know why the mysql daemon fails to start after I set the root password according to this: http://dev.mysql.com/doc/mysql/en/Default_privileges.html I use the command: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd'); SET PASSWORD FOR

DELETE from more than one table

Hi, Is it possible to DELETE from more than one table in one command? Thanks for your help _ Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/ -- MySQL General Mailing List For list

Select double value

Good morning to all. I have a problem with a workaround but I wanted to know if others have run into this. Table DATA Column strength [double] When I select strength from DATA and the result is a non zero amount it returns correctly 3.256498 however if it is a 0 amount I get 0. The