mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Re:.37 INNO Strange behaviour after deleting a table

Heikki, here are more details ... I' am running mysql-3.23.37 on a hp-ux11 box (with actual patches) I used the following configure options to compile MySQL: CXX=gcc CFLAGS="-fomit-frame-pointer -O6 -fpic" CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti -O6" ./configure --with-low-m

Key_Writes > Key_write_requests ???

Hi, Mysqladmin shows me : | Key_write_requests | 80850 | | Key_writes | 112447| What does it mean, and how could this be possible ? Thank you, Jocelyn Fournier Presence-PC www.presence-pc.com

Re: SQL help

You might be able to do something like this instead: SELECT *, id*0+RAND() AS r FROM table ORDER BY r LIMIT 5; Check the list archives, this issue comes up quite often. On Wed, 9 May 2001, Webmaster wrote: > i dont follow step #3. > > > At 11:42 PM 5/8/2001, Tony Shiu wrote: > >i think i

Re: SQL help

for 3) if you have a set of random values e.g. 1,3, 6, 9, 4 then your sql will be select * from your-table where id in (1, 3, 6, 9, 4); FYI: if you are using ver 3.23.X, you may use SELECT * FROM your-table ORDER BY rand() LIMIT 5 contributed from: "Zak Greant" <[EMAIL PROTECTED]> rand() seems

Re: SQL help

i dont follow step #3. At 11:42 PM 5/8/2001, Tony Shiu wrote: >i think it is more suitable to do it in programming level in mysql, though I >know there is a function is M$sql server. > >if your table schema has a unique id field, before submit a query to DB, >1) select count(*) from it >2)

Re: mysql Front

Ah! ok, maybe I won't be much help after all. Only thing I can think of would be your privilege tables. - Original Message - From: "TWooly" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, May 09, 2001 11:58 Subject: Re: mysql Front > I h

POST operation looses variables? *sometimes* HTTP 302 error???

This may not be a mysql issue, but mysql is the manefestation of the problem: Sometimes POST operation seems to loose variable contents, and the apache log shows "302" result. Blank row is inserted into DB. My script has a form: ?action=> when the post occurs, the script checks $action. If $acti

Re: SQL help

i think it is more suitable to do it in programming level in mysql, though I know there is a function is M$sql server. if your table schema has a unique id field, before submit a query to DB, 1) select count(*) from it 2) from the above resultset, program to draw whatever number of records you wa

Re: mysql Front

