Deleting a database in Mysql

2003-02-06 Thread Calvin Lam
Hi, I am a newbie with this and I need help with Mysql How can I delete a database in Mysql thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

autoincrement field problem with BCB6

2003-02-06 Thread Kaspars Vilkens
Hallo list! I have an autoincrement field (+others of coarse) in myISAM table. When I try to insert values with queries everything works fine, but when I try to do it with Borland C++ builder 6's TSQLClientDataSet (dbExpress) it throws an exception that the field's value must be set. It continues

Re: Problems with INNODB in MySQL 4.0.6-gamma

2003-02-06 Thread Csongor Fagyal
Kees Hoekzema wrote: Hello, On Tuesday 04 February 2003 14:46, Grover Cussi N. wrote: restore to the original size ?, I see that the tendence of the innodb tables is to grow, and grow, and never will reduce the size, it is posible to control this? I had the same problem, it went on

working around lack of subselects

2003-02-06 Thread Andy Smith
Hi folks, I have a problem that normally I'd want to use subselects on. Here it goes: Table t1 has a column data_id. Table t2 has a column data_id. Both are foreign keys for the autoincrement primary column id of the table called data. I wish to delete every row from data which is NOT

sql_big_selects

2003-02-06 Thread Dallas Engelken
i have a datbase of about 1.5 million log entries that i want to search based on subject (not indexed because it's seldom used). when i try, i get a fatal warning that i cant seem to kick. i have rtfm, and changed max_join_size=200 in my.cnf to hopefully make it run without the fatal

Re: Opposite selection...

2003-02-06 Thread Brent Baisley
I think you are coming from the wrong angle. If you want the opposite, you should reverse your approach. Select all the names in the projects table, match them with names in the contacts, then filter it so you only have the ones without a match. SELECT p.name,p.company FROM projects p LEFT

RE: MSSQL Transactional Replication to MySQL

2003-02-06 Thread Jonathan Bedford
Hi My DBA has created a DTS package that works between two MS SQL machines, successfully adding characters at either side of the source data on the publication. However, we have a problem when trying to replicate to MySQL. If we check the transform data box when creating the SQL Server

SELECT with DATE

2003-02-06 Thread Stephen of Blank Canvas
Can anyone point me in the right direction for finding a method of only creating a query that selects records from a dB where today's date is less than the column 'expire', which is in DATE format. The purpose of this is to automatically stop display special offers. Thanks Stephen

RE: Replication question

2003-02-06 Thread RAHARD Matthieu
Hello everybody, Is it possible to set up this kind of replication and what parameters I have to set in the my.cnf file ? Table A own by server A and replicated to server B and C Table B own by server B and replicated to server A Table C own by server C and replicated to server A The mysql

Re: proposal: new back end tailored to data mining very largetables

2003-02-06 Thread Heitzso
I appreciate everyone's suggestions. I wasn't aware of the MERGE table variation (wasn't in my large mysql book) nor of some of the file IO optimizing aspects of INNODB. Re INNODB's ability to return just the fields needed ... ??? I looked via GOOGLE and also dug around in the doc at the

Re: Applications for creating reports for MySQL

2003-02-06 Thread Joshua J . Kugler
How much work do you want done for you? Perl and Python are great apps for writing MySQL reports, and you can output all the report to a text file, which would be great for a reader. But as report applications, can't help you there. Sorry. j- k- On Tuesday 04 February 2003 09:10,

Re: Using SET in the INSERT statement

2003-02-06 Thread Keith C. Ivey
On 5 Feb 2003, at 14:19, boclair wrote: I notice some of my colleagues using SET in INSERT statements. DuBois makes a short reference on p565, DoorStop1. The Manual has some mention in http://www.mysql.com/doc/en/SET.html You seem to be confusing two unrelated meanings of SET. The SET

Re: insert after delete is not atomic

2003-02-06 Thread Brent Baisley
This doesn't directly address the problem you are having, but it probably is a better way of doing it. Have you looked into using the REPLACE function instead of a delete and insert. It should be faster and more reliable. I assume since you are using the ignore statement in your insert that

Regular Expressions

2003-02-06 Thread Darren Young
I've looked through the mysql manual for information on regualar expressions, and all that it seems to have are references such as: SELECT fo\nfo REGEXP ^fo$; How can the REGEXP be applied to a 'SELECT field FROM table' kind of statement? Thanks, Darren Young mysql,query

RE: need help with GROUP BY

2003-02-06 Thread Tab Alleman
SELECT id,account FROM tablename WHERE detail LIKE '%pattern%' GROUP BY Account; -Original Message- From: Jaime Teng [mailto:[EMAIL PROTECTED]] I have a MySQL table: ... It should only return *one* result per account.

Re: Is it my English or does this sound bad?

2003-02-06 Thread Jeremy Zawodny
On Wed, Feb 05, 2003 at 03:58:21PM +1300, Defryn, Guy wrote: I was just reading through the Mysql manual section 3.32 And came across a sentence that started like this Animal sex can be represented in a variety of ways My mother tongue is not English but doesn't it sound rude ? :-)

Re: MySQL IMAP Server

2003-02-06 Thread Paul DuBois
At 17:26 + 2/4/03, Ben Clewett wrote: MySQL, My first post, please go easy if this is the wrong pleace! I'm trying to find an IMAP server which used MySQL so that my Mozilla Email client can file it's email a little faster. Has anybody heard of such a device? I believe the Horde IMP

1 column - 2 column join optimisation

2003-02-06 Thread James Pharaoh
Hi, I'm trying to optimize the following query: SELECT * FROM user LEFT JOIN history ON user.userid = history.touserid OR user.userid = history.fromuserid WHERE user.state = 'ready' GROUP BY user.userid This causes a full table scan on the second table. If I do the following however the index

Re: insert after delete is not atomic

2003-02-06 Thread gerald_clark
You are inserting 6 values into 7 fields, so it fails. You don't see the failure because you are doing an insert ignore. You are also inserting numbers with 4 digits right of the decimal, where you have specified 2. Mudit Wahal wrote: Description: I have a delete statement and an insert

query produces a navigation

2003-02-06 Thread Andrew Maynes
I have a set of records in a mysql table that are called categories. A query pulls all the records for category and in turn this are then links to items of that said category. Simple. Ok here is the bit I want some feeback on. I want to create another table (if this is the solution) and split

Re: Is it my English or does this sound bad?

2003-02-06 Thread Paul DuBois
At 15:58 +1300 2/5/03, Defryn, Guy wrote: I was just reading through the Mysql manual section 3.32 And came across a sentence that started like this Animal sex can be represented in a variety of ways My mother tongue is not English but doesn't it sound rude ? :-) Yes, it does, and current

Re: encrypted password

2003-02-06 Thread Jerry M. Howell II
On Tue, Feb 04, 2003 at 02:58:28PM -0500, Jianping Zhu wrote: I have mysql in a redhat machine. I need to use mysql do user authentication to a website. I have a table like following. +--+--+ | username | passwd | +--+--+ | jianping | jian1830 | |

Re: Is it my English or does this sound bad?

2003-02-06 Thread Doug Thompson
I love it!!! 8-)) You are correct that it does sound a bit rude, even when English is your first language and you stop to think about it. However, what the statement means is identical to The sex of the animal can be represented... and it is acceptable grammar. Thanks for making my day. Doug

Re: Is it my English or does this sound bad?

2003-02-06 Thread Kevin Smith
I guess it depends on if you have a dirty mind, or, you just ignore it and understand the point of the example. ;) lol But yeah, could have been worded slightly different. Kevin - Original Message - From: Defryn, Guy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 05,

RE: Opposite selection...

2003-02-06 Thread Jennifer Goodie
A Left join using IS NULL will work. You can get the syntax and see an example in the manual http://www.mysql.com/doc/en/JOIN.html From the maunal... If there is no matching record for the right table in the ON or USING part in a LEFT JOIN, a row with all columns set to NULL is used for the

apostrophe and comma error on submit

2003-02-06 Thread ahimsa
Does anyone know about an error that occurs when you try to submit into mysql. Whever i try to imput any text with a comma in it or an appostrophe, i get an error until i remove it. Any suggestions. .. anyone...? Im using php and submiting via post, when i get the error. Thank you so much

RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)

2003-02-06 Thread Tue Tønning
Hey, I have discovered a strange error in the mysql versions mentioned in subj. Example. A table with 10 entries ...i want to draw 3 randomly = select fieldName from tableName order by RAND() limit 3 this have worked for the last year or so.but after upgrading our redhat 7.2 with mysql

RE: Percentile calculations

2003-02-06 Thread Adam Nelson
I believe you can do: select avg(scantime) from percentile; select std(scantime) from percentile; std() is the same as stddev() which finds the standard deviation. If the scantimes are gaussian (pretty good assumption if it's a large dataset), then the 95th percentile will be avg() +

Re: Is it my English or does this sound bad?

2003-02-06 Thread Zak Greant
On Wed, Feb 05, 2003 at 03:58:21PM +1300, Defryn, Guy wrote: I was just reading through the Mysql manual section 3.32 And came across a sentence that started like this Animal sex can be represented in a variety of ways My mother tongue is not English but doesn't it sound rude ? :-) Heh.

Re: encrypted password

2003-02-06 Thread Johannes Ullrich
the easiest way to do this is to use mysql's own 'password' function. to add a new user use: insert into table (username,passwd) values ('jianping',password('jian1830')) to validate the password: select count(*) from table where username='jianping' and passwd=password('whatwasentered'); or

RE: Using SET in the INSERT statement

2003-02-06 Thread Jennifer Goodie
Are you referring to the data type SET or the Command SET? The manual page you point to is talking about the data type, but usually when seen in an insert it is the Command. I can't recall seeing the datatype referred to in an INSERT, but maybe my brain isn't fully on yet today.

RE: insert after delete is not atomic

2003-02-06 Thread Jennifer Goodie
This is probably a dumb question, but are you running all the queries in eod_stocks? I ran all the queries and they worked fine. I undotted the select though because my database was not called eod_stocks. Since you did not include the part where you select the database to run these queries in,

Re: Re: host.frm

2003-02-06 Thread Paul Roskilly
Thank you. I have set up the grant tables though but it still doesn’t work. I thought it might be because the daemon isn’t been run as mysql user, but when I try and do : /usr/bin/safe_mysqld user=mysql like it says in the manual, I get an entry in the log file saying that there are too many

Re: need help with GROUP BY

2003-02-06 Thread Frank Peavy
Jaime, You should be using the DISTINCT function. SELECT DISTINCT account, id, FROM etc. This should give you one instant of 'account' in your SELECT output. At 09:24 AM 2/5/03 +, Jaime Teng wrote: I have a MySQL table:

Innodb Foreign Key Problems.

2003-02-06 Thread Scott Wong
Hi. Simple parent/child table generates some weird output based on the order possible bug? Mysql 3.23.54 CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES

innodb

2003-02-06 Thread DIB Walid
I have a small probleme with MySQL in 3.23.55. I do not manage to create my tables under the format InnoDB by specifying the type of creation at the end of the command. Thank you in advance - Before posting, please check:

Data being not inserted in the table inspite of success from mysql

2003-02-06 Thread mwahal
Description: I'm adding the data in the tables via batch mode. I see that the sql INSERT statement returns success. But when I query the data, I get empty set. How-To-Repeat: -- create table if not exists CBI (date DATE not null, close DECIMAL(10,2),

Please IGNORE my previous bug report. Script errors.

2003-02-06 Thread mwahal
Description: Please IGNORE my previous bug report. I had another script which was deleting the data. Stupid user error. How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Mudit Wahal Organization: MySQL support: [none | licence | email support |

RE: What are the best MySQL and PHP resource books?

2003-02-06 Thread Loren McDonald
Thanks again to everyone who replied! I finally decided on: MySQL - Second Edition Professional PHP Programming - Second Edition After all the responses here and the feedback through the online bookstores, those are what I'm after. -- Loren McDonald [EMAIL PROTECTED] -Original

Re: need help with GROUP BY

2003-02-06 Thread Frank Peavy
Jaime, You should be using the DISTINCT function. SELECT DISTINCT account, id, FROM etc. This should give you one instant of 'account' in your SELECT output. At 09:24 AM 2/5/03 +, Jaime Teng wrote: I have a MySQL table:

Re: Replication question

2003-02-06 Thread Jeremy Zawodny
On Wed, Feb 05, 2003 at 10:37:29AM +0100, RAHARD Matthieu wrote: Hello everybody, Is it possible to set up this kind of replication and what parameters I have to set in the my.cnf file ? Table A own by server A and replicated to server B and C Table B own by server B and replicated to

RE: MySQL 4.0.10 is released

2003-02-06 Thread Dan Rossi
this is exactly what i am asking , when u say new gamma development release (use this for new development) what does it all mean , is it stable for production use ? i would like to know to convince work to start using it ? -Original Message- From: Lenz Grimmer [mailto:[EMAIL PROTECTED]]

Can mysql execute this ? how can i do this ?

2003-02-06 Thread Narciso Miguel Rodrigues
Is this possible select nome from categorias where id_categoria in (select id_categoria from categoriamembro where id_membro=1807) in MySQL Thks [MsR] - Before posting, please check: http://www.mysql.com/manual.php

Re: Mysql 4 production quality

2003-02-06 Thread Josh Trutwin
hi there i was wondering if mysql 4 will become production quality soon ? i would like to convince work to start using it, so i can start using the transactions, sub selects and query cache I don't think MySQL 4.0 has sub-selects, that's 4.1. I've been using 4.0 on two different ISPs for a

Re: Mysql 4 production quality

2003-02-06 Thread Dan Nelson
In the last episode (Feb 05), Dan Rossi said: hi there i was wondering if mysql 4 will become production quality soon ? i would like to convince work to start using it, so i can start using the transactions, sub selects and query cache Well, MySQL 3.23 already has transactions with the InnoDB

Re: locking tables , mysql 3.23.41

2003-02-06 Thread Heo, Jungsu
hello. You can read lock whole database's tables like this : FLUSH TABLES WITH READ LOCK ; and unlock with UNLOCK TABLES ; - Original Message - From: Franz, Fa. PostDirekt MA [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 10:35 PM Subject: locking tables ,

How to build Relay Replication system ?

2003-02-06 Thread Heo, Jungsu
Hello! I have a following system. Server A : a master for server B. MySQL 4.0.9 Server B : a slave for server A, a master for server C. MySQL 4.0.10 Server C : a slave for server B. MySQL 4.0.10 and I wanna that if update occurs on A, it forwarded to B and B forward it to C But I don't know how

Re: InnoDb Problems

2003-02-06 Thread Natale Babbo
i see that you don't specify any path for innodb_data_home_dir, innodb_log_group_home_dir and innodb_data_file_path ... write down the correct path and retry. regards. --- Davy Obdam [EMAIL PROTECTED] ha scritto: Hi People, I have been trying to get InnoDb to run on my windows XP

Re: Is it my English or does this sound bad?

2003-02-06 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 5 Feb 2003, Defryn, Guy wrote: I was just reading through the Mysql manual section 3.32 And came across a sentence that started like this Animal sex can be represented in a variety of ways My mother tongue is not English but doesn't it

problem starting innodb support

2003-02-06 Thread Anirudha Kukreti
i am new to mysql, my problem is that i cannot create tables with type innodb i have made the entry innodb_data_file_path in my.cnf i am using mysql 4.0.2 alpha on red hat 7.1 could anybody plese help me? thanks anirudh -

comparision of performance b/w mysql and db2

2003-02-06 Thread Anirudha Kukreti
i am planning to shift my database from mysql to db2 could anybody please send me some details showing the performance of the mysql server usder varying loads as compared to db2 server thanks! - Before posting, please check:

RE: Replication question

2003-02-06 Thread RAHARD Matthieu
Hello, When you say not easily, you say that it's possible. Can you explain to me what I have to do to realize that even if it's a complex solution. Thank's for your help. -Message d'origine- De : Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 6 février 2003 03:05 À : RAHARD

Re: Deleting a database in Mysql

2003-02-06 Thread Kevin Smith
drop database yourdatabasename; - Original Message - From: Calvin Lam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 2:50 PM Subject: Deleting a database in Mysql Hi, I am a newbie with this and I need help with Mysql How can I delete a database in Mysql

symlinks

2003-02-06 Thread Prasanth Krishna
Hi all i am working on mysql 4.0 on netware OS. in the my.cnf file i removed the skip-symlink option under mysqld program. then i used the following query: mysqlcreate table temp ( id int auto increment primary key, name varchar(20) not null) data directory = 'sys:/etc'; the table is created

Re: Deleting a database in Mysql

2003-02-06 Thread Doug Thompson
See DROP DATABASE Doug On Wed, 5 Feb 2003 22:50:25 +0800, Calvin Lam wrote: Hi, I am a newbie with this and I need help with Mysql How can I delete a database in Mysql thanks! - Before posting, please check:

mySQLGUI/MacOSX

2003-02-06 Thread Rich Allen
trying to get mySQLGUI to install on Mac OS X, fltk seemed to install ok but am getting the follwoing for flvw [ARTiBook:~/src/flvw/1.0] root# make === making src === Compiling Flv_List.cxx... In file included from ../FL/Flv_List.H:45, from Flv_List.cxx:38: