Execute multiple scripts

2001-07-13 Thread Järkeborn Joacim
Hi, I have approx. 110 SQL scripts in a directory. Each containing DROP TABLE, CREATE TABLE, lots of INSERT INTO and finally a COMMIT. I need to run all these script in mysql console. My plan is to write a perl script that looks into the directory and fetch all *.sql scripts and then execute

INSERT INTO ... SET ...

2001-07-13 Thread Rolf Hopkins
Hi all, A week ago or so, someone on this list had a problem with inserting data. I thought the reason was because they had mixed up the INSERT and UPDATE statements. ie. INSERT INTO table_name SET column1=a_value, column2=a_value, ... However, they said this statement works from the MySQL

RE: Execute multiple scripts

2001-07-13 Thread Jorge del Conde
Hi, The purpose of the execute parameter I to execute a command and then quit; An example of how to use the --execute or -e parameter follows: Prompt mysql -e select * from user mysql [prints everything from mysql.user to stdout] If you want to execute the contents of a file through the

Re: INSERT INTO ... SET ...

2001-07-13 Thread John Birrell
On Fri, Jul 13, 2001 at 02:56:05PM +0800, Rolf Hopkins wrote: In all the years I have worked/studied SQL, not once have I come across the INSERT INTO ... SET ... syntax. My questions are: 1. Is this a valid statement? 2. Is it ANSI standard? 3. Is this a MySQL feature / bug or do other

RE: INSERT INTO ... SET ...

2001-07-13 Thread Jorge del Conde
Hi, From the manual: The col_name=expression syntax is supported in MySQL Version 3.22.10 or later. Section 7.21 INSERT Syntax http://www.mysql.com/doc/I/N/INSERT.html Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/

RE: Placing database on a novell disk

2001-07-13 Thread Järkeborn Joacim
Hi, After installation in 'C:\mysql' I moved the 'C:\mysql\data' directory to 'C:\mysql-data'. That means that all databases where moved (mysql, test and my own). The same was to the Novell drive. I need to do this since I'm going to insert approx. 3.4 GB of data and I have not that much

Mysql performance monitoring?

2001-07-13 Thread Mario Witte
Hello, I'm searching for a tool which will provide statistics about the usage of a mysql-server like avg queries/minute, cpu load etc. I've tried mysqler and liked it, but couldn't get it to start as a daemon. Are there any similar tools out there? Thanks in Advance, -- Mario Witte [EMAIL

Re: Mysql performance monitoring?

2001-07-13 Thread Jean-Luc Fontaine
On Friday 13 July 2001 13:40, Mario Witte wrote: Hello, I'm searching for a tool which will provide statistics about the usage of a mysql-server like avg queries/minute, cpu load etc. I've tried mysqler and liked it, but couldn't get it to start as a daemon. Are there any similar tools out

Re: mysql.org

2001-07-13 Thread Santi Chumbe
Dear MySQL team, My University was considering to buy a number of licences of the enhanced MySQL(tm) from Nusphere. However, now, we all the University IT staff (managers, developers, designers, etc.) have decided to strongly go up against any commercial contact with such a robber company called

RE: INSERT INTO ... SET ...

2001-07-13 Thread Chris Bolt
3. Is this a MySQL feature / bug or do other DBs support this? It doesn't work in Postgres. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: mysql.org

2001-07-13 Thread Joel Hughes
Can't we pull the mysql.org domain from under them? Surely this breaches domain name usage? joel -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: 13 July 2001 06:39 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: mysql.org Hi! Enhanced MySQL(tm) is as

Re: INSERT INTO ... SET ...

2001-07-13 Thread Rolf Hopkins
Ok, I must have been blind or something. However the question still remains. Is this an added feature of MySQL and is not part of ANSI standard? I guess it is because I've never come across it before. I have tried searching the manual again on this, especially Ch 5 but found nothing. This is

(win 2000 + mysql) = problem

2001-07-13 Thread Andrey Goncharenko
I install mysql (v 3.23.39) on Windows 2000 pro, but server is not run:( Plese, help me... What I must to make? ó Õ×ÁÖÅÎÉÅÍ, áÎÄÒÅÊ. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Mysql performance monitoring?

2001-07-13 Thread Van
Mario Witte wrote: Hello, I'm searching for a tool which will provide statistics about the usage of a mysql-server like avg queries/minute, cpu load etc. I've tried mysqler and liked it, but couldn't get it to start as a daemon. Are there any similar tools out there? Thanks in

Unsigned data with auto increment = Faster/better... ??

2001-07-13 Thread David Bouw
Hi there, I grabbed the MySQL reference book and was doing some reading on the different Integer types.. Something that I noticed was that you could also add an option to say if a Int was unsigned ot signed.. Does it have any sence to use a signed int on a autoincrement table..? E.g. When

MyODBC 2.50.37 and Access 2000

2001-07-13 Thread Kevin Smith
Hi All, I've installed MySQL 3.23.39 on my Windows 2000 Pro Server and I am currently developing a database using Access 2000 as a front-end to MySQL using MyODBC 2.50.37. I have all my MySQL tables linked as ODBC tables in Access. When I am inputting data into an Access Form and then save the

Re: mysql.org

2001-07-13 Thread PeterWR
Hi Van, I have no experience with Progress software. Once, Progress must have seen their approach as the right way. That they sonner or later see a need to change, does not approved the way it is done. In short term, the clients for the NuSphere are already familiar with MySQL and

Re: mysql.org

2001-07-13 Thread Kevin Smith
What really pisses me off about companies is when they steal ideas and blantly try and sell those ideas and don't think about what impact they will have on the Open Source community and the persons involved who dedicate their lives to developing fantastic software for people to use. I'm 101%

Re: (win 2000 + mysql) = problem

2001-07-13 Thread Kevin Smith
What does it say in your, C:\mysql\data\mysql.err file? - Original Message - From: Andrey Goncharenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 13, 2001 10:03 AM Subject: (win 2000 + mysql) = problem I install mysql (v 3.23.39) on Windows 2000 pro, but server is not

RE: mysql.org

2001-07-13 Thread Christopher Thorpe
I would like to whole heartedly add my support to this statement, I feel that Gerry has summed up perfectly everything I would like to say. We have been using MySQL for well over a year now and have found it to be a fast, reliable, efficient and scalable product. I happily recommend the use of it

OS/2 and mysql

2001-07-13 Thread Heinz Wolek
Hi I am testing mysql for OS/2 3.22.16. Whenever I connect to a database I get error messages like the ones below. Can somebody help? Thanks [E:\mysql2\bin]mysql mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with

RE: (win 2000 + mysql) = problem

2001-07-13 Thread Christopher Thorpe
it ran first time for me the other day when I comissioned a new box... does the service give any error messages when you tried to start it? -Original Message- From: Andrey Goncharenko [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 10:04 AM To: '[EMAIL PROTECTED]' Subject: (win

Re: Mysql performance monitoring?

2001-07-13 Thread Mario Witte
Cricket looks great, I think I'll have to try it ASAP. For the moment I just found a utility called mrtg-mysql which puts mysql-stats into mrtg. Statistics aren't very extensive but enough for the moment. -- Mario Witte [EMAIL PROTECTED] On 2001.07.13 07:19:08 -0200 Van wrote: Mario Witte

Windows and MySQL

2001-07-13 Thread simon . taylor
I'm interested in the hostory of MySQl running on NT, does anyone know when the first stable version of MySQl was ported to NT? Si ** This email and any files transmitted with it are confidential and intended solely for the

Re: mysql.org

2001-07-13 Thread Van
PeterWR wrote: Hi Van, I have no experience with Progress software. Once, Progress must have seen their approach as the right way. That they sonner or later see a need to change, does not approved the way it is done. In short term, the clients for the NuSphere are already familiar

Re: GCC 3.0 and mysql++

2001-07-13 Thread Sinisa Milivojevic
Mike W. Baranski writes: Not trying to step on any toes... I was told (awhile back) by Sinsa that mysql++ did not work with gcc 2.96 that redhat released b/c that version of gcc was not a gcc release and therefore not really supported by the gcc people. He also implied that this was a

Re: Mysql++ and Gcc 3.0 compile problems

2001-07-13 Thread Sinisa Milivojevic
I am sending a patch straight to you -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com

MASON GUI for Windows is it good?

2001-07-13 Thread Cesar Cuneo /Corpsoft
I have heard that mason is pretty good , I currently us DB Tools as a windows GUI for MySQL but would consider changing to Mason it its better. Can anybody help with this decision? Has anyone used Mason GUI before? http://www.scibit.com/Products/Software/Utils/Mascon.htm?WROXEMPTOKEN=15539Z

changing mysql prompt

2001-07-13 Thread Nissim Lugasy
Hi , is there a way to change the default mysql prompt to have the current GMT time embedded in the mysql command line prompt and look something like this (and also have the time increase every time the carriage return is pressed) [GMT:193/12:13:45] Mysql [GMT:193/12:13:46] Mysql : :

Re[3]: Strange locking problem disrupting operation

2001-07-13 Thread Werner Stuerenburg
Sie schrieben am Freitag, 13. Juli 2001, 11:51:37: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this

FOR UPDATE ?

2001-07-13 Thread Unico Hommes
Hello, Does mySql support the FOR UPDATE clause as in SELECT * FROM table WHERE criteria FOR UPDATE ? The manual talks about FOR UPDATE as if it is supported but I am getting syntaxis error messages for it. I am using mySql-3.23.33 on windows. The statement is issued from within a Java program

2003 Connection error

2001-07-13 Thread Aidan
I have coded my own client that uses mysql_real_connect(). The client code runs on another machine and there can be up to 120 clients connecting to the database. Each client connects and then disconnects sucessfully for anything up to 5 minutes before the clients start to receive 2003 host

Re: mysql gui and missing edfile.o

2001-07-13 Thread Sinisa Milivojevic
mbb writes: Is there anyway to get my hands on this object file? I've downloaded all the parts listed for the GUI... and I've read through the docs which noted that the edfile.o object was left out of the library build for Fl_Editor... but when I looked around in the directories where I

Error 111 message

2001-07-13 Thread Rasika Amarasiri
I have been using MySQL on a web-cgi search facility. I was using RedHat 6.1 and MySQL 3.22. Recently I upgraded my machine to RedHat 7.0 (bug fixed version) and it had MySQL 3.23. I was using perl DBI via msql-mysql modules to access the database. I can access the tables via the perl scripts

Re: mysql.org

2001-07-13 Thread Gerald R. Jensen
Monty: I was on the verge of authorizing the purchase of 3 copies of NuSphere's PHPEd package (US$300 each) for our developers when I became aware of the controversy surrounding 'Enhanced MySQL' and mysql.org. The purchase order went into the round file, and Hell will freeze over before I buy

Re: Client Command Line interface auto compellation 3.23.39

2001-07-13 Thread Sinisa Milivojevic
Noel Clarkson writes: Hi all, When using the 3.23.39 client to connect to the server, pressing tab to complete table names and field names etc doesn't seem to work. I seem to get the mysql commands, but I thought in past clients I was able to get table name and field name completion as

Bounces from rtmglobal.com

2001-07-13 Thread Chris Bolt
Am I the only one getting these? Someone really needs to fix their mail server... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 4:10 AM To: [EMAIL PROTECTED] Subject: No valid command found Your message does not contain a valid

Re: GUI Bug

2001-07-13 Thread Sinisa Milivojevic
William M. Quarles writes: In the Win 32 version, I seem to have problem scrolling the tables. If I grab the vertical scroll bar and try to pull it down, it won't work, unless I use the arrow keys to move it down about 1/10 of the way, then and only then and lower will it let me scroll by

Re: Mysql bug, doesnt use INDEX for ORDER BY!!

2001-07-13 Thread Gunnar von Boehn
Hello, On Don, 12 Jul 2001, Gerald Clark wrote: It may be the DESC that prohibits the use of the index. Try an normal ascending order. Thanks for you idea, but DESC has no influence whether Mysql uses the INDEX or not. I think maybe that this is a real _bug_ in mysql. :-( Does somebody

Re: mysql.org

2001-07-13 Thread Brooklyn Linux Solutions CEO
The greatest asset to using the MYSQL product over the years has been this mailing list and Monty's personal efforts to answer almost every question, no matter how stupid or repetitive, patiently and accurately. It's blown my mind to see him working so hard on handling the enormous

configuration error on Solaris 5.8 (intel)

2001-07-13 Thread Wolfgang Zeikat
we get the following error while running: ./configure --without-server: checking for restartable system calls... configure: error: can not run test program while cross compiling what could be the problem and how would we possibly fix it? thanks wolfgang --

Re: Mysql performance monitoring?

2001-07-13 Thread Sinisa Milivojevic
Van writes: Mario Witte wrote: Hello, I'm searching for a tool which will provide statistics about the usage of a mysql-server like avg queries/minute, cpu load etc. I've tried mysqler and liked it, but couldn't get it to start as a daemon. Are there any similar tools out there?

Replication and InnoDB

2001-07-13 Thread Jörg Beckmann
Hi, I'm thinking about using MySQL with InnoDB and replication. Are there any experiences with this configuration, esp. what about transactions? What will happen on the slave if transactions are rolled back? What happens if the master or the slave crashes while processing transactions. Thanks,

Re: mysql.org

2001-07-13 Thread Justin Farnsworth
Gerald R. Jensen wrote: Monty: I was on the verge of authorizing the purchase of 3 copies of NuSphere's PHPEd package (US$300 each) for our developers when I became aware of the controversy surrounding 'Enhanced MySQL' and mysql.org. The purchase order went into the round file, and

Repair with keycache

2001-07-13 Thread Mike Baranski
Question about this, when I do mysqladmin processlist, I get Repair with keycache as the state, what exactly is this? Can this be optomized? Mike. P.S. Thanks for the gcc3 patch! - Before posting, please check:

Re: FOR UPDATE ?

2001-07-13 Thread Sinisa Milivojevic
Unico Hommes writes: Hello, Does mySql support the FOR UPDATE clause as in SELECT * FROM table WHERE criteria FOR UPDATE ? The manual talks about FOR UPDATE as if it is supported but I am getting syntaxis error messages for it. I am using mySql-3.23.33 on windows. The statement is issued

wildcard date searching

2001-07-13 Thread s . pollak
Hello, I am still a beginner, but I am trying to learn MySQL. If you have a date field, and you are using the date field in your where clause, I understand how to use : WHERE date=-mm-dd; I am trying to find out if there is anyway to use the wildcard character % in dates like you

Store outgoing faxes

2001-07-13 Thread Werner Stuerenburg
Somebody asked for it a couple of days ago: Accidentally I found hylalog-1.0.tar.gz Store hylafax outgoing faxes in a MySQL database. By Sinisa Milivojevic, [EMAIL PROTECTED] -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3,

Re: Bounces from rtmglobal.com

2001-07-13 Thread Sinisa Milivojevic
Chris Bolt writes: Am I the only one getting these? Someone really needs to fix their mail server... I am getting those too... I will alert our mail administrator ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/

Help needed

2001-07-13 Thread Kim White
Hi Could anybody tell me how to get rid of the following error on a php3 request. Warning: MySQL Connection Failed: Host 'hostname.co.za' is not allowed to connect to this MySQL server in /var/local/irm/irm.inc on line 83. Thanks Kim White

php admin

2001-07-13 Thread Glyndower
I downloaded and installed php admin, seems like a really useful tool. But, if I try to create a table with more than 20 feilds it craps out my browser. It doesn't create all the option feilds, and if I dare to scroll the page, it acts like I'm out of video memory. Less than 20 feilds works

Re: Replication and InnoDB

2001-07-13 Thread Sinisa Milivojevic
Jörg Beckmann writes: Hi, I'm thinking about using MySQL with InnoDB and replication. Are there any experiences with this configuration, esp. what about transactions? What will happen on the slave if transactions are rolled back? What happens if the master or the slave crashes while

RE: mysql.org

2001-07-13 Thread Gerald Jensen
Justin: Thanks ... but I couldn't care less. I have neither the time nor inclination to examine NuSphere's motives. I am a business man, and I made a business decision. Gerald Jensen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Justin Farnsworth

Re: Mysql performance monitoring?

2001-07-13 Thread Ken Menzel
Hi Mario, If you want to see what the MRTG page with check out mrtg-mysql-load: Links to the extension and a live demo for a couple of test servers are at http://www.bitbybit.dk/mysqlfaq Works good for me at http://bsd2.icarz.com/mrtg/index.html (bottom graphs). I also use something called

RECURSIVE-sql/database Re: Bounces from rtmglobal.com

2001-07-13 Thread Justin Farnsworth
[EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the

Re: Repair with keycache

2001-07-13 Thread Sinisa Milivojevic
Mike Baranski writes: Question about this, when I do mysqladmin processlist, I get Repair with keycache as the state, what exactly is this? Can this be optomized? Mike. P.S. Thanks for the gcc3 patch! You are welcome !! The above means that REPAIR table is using keycache. There is

RE: MASON GUI for Windows is it good?

2001-07-13 Thread Chris Lott
I have heard that mason is pretty good , I currently us DB Tools as a windows GUI for MySQL but would consider changing to Mason it its better. Try it out... there is a 15 day trial for the whole product so you can see how you like it. I just started using it a few days ago and I am

Driver

2001-07-13 Thread Mary Elizabeth Ramírez Cano
Buenos días: Estamos usando mysql para accesarla desde el JDK 1.3.1 vía JDBC. Necesitamos el driver mysql_comp.jar donde lo puedo conseguir? Gracias Mary Ramírez Docente.

Flust INSERT DELAYED

2001-07-13 Thread Mike Baranski
Is there any way to flush all insert delayed tables at once, with 1 command? -- \\|// (@ @) ---oOO---(_)---OOo || | Mike Baranski | | Security Managment Consulting | |

RE: wildcard date searching

2001-07-13 Thread Chris Bolt
Hello, I am still a beginner, but I am trying to learn MySQL. If you have a date field, and you are using the date field in your where clause, I understand how to use : WHERE date=-mm-dd; I am trying to find out if there is anyway to use the wildcard character % in dates

Re: Store outgoing faxes

2001-07-13 Thread Sinisa Milivojevic
Werner Stuerenburg writes: Somebody asked for it a couple of days ago: Accidentally I found hylalog-1.0.tar.gz Store hylafax outgoing faxes in a MySQL database. By Sinisa Milivojevic, [EMAIL PROTECTED] -- Herzlich Werner Stuerenburg Well, I am the author, but I am

Re: changing mysql prompt

2001-07-13 Thread Tonu Samuel
Nissim Lugasy wrote: Hi , is there a way to change the default mysql prompt to have the current GMT time embedded in the mysql command line prompt and look something like this (and also have the time increase every time the carriage return is pressed) [GMT:193/12:13:45] Mysql

Re: MASON GUI for Windows is it good?

2001-07-13 Thread j.urban
I don't know much about Mascon, but I've been happy with urSQL (http://www.urbanresearch.com/ursql)... I think it largely depends on your needs. On Fri, 13 Jul 2001, Cesar Cuneo /Corpsoft wrote: I have heard that mason is pretty good , I currently us DB Tools as a windows GUI for MySQL but

Re: MySQL.org

2001-07-13 Thread Matthias Urlichs
Hi, The article mentions that the Web site will confuse new users, but I think this one will confuse them even more: http://mysql.net/ (for non-Japanese users that is). Korean, actually. -- Matthias Urlichs (being exceedingly helpful today)

Re: FOR UPDATE ?

2001-07-13 Thread zb
Hi! On Fri, 13 Jul 2001, Unico Hommes wrote: Hello, Does mySql support the FOR UPDATE clause as in SELECT * FROM table WHERE criteria FOR UPDATE ? The manual talks about FOR UPDATE as if it is supported but I am getting syntaxis error messages for it. I am using mySql-3.23.33 on windows.

MySQL prompt

2001-07-13 Thread Sinisa Milivojevic
GMT-like prompt is doable, but it should be coded into the program. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus

Re: RECURSIVE-sql/database Re: Bounces from rtmglobal.com

2001-07-13 Thread Sinisa Milivojevic
Justin Farnsworth writes: [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply

RE: Bounces from rtmglobal.com

2001-07-13 Thread Don Read
On 13-Jul-01 Chris Bolt wrote: Am I the only one getting these? Someone really needs to fix their mail server... It's looks like the usual start-up bugs for somebody's spam-bot. I got 64 no-valid-command bounces to MySQL messages since June 22nd; And guess what followed shortly afterward:

Re: wildcard date searching

2001-07-13 Thread Dibo Chen
where date like '2001-07%' ... would find all 2001-07-??. [EMAIL PROTECTED] wrote: Hello, I am still a beginner, but I am trying to learn MySQL. If you have a date field, and you are using the date field in your where clause, I understand how to use : WHERE date=-mm-dd; I am

RE: wildcard date searching

2001-07-13 Thread Don Read
On 13-Jul-01 [EMAIL PROTECTED] wrote: Hello, I am still a beginner, but I am trying to learn MySQL. If you have a date field, and you are using the date field in your where clause, I understand how to use : WHERE date=-mm-dd; I am trying to find out if there is anyway to use

Dificult question.....

2001-07-13 Thread David Tomàs Fargas
I Have a large table with 59.000 records and if i execute a simple select since Select * from table order by cod it takes 4 seconds to process query! and if table will have 590.000 then... well, you see it. It's possible to accelerate it, without where and limit clausules? I think no, and in my

Re: Strange locking problem disrupting operation

2001-07-13 Thread Johan Wahlström
I dont know what's causing this, and why, I only know the results :( Either it's some feature/bug in 2.23.39, or it has something to do with my hardware, but how likely is that? It could also be some strange result from moving to Linux 2.4, over 2.2... but who knows? /Johan - Original

Re: Strange locking problem disrupting operation

2001-07-13 Thread Johan Wahlström
I dont know what's causing this, and why, I only know the results :( Either it's some feature/bug in 2.23.39, or it has something to do with my hardware, but how likely is that? It could also be some strange result from moving to Linux 2.4, over 2.2... but who knows? /Johan - Original

Re: Help needed

2001-07-13 Thread Gerald Clark
You need to GRANT PRIVILEGES to the host and user that PHP connects from. Kim White wrote: Hi Could anybody tell me how to get rid of the following error on a php3 request. Warning: MySQL Connection Failed: Host 'hostname.co.za' is not allowed to connect to this MySQL server in

RE: Execute multiple scripts

2001-07-13 Thread Don Read
On 13-Jul-01 Järkeborn Joacim wrote: Hi, I have approx. 110 SQL scripts in a directory. Each containing DROP TABLE, CREATE TABLE, lots of INSERT INTO and finally a COMMIT. I need to run all these script in mysql console. My plan is to write a perl script that looks into the directory

Help: Many to Many Select

2001-07-13 Thread Simon
Hello, I need help with a select statement on my database. (I am still on L Plates with Mysql) My Tables Clients - Holds clients infomation Targets - Holds Target infomation Clients_Targets - Holds Clients Id and Targets Id How do I find clients that are in

HA Setup for MySQL

2001-07-13 Thread Shon Stephens
I recently started experimenting with a way to setup MySQL to be load-balanced. I installed 2 servers with MySQL, NFS mounted the /mysql/var directory, then moved the grant tables to /mysql/grant, and created a symbolic link from /mysql/var/mysql to /mysql/grant. This appeared to work

Update problems

2001-07-13 Thread Jesús Gómez
I have a problem with the update querys. When i do a update in a table,it fails. If i do this query two or three times it works fine. There isn´t a table problem because this error happens in every tables. The select and insert querys work fine. Anybody knows what could be the problem?

Database Connection

2001-07-13 Thread Daniela Ivana
I created a database with MySql (version 3.23.39-nt) that has a table named Report. How can I open the database and insert values in this table from a servlet? _ Get your FREE download of MSN Explorer at http://explorer.msn.com

Dificult question.....

2001-07-13 Thread David Tomàs Fargas
I Have a large table with 59.000 records and if i execute a simple select since Select * from table order by cod it takes 4 seconds to process query! and if table will have 590.000 then... well, you see it. It's possible to accelerate it, without where and limit clausules? I think no, and in my

Re: MyODBC 2.50.37 and Access 2000

2001-07-13 Thread Kevin Smith
Hi, I didn't get a reply to this, so I guess no one knows, or, it's on the wrong forum. Can any set me straight on this? Cheers, Kevin - Original Message - From: Kevin Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 13, 2001 10:24 AM Subject: MyODBC 2.50.37 and

Re: MyODBC 2.50.37 and Access 2000

2001-07-13 Thread Venu Anuganti
Hi Kevin Can you please send us the ODBC trace generated by MyODBC as well as ODBC DM ? Thank you Venu Anuganti - Original Message - From: Kevin Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 13, 2001 2:24 AM Subject: MyODBC 2.50.37 and Access 2000 Hi All, I've

Re: RECURSIVE-sql/database Re: Bounces from rtmglobal.com

2001-07-13 Thread Dibo Chen
did everyone on the list get those spam emails? I got 6 too, within 15 minutes, at 5am my local time. And I don't remember sending anything at that time, I was sleeping :) Sinisa Milivojevic wrote: Justin Farnsworth writes: [EMAIL PROTECTED] wrote: Your message cannot be posted

RE: Unsigned data with auto increment = Faster/better... ??

2001-07-13 Thread Don Read
On 13-Jul-01 David Bouw wrote: snipage ahead Something that I noticed was that you could also add an option to say if a Int was unsigned ot signed.. Does it have any sence to use a signed int on a autoincrement table..? E.g. When using a auto-increment correctly you will never need a

Export to MySQL from SQL Server 2000

2001-07-13 Thread Chris Malloch
Hi, Newbie to MySQL here. I am trying to export tables from SQL Server to MySQL set up on a virtual server and manage to create the tables when the fields contained within them are purely text, but the table creation fails when fields are type integer or type datetime. The error message is

Re: Help needed

2001-07-13 Thread Tonu Samuel
Kim White wrote: Could anybody tell me how to get rid of the following error on a php3 request. Warning: MySQL Connection Failed: Host 'hostname.co.za' is not allowed to connect to this MySQL server in /var/local/irm/irm.inc on line 83.

RE: Dificult question.....

2001-07-13 Thread Don Read
On 13-Jul-01 David Tomàs Fargas wrote: I Have a large table with 59.000 records and if i execute a simple select since Select * from table order by cod it takes 4 seconds to process query! and if table will have 590.000 then... well, you see it. It's possible to accelerate it, without

RE: Bounces from rtmglobal.com

2001-07-13 Thread massey
Remember Win 3.1, you had to create PIF files for DOS programs, I think it was DOS, to run in the Win enviroment. The odd thing is that it sure sounds like some kind of new virus with that kind of text comment. Cheers M;) -Original Message- FROM: Don Read TO: Chris Bolt CC: [EMAIL

RE: MASON GUI for Windows is it good?

2001-07-13 Thread sean . odonnell
They give away the previous version free (i.e if they are on 1.9 you can download 1.8 and use it free) -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: 13 July 2001 14:30 To: '[EMAIL PROTECTED]' Cc: MySQL List (E-mail) Subject: RE: MASON GUI for Windows is it good?

Re: Replication

2001-07-13 Thread Brian Reichert
On Thu, Jul 12, 2001 at 03:49:12PM -0700, Jeff Philapy wrote: It is hard to say where I am confused because the HOWTO requires me to try and follow it as I setup replication. So let me try and follow the documentation and if I see anything that can make it more clear then I will let you

Tecnical information

2001-07-13 Thread Tecnoelettrica - LombardiGroup
Dear Mysql How can lock and unlock a single record into mysql table? Thank you very much.

Re: mysql.org

2001-07-13 Thread Michael Widenius
Hi! Tim == Tim Endres [EMAIL PROTECTED] writes: If anyone has any comments about how we at MySQL AB work as an open source company, please write to our CEO Marten Mickos via [EMAIL PROTECTED] and we will welcome your suggestions. We are totally dependent on the trust of our users, as

RE: mysql.org

2001-07-13 Thread Paul DuBois
Well. It should be an interesting Open Source convention in San Diego later this month... database,sql,query,table -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Re: Update problems

2001-07-13 Thread Tonu Samuel
Jesús Gómez wrote: I have a problem with the update querys. When i do a update in a table,it fails. If i do this query two or three times it works fine. There isn´t a table problem because this error happens in every tables. The select and insert querys work fine. Anybody knows what

adv:as seen on national television

2001-07-13 Thread jmarie
I AM AS CONSERVATIVE AS IT GETS…THIS REALLY WORKS. YOU WILL BE DEBT FREE FOR 2002...PLEASE READ BEFORE DELETING...THIS IS NOT A SPAM...YOU WILL BE DEBT FREE...YOU HAVE NOTHING TO LOSE BUT EVERYTHING TO GAIN All our mailings are sent complying to the proposed United States Federal

RE: MySQL.org

2001-07-13 Thread Sander Pilon
Hi! cut Sander I do not deny their claim on the trademark OR domain, but I am Sander somewhat unpleasantly surprised by the means they try to resolve Sander this matter, and the fact that nobody in a what I assume is an Sander internet-aware company like MySQL even considered

jdbc works on win2000 but not on linux rh7.0

2001-07-13 Thread shane
i've written a java file to connect to the database in a linux rh7 os. the file runs fine on a win2000 os so i think that there is no problem with the code. I've set my class path to the dir where i've downloaded the mm.mysql.jar file and the path set to my jdk1.3.1/bin and jdk1.3.1/lib

RE: Initial setup in Linux RH7.1

2001-07-13 Thread shane
Hi, got the same problem too after i rebooted my linux RH7. i solved it by restarting the server : bin/safe_mysqld --user=mysqladm I got the command from Paul Dubois book on MySQL hope it helps -Original Message- From: Roberto Carlos Sánchez Barroso [mailto:[EMAIL PROTECTED]] Sent:

RE: java connection

2001-07-13 Thread shane
hi, maybe you can try d/l the mm.mysql driver from the jdbc link at www.mysql.com. the details of programming can be retrived from the webpage where you will get the mm.mysql driver under documentation. after you've downloaded the documentation mm.doc.tar, you can view the book1.html file and

RE: Dificult question.....

2001-07-13 Thread Don Read
On 13-Jul-01 David Tomas Fargas wrote: Well, sorry about my worst explanation :) The table is a Spain Postal Codes Table. It has fields: Cod(5),Descr(100),Country(3),IND(13),ORD(3). All are varchars. Because there are possible to have the same Postal Codes and diferent description or

  1   2   >