I have a dedicated server in a colocation data center and I have root access but I would like to use mysqlfront(http://www.mysqlfront.de) to administer the mysql server from a specific location my static ip on a different computer. Sorry should have been more clear about it.

Re: SQL help

SELECT * FROM db ORDER BY rand() LIMIT 5 --zak - Original Message - From: "Webmaster" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 08, 2001 9:38 PM Subject: SQL help > How do I write SQL in MySQL to randomly select 5 records from a table? > > > --

SQL help

How do I write SQL in MySQL to randomly select 5 records from a table? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

Re: FILE Permission Security Question

At 11:13 PM -0400 5/8/01, A. Chris Nichols wrote: >Hello everyone, > >I was wondering if anyone could help me out and explain a bit about >the FILE permissions and how they relate to two particular scenarios: > >In both cases MySQL is running on SunOS 5.7 and running MySQL client >version 3.22.

FILE Permission Security Question

Hello everyone, I was wondering if anyone could help me out and explain a bit about the FILE permissions and how they relate to two particular scenarios: In both cases MySQL is running on SunOS 5.7 and running MySQL client version 3.22.23b MySQL UserA has permissions only on DatabaseA and is

Re: timestamp question

I'm not sure exactly what you are trying to do but you do not need to use NOW with a timestamp column. Timestamp columns already automatically insert date & time for you. - Original Message - From: "Mark D. Wallace" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 09, 20

Re: mysql Front

You mean mysql client?!! and what about the mysql server? Is it running on your ISP?? Some ISP's do not allow remote access. You also need to read Ch 6 and the GRANT and REVOKE statements in Ch 7 - Original Message - From: "TWooly" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wed

Problem using "SELECT INTO DUMPFILE"

I get an error stating: "you have an error in your SQL syntax near 'dumpfile '/data/file.doc''" The command I'm trying to execute is: select resume from apps where appid=23 into dumpfile '/data/file.doc' The server and client are on two different computers. I'm using client version 3.23.36 on m

Re: Performance MySQL with C-API

> > Hi, > > I've got a couple a questions concerning the speed of insert queries when > using the C API from MySQL. I've written an application that receives > data through a CORBA event channel and stores it in a MySQL database. The > problem is that a lot of events are dropped. I think (I'm qu

Re: How to move a MySQL database from Windows to Linux machine.

On Tue, May 08, 2001 at 07:09:24PM -0400, Thalis A. Kalfigopoulos wrote: > > Yes, true. But is it safe to ftp them in ASCII mode as mentioned? > I'd go for binary mode instead. No, use BINARY. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax:

timestamp question

I'm getting an error when creating a new database table with a timestamp column with NOW()...i.e. >> .., meetingtime timestamp(12) NOW(), I can't find an example in the mysql manual of how this is actually done. Can anyone point me in the right direction. Thanks, Mark --

RE: MOD_AUTH_MYSQL

I think they move to sourceforge.com -Original Message- From: jason [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 6:50 PM To: [EMAIL PROTECTED] Subject: MOD_AUTH_MYSQL Is there anyone out there who knows where I can get support with this mod for apache? The web page listed in

Re: How to move a MySQL database from Windows to Linux machine.

On Tue, 8 May 2001, Jeremy Zawodny wrote: > On Tue, May 08, 2001 at 03:15:31PM -0700, David Potter wrote: > > > I have a question on moving a MySQL database from a Windows Me > > machine to a Linux machine. Most of our tables have over 22 million > > rows. I suppose the slow but safe way is to

'\0' in blobs ...

hi ... how can i build queries that save the value of ... for example jpg-files ? in their binary-code there are many '\0' - characters which terminate a string ... so how can i tell the mysqlserver to save it anyway ? - Before

MOD_AUTH_MYSQL

Is there anyone out there who knows where I can get support with this mod for apache? The web page listed in the package seems to be invalid and I can't seem to locate any support lists on the apache side of things. Actually any help at all on how to make this install or any other method out th

Re: How to move a MySQL database from Windows to Linux machine.

On Tue, May 08, 2001 at 03:15:31PM -0700, David Potter wrote: > I have a question on moving a MySQL database from a Windows Me > machine to a Linux machine. Most of our tables have over 22 million > rows. I suppose the slow but safe way is to dump the whole database > on the Windows machine usi

mysql 3.23.37 and Solaris 2.6

Hi All, I have seen some messages on this, but none seem to give a solution. I am trying to install mysql 3.23.37 on a Sun solaris 2.6 box and I get an error like this during the ./configure stage: --- clip --- checking for type fp_except... yes checking if gcc supports bool ty

Strange behavior.

Hi, Im not sure wheter this is a bug ( and it will make me look silly ) but its been annoying :).. It could even have been fixed since 3.22.27 :) ( Yes! I will upgrade tomorrow :) I have these three tables: ***RULES*** CREATE TABLE rules (id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, owner in

ODBC Problems

I have downloaded the new MySQL ODBC driver for Win98. Now all the work I did before will not work. It keeps telling my Provider not found and I have the provider from before set to MySQLProv and I have tried MySQL in the provider section. Now all my VB programs that work with the MySQL datab

How to move a MySQL database from Windows to Linux machine.

Hello, I have a question on moving a MySQL database from a Windows Me machine to a Linux machine. Most of our tables have over 22 million rows. I suppose the slow but safe way is to dump the whole database on the Windows machine using mysqldump and then ftp the dump file over to the Linux box

Re: Not unique table/alias

Check out the 2nd bullet under 7.21.1 of the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#INSERT_SELECT You could do this by creating a temporary table out of MaterialSubwall and using that to select rows for the insert. - TIM > What does this mean? It is re

mysql and multiple inner join, strange errors

xcuse for the previous mail, i forgot to sign and to change the topic ;) got an error in PhpMyAdmin for this syntax but no error message displayed, could someone help me that's the first time i run such inner joins on an other DDB than Ms SQL ... Here's the Query : SELECT informations.ti

RE: create table..

got an error in PhpMyAdmin for this syntax but no error message displayed, could someone help me that's the first time i run such inner joins on an other DDB than Ms SQL ... Here's the Query : SELECT informations.titre, informations.Texte FROM informations INNER JOIN recurrence_informations ON

Re: Using "where xxxx in (select ...... )"

On Tue, 8 May 2001 22:38:52 +0100, "green jon" <[EMAIL PROTECTED]> wrote: MySQL currently does not support sub select queries >>Hello, >> >>I have recently converted my Java Servlets to run against mySQL where previously I >was using Microsoft Access. I use Tomcat and have swapped drivers et

Re: Using "where xxxx in (select ...... )"

green jon wrote: > > Hello, > > I have recently converted my Java Servlets to run against mySQL where previously I >was using Microsoft Access. I use Tomcat and have swapped drivers etc and everything >works fine, more or less. However, I have one big problem which is as follows :- http://w

Using "where xxxx in (select ...... )"

Hello, I have recently converted my Java Servlets to run against mySQL where previously I was using Microsoft Access. I use Tomcat and have swapped drivers etc and everything works fine, more or less. However, I have one big problem which is as follows :- My servlet software dynamically builds

Not unique table/alias

What does this mean? It is referring to the following SQL statement: INSERT INTO MaterialSubwall SELECT subwallClassId, mirrorEW, rotation + 180, sizeX, sizeY, offsetS, offsetW, offsetN, offsetE FROMMaterialSubwall; AFAIK, this

RE: create table..

create table button doesnt work. William Bowman Hirons & Company Interactive Programmer 555 N. Morton St. Bloomington,Indiana 47404 812-331-7500 Ext. 150 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 2:39 PM To

Re: loader

Specify the format of the text field in your query. For example, if the fields are tab-delimited and each line is a new row, you would use load data local infile 'c:\phani\phani.txt' into table phani1 fields terminated by '\t' rows terminated by '\n'; Ben Gollmer On Tuesday, May 8, 2001, a

loader

hi list, im giving this command mysql>LOAD DATA LOCAL INFILE "c:/phani/phani.txt" INTO TABLE phani1; the columns in phani1 are equal to columsn in phani.txt There are totally 3 columsn (empno, ename, address) when i say select * from phani1; im getting only empno and null values for ename and

AIX recommendations

Hi Darren, were you ever able to resolve the failures for tests rpl15 and rpl16 (mentioned in your 27-Apr message)? I have the same problem, when building (using gcc-2.95.3) for Solaris/SPARC 7 and 8. When I run rpl15, the mysqld-slave.err messages say -- 010508 20:50:19 Slave: con

mysql-test-run fails five tests

Hi David, did you ever find out how to resolve the problem where rpl15 and rpl16 fail, after a mysql-3.23.37 build? I have the same problem, when building (using gcc-2.95.3) for Solaris/SPARC 7 and 8. When I run rpl15, the mysqld-slave.err messages say -- 010508 20:50:19 Slave: co

FULLTEXT relevancy

Couple problems here... Have a database with 36,316 emails archived. emailarchive.emailbody has a FULLTEXT index. If I query on a term that exists in the majority of the emails, it returns 0 rows and takes an incredible amount of time. mysql> SELECT count('') FROM emailarchive where listnum =

BDB table handler error 30996

when a BDB table is being written to and another thread issues a query I sometimes get this error code. Ideas? The table is fresh it was created by the dumpfile that another thread is loading in while I'm running the count query. this is mysql-max 3.23.37 mysql> select count(*) from _data; +-

mysql Front

I have downloaded mysql front and I was wandering how on the server end I can connect to it from a remote location. I keep getting 'hostname" is not allowed to connect to this mysql server. I do have a static ip at this remote location. I am new to mysql so sorry if this has already been answer

Re: my sql database and unique keys

VVM Ravikumar Sarma Chengalvala wrote: > > Hi, > How can I have an UNIQUE key in MYSQL which > differentiates between case sensitive strings.i.e If I > want to store "XYZ","XYz" and "xyz" > differently.Currently mySQl is not accepting this type > of strings and treating them as the same. > > Reg

mysql-test-run fails five tests

>Description: On both precompiled and site compiled versions, the testsuite reports errors in "rpl000xx.test". This is on Solaris7. The precompiled version reports the following errors: rpl01 rpl04 rpl07 The site compiled version reports the following errors: rpl01 r

Re: Commit and Rollback.

On Tue, 8 May 2001, Rajeev Ramanujan wrote: > Date: Tue, 8 May 2001 19:49:11 +0530 > From: Rajeev Ramanujan <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Commit and Rollback. > > Hi, > >Will MySQL support COMMIT and ROLLBACK. > > Thank You > Rajeev Ramanujan > > Depends

my sql database and unique keys

Hi, How can I have an UNIQUE key in MYSQL which differentiates between case sensitive strings.i.e If I want to store "XYZ","XYz" and "xyz" differently.Currently mySQl is not accepting this type of strings and treating them as the same. Regards, Ravi __

Re: Performance MySQL with C-API

> Could you have a better disk environment on the Solaris machine versus the > win32-machine? The Solaris machine was a little bit slower executing the query, but it runs as a production-webserver and there is much more load on it than on my win32-test-machine. > query that inserted 1 string

Newbie... accessing mysql on linux via myodbc...please help ..

Hi all... I am using mysql database in linux. Now we want to use odbc calls in a linux program to access this database. Is this possible? I have no idea of this... and as my project dead line is near i am in a fix. so if someone could tell me about this approach and also send in a very simple exam

problems with mysql and access

I have downloaded the ODBC driver 2.50 37-nt form www.mysql.com , I have installed it and I have created the ODBC data source called sample_mysql, but when I try to import tables form access I get an error message saying: [TCX][MyODBC] cannot connect to mysql server ……… (10

Re:Commit and Rollback.

Rajeev, with the transaction-safe table types InnoDB and BDB, MySQL supports commit and rollback. They are available in the Unix source distribution and in the MySQL -Max binary distribution. Monty said he already has also Windows sources ready and will post them once he has time. Regards, Heik

Re:.37 INNO Strange behaviour after deleting a table

Andre, it might be a bug in the multiversioning code in InnoDB. Can you describe in detail the situation: - What is the CREATE TABLE statement? - How many rows there are in the table? - How did you import the table? - Are you able to repeat the bug if you delete and drop the table, and create

RE: AUTO_INCREMENT Confusion

Hi! I think that for BDB and InnoDB tables MySQL first executes SQL SELECT MAX(auto-increment-column) FROM your-table for the table, and then adds 1 to the value it gets. It means that if you delete the row with the highest counter value, MySQL will assign it again to a new row. On the othe

RE: Performance MySQL with C-API

Not only database design but system as well. Drive speed, drive fragmentation and I/O resources can play a large factor in database speed. Could you have a better disk environment on the Solaris machine versus the win32-machine? -Original Message- From: Ansgar Becker [mailto:[EMAIL PROTE

.37 INNO Strange behaviour after deleting a table

Hi, I accidently delete all my records from a table, but I always make backups!!! Okay, I deleted the (empty) table with drop table. Than I recreate the table and all the data mith a mysql batch job (from mysqldump) . No problem. Than I started the mysql UI and make some test queries. select *

Re: Performance MySQL with C-API

> insert 200 strings + timestamps a second through the API. Does that sound > too less or am I expecting too much? Do benchmarks or test results for the > C API exist? If someone has more experience on this or knows a place where > I can find out more, plz let me know. I just ran this test on a

Commit and Rollback.

Hi, Will MySQL support COMMIT and ROLLBACK. Thank You Rajeev Ramanujan

Re:INNO How to set autocommit=0 as default for mysql

Andre, I did not find such an option in my.cnf. But I agree that there should be one. I will ask Monty to add that option to my.cnf. Regards, Heikki . Hi, I would like to set autocommit = 0 as the default value when running the mysql frontend. (Maybe with a

Database Error

Good Day: Could someone help me and tell me which direction to go to see why I'm getting unknown database error caught by the SQLException catch. I checked to make sure that the Class.forName was being executed and it was. Just need a little helping hand. Thanks... Greg __

INNO How to set autocommit=0 as default for mysql

Hi, I would like to set autocommit = 0 as the default value when running the mysql frontend. (Maybe with an entry in my.cnf) Is that possible ??? Andre -- E-Mail: [EMAIL PROTECTED] Date: 08-May-01 Time: 15:42:09 () Join the ASCII ribbon campaign against html

mysqlgui problem

I compiled all the components of MySQLgui without problems, but when I ran the mysqlgui program, I got the following error message: "error while loading shared libraries: libsqlplus.so.1: cannot open shared object file: no such file or directory." Can you help me? -Kingsley

Slow Loading page and query

Hi there, Using MySQL 3.22.27 and php3. The page I have does 7 queries to the database and then displays the page. The first time it runs it takes 9 secs or more before the data is displayed and then after that the thread is cached on MySQL. But when I run the same Query from MySQL console I ge

MyODBC General Question

Good Day: I was just wondering, if I'm using mm.mysql.jdbc-1.2c to connect to a database w/JAVA do I also need MyODBC installed and configured also? Or is mm.mysql.jdbc-1.2c all I need? Thanks alot.. Greg __ Do You Yahoo!? Yahoo! Auctions - buy

Re: Install problem

> I am having a problem installing the MyODBC drivers. I run setup but > nothing happens. Any ideas? > > David [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 f

Compilation error on HP-UX 11.00 with mysql-3.23.37

$ uname -a HP-UX mnemosyn B.11.00 U 9000/800 122901567 unlimited-user license $ cc -V /tmp/none.c cpp.ansi: HP92453-01 A.11.01.00 HP C Preprocessor (ANSI) ccom: HP92453-01 A.11.01.00 HP C Compiler $ aCC -V aCC: HP ANSI C++ B3910B A.03.13 $ LDFLAGS="+DA2.0W" CFLAGS="+DA2.0W -D_REENTRANT" CXXFLA

RE: AUTO_INCREMENT Confusion

Absolutely. I am using BDB tables and accessing them through mm.mysql JDBC. In a way I'm relieved; for a while there I thought I was losing my ability to read and understand a good technical book... Kevin McBrearty ATG Automation Technologies Group Ltd. > -Original Message- > From: Paul

RE: AUTO_INCREMENT Confusion

Absolutely. I am using BDB tables and accessing them through mm.mysql JDBC. In a way I'm relieved; for a while there I thought I was losing my ability to read and understand a good technical book... Kevin McBrearty ATG Automation Technologies Group Ltd. > -Original Message- > From: Paul

Performance MySQL with C-API

Hi, I've got a couple a questions concerning the speed of insert queries when using the C API from MySQL. I've written an application that receives data through a CORBA event channel and stores it in a MySQL database. The problem is that a lot of events are dropped. I think (I'm quite sure actual

Importing data from MS SQL 7 to MySQL

Hello, I am trying to transfer my Microsoft SQL Server to a MySQL Server running under Linux. Until now I have tryied the following methods. I installed DBtools 1.0.8 in a third machine running Win98 and connected to the MySQL server (Linux). I tried to import data from the Microsoft SQL serv

'invalid authorization specification' error

Hi, I am new to MySql. i have server runnng mysql-3.23.37-win under Windows NT i am using mm.mysql-2.0.4-bin JDBC driver to connect to mysql server. i am able to connect to mysql server from java program run on the same pc with host as 'localhost' or '127.0.0.1'. the ip address of the pc r

Re: Regarding SQL query with Unique

AVDHUT SHEDGE wrote: > > We want to get the Unique value from a table. > can we use the following query: > > select unique(ProblemNo) from MainProblem; > > where MainProblem is a Table having Column ProblemNo. > > the contents of ProblemNo are > 1 > 1 > 2 > 2 > 3 > 3 > 3 > > the result of the

Re: MySQL Help

Salvador Casquero Algarra wrote: > > Hi, > > I am having a terrible problem with MySQL and I am desperated as > nobody seems to find the source. I have a Web site ( www.genteirc.com ) > whith MySQL database access. The problem is that those Mysql processes are > growing continuou