Re: Query Error

) NOT NULL default '', rei_ip varchar(64) NOT NULL default '', rei_ts datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (rei_aid), KEY rei_ip (rei_ip) ) ; -Wash -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax

Re: MySQL++ hates me

: libmysqlclient.so.10: open failed: No such file or directory Killed ** You simply need the mysql-client. Because the API uses the libmysqlclient.so LIB dynamically. Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109

Re: mysql LIKE number

adi wrote: I have a table with column1 text type. I want to make a sql query: SELECT * from table WHERE column1 LIKE condition, to select all record that contain numbers(0..9), and do not select records that contain only text. Any ideas? tx in advance column1 REGEXP [0-9] -- Ralf Narozny

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

; system(cmd); } # chmod mailsend 700 mailsend the_file (BTW: in the above example might be syntax error, because I did not test it ;-) ) Greetings Ralf -- Ralf Narozny Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten- management oder das komplette Office ins Portal

Re: which version to use?

... ;-) Anil Garg wrote: hi What version combinations of mysql and php should be used? regards anil -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: MySQL Backup

Flush tables: 1 Open tables: 59 Queries per second avg: 35.492 Greetings Ralf -- Ralf Narozny Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten- management oder das komplette Office ins Portal einbinden? Wir zeigen es Ihnen - vom 3. bis 5.9. auf der Messe Essen Halle 3, Stand 3255

Re: Query problem in Perl

); while ($sth-fetch()) { print Record: $dnsrecord_id \n; } } $sth-finish(); Greetings Ralf -- Ralf Narozny Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten- management oder das komplette Office ins Portal einbinden? Wir zeigen es Ihnen - vom 3. bis 5.9. auf

Re: Replication

found your slave status is a little not normal to me :D as long as what you need is working, then everything is ok ;-) -- Let's call it an accidental feature. -- Larry Wall MySQL 3.23.51 : up 73 days, Queries : 357.245 per second (avg). -- Ralf Narozny Besuchen Sie uns auf der DMS

Re: granting grant option creates a (new) user ?!

to administer Sounds evil indeed, how about giving grant rights and revoking insert rights for mysql.users mysql.db and mysql.table? Greetings Ralf -- Ralf Narozny Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten- management oder das komplette Office ins Portal einbinden? Wir zeigen es

Re: Replication

has no column of the name 'status' -- Ralf Narozny Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten- management oder das komplette Office ins Portal einbinden? Wir zeigen es Ihnen - vom 3. bis 5.9. auf der Messe Essen Halle 3, Stand 3255 SPLENDID Internet GmbH Co KG Skandinaviendamm 212

Re: Double Join

-- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http

Re: How to speed up slow query from OR

'; or select something from table where index2 = 'value'; Does it have a compund index, created like this: CREATE INDEX myindex ON table (index1,index2); ??? Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431

Re: Linux Installation (make) problem

specified and no makefile found. Stop. [root@neelsl mysql-3.23.51-pc-linux-gnu-i686]# make install make: *** No rule to make target `install'. Stop. What is the problem, I am following the instructions provided in the manual.txt. I am new to this. Greetings Ralf -- Ralf Narozny

Re: Sql Create a column the multiple of two other columns

via DEFAULT, since DEFAULT has to be constant and since there are no triggers by now, try: INSERT INTO table VALUES (a,b,a*b); Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL

Re: Changing existing column data type question

don't want to loose any of my current data in this column. Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: Facing some problem in installation

resides) Greetings Ralf sql query -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: Need help with Tables/Attributes

; ALTER TABLE test DROP COLUMN Name; Greetings Ralf sql query -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: inner join query don't work

at that query ;-) Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting

Re: Joins, ANSI 92 or the old way

sql sql sql query query query query query query query query query query query P.S.: Damn filter! -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: question about varchars

. For example storing the zipcodes from more than one country might need at max 15 characters, so why allowing 255, preventing MySQL to raise an error, if the ZIP is 100 chars long. Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660

Re: Splitting textarea values to put into a database

','Fish') Greetings Ralf sql, query -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: Performance Problem - LEFT JOIN

data and it consumes 100% of processor. This situation happens when I have all tableA.id registered on tableB.ida or tableC.ida. Any ideas? Of course you have indexes on all of the id, idA, idB columns? Greetings Ralf sql, query -- Ralf Narozny SPLENDID Internet GmbH Co KG

Re: Facing some problem in installation

-- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http

Re: SQL Syntax (May be OT)

the field. WHERE field LIKE '%keyword%' maybe WHERE upper(field) LIKE upper('%keyword%') Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: compiling mysql 3.23.37

://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ralf Narozny SPLENDID Internet

Re: Selecting from one table to UPDATE another.

Table1 t1 LEFT JOIN Table2 t2 ON (t1.Old_UserID = t2.UserID) WHERE t2.UserID IS NOT NULL ; \. /tmp/update.sql This might help...but better take a look at /tmp/update.sql, before executing it!!! Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel

Re: Select Problem

-- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http

Re: undo command from mysql prompt

] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: Incorrect GRANT syntax messes up user.* and crashes Mysqld

://lists.mysql.com/php/unsubscribe.php -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before

Re: Problem accessing a DB!

? that would explain why $dbh-prepare() would not work. I don't know why this is happening, although I have read as much as I could fine on the net regarding this subject. I'd be grateful for any help. Thanks, -T -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel

Re: Incorrect GRANT syntax messes up user.* and crashes Mysqld

/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0

Re: undo command from mysql prompt

] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: Select Problem

-- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http

Re: Problem accessing a DB!

the CGI on the same server as the MySQL is running? And maybe change the line: $dbh = DBI-connect($connectionInfo,$userid,$passwd); to: $dbh = DBI-connect($connectionInfo,$userid,$passwd) or print Connect failed; Maybe you get the info then. Ralf Narozny wrote: Hello! Troy Hickey wrote

Re: Problem accessing a DB!

? that would explain why $dbh-prepare() would not work. I don't know why this is happening, although I have read as much as I could fine on the net regarding this subject. I'd be grateful for any help. Thanks, -T -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon

Re: Create DataBase tabe for a user

question, but you issued 'CREATE DATABASE poll;'? Greetings Ralf sql , query -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: MySQL Privileges Question

://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon

Re: backup

Module (iirc) which indicates that you need Perl DBI Module for mysqlhotcopy. Greetings Ralf sql , query -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: Table types in replication

them down and point allupdating clients to the new database machine. Any comments ? Converting the tables in situ is painfully slow - a couple of days I suspect. Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0

Re: MYSQL Problem (Will not write to but will read)

archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49

Re: pulling information from 2 tables based on information from firstselect

[EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED

Re: UPDATE command..

] | +--+ How about: UPDATE table SET id = concat(left(id, locate(id, '@')), 'domain2.com') WHERE domain = domain1.com; -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED

Re: Calculating rows in a result set

be a better way to do it, isn't it? No way! Should the database guess on it? ;-) SELECT count(*) FROM ... WHERE ...; Just like your query looks like is the only way. -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660

Re: Interesting

-- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http

Re: Help - query suggestion needed - interesting case

event_id, count(DISTINCT time) AS Ranges FROM events GROUP BY event_id HAVING Ranges 1 How about SELECT event_id, time FROM events GROUP BY event_id, time HAVING count(*) 1 ; ??? -- Ralf Narozny SPLENDID Internet GmbH Co KG

Re: character occurrence count in MySQL

/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax

Re: Help - query suggestion needed - interesting case

-- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check

Re: Remote entry

, is there any options so that the same entry is made in the remote machine mysql db If there is any option pls. let me know Thanx in advance -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED

Re: Mass Delete

echo DELETE FROM churchmail WHERE email = '$EMAIL'; ; done | mysql midtn that was it...pretty easy isn't it? That's why I really love Linux :-) Greetings Ralf sql query -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431

Re: Mass Delete

Using Linux/Unix I'd say: echo SELECT concat('DELETE FROM mailtab WHERE mailaddress=',mailaddress,';') FROM mailtab WHERE some strange conditions here | mysql db | mysql db [EMAIL PROTECTED] wrote: I have about 40,000 email addresses in a MySQL database. I also have a list of 1500 email

Re: how to limit the cpu usage in MySql

again of having googlebot or other web robots interrupt my other server operations in my computer. Thank you Edwin sql query -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http

Privileges needed to execute PURGE MASTER LOGS

Hello! The subject says it all: What rights does a user need to have (minimal rights of course) to be able to execute PURGE MASTER LOGS command? Thanks in advance Ralf For the poor little filter: sql query -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel

Re: I can login to mysql as root but not as any other user...

(the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ralf Narozny Splendid Internet GmbH Skandinaviendamm 212

Re: SubQueries and Temp Tables

and the inner table. Is this advisable.. Any other better options? -- Ralf Narozny Splendid Internet GmbH Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: Unions

alternates.. Regards, -Arul -- Ralf Narozny Splendid Internet GmbH Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting

Re: subquery in delete

SELECT concat('DELETE FROM order WHERE order_no=', order_no, ' LIMIT 1;') FROM order GROUP BY order_no HAVING copunt(*) 1 | mysql -N -u user database | mysql -N -u user database That does the trick, IMHO nice and very easy. Greetings Ralf -- Ralf Narozny Splendid Internet GmbH

Re: environment variable ...

a .my.cnf. what do I have to write in the ~user/.my.cnf to use completion ? I tried in the [mysql] section: auto-rehash rehash Solution: simply delete the line 'no-auto-rehash' and you are done. Greetings Ralf -- Ralf Narozny Splendid Internet GmbH Skandinaviendamm 212, 24109 Kiel

Re: Help needed with JOIN on 3 tables

names from builder which have any business given. Greetings Ralf -- Ralf Narozny Splendid Internet GmbH Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: delete corrupts

. delete from table where expression limit 1; would only delete one of the rows at least in 3.23.40+ it does :) -- Ralf Narozny Splendid Internet GmbH Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de

Re: How to write output of sql stmt to file

Jay Blanchard wrote: [snip] I am trying to get only records out of a table mathing a query. This should be piped into a textfile. My problem is that I have to transmit this records to a new machine. So the output should be a kind of sql commands which I could run with phpadmin or similar to