case sensitive table names in mysql-5.0.21

Hello, I am using MySql-5.0.21 on Suse-Linux-10, i created tables using lowercase names for example ; mysql create table a (id int); Query OK, 0 rows affected (0.04 sec) mysql select * from A; ERROR 1146 (42S02): Table 'mysql.A' doesn't exist mysql select * from a; Empty set (0.01 sec) I have

Re: ugly SQL for a report...

Slightly new query.. Here's the new query and results of an explain.. I'm thinking that some indexing would help.. However, I don't really know where to start. --- EXPLAIN SELECT pnr.ID ID_pnr, pnr.reservationdatetime, pnr.conf_number, pnr.created_by,

Re: case sensitive table names in mysql-5.0.21

Hello, I am using MySql-5.0.21 on Suse-Linux-10, i created tables using lowercase names for example ; mysql create table a (id int); Query OK, 0 rows affected (0.04 sec) mysql select * from A; ERROR 1146 (42S02): Table 'mysql.A' doesn't exist mysql select * from a; Empty set (0.01 sec) I have

Re: What's wrong in this Innodb status log?

Nico, please post more output. Maybe the SELECT from H.albero is just entering InnoDB, and therefore the associated transaction has not yet started. The output shows lots of file reads. There should be running queries visible in other printouts. Best regards, Heikki Oracle Corp./Innobase

Re: innodb database crash

Vitaliy, - Original Message - From: Vitaliy Okulov [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, May 26, 2006 5:28 PM Subject: innodb database crash Hi all. I have some InooDB mysql crush logs, can somebody explain what they mean? Quote: 060525 18:09:43

Re: InnoDB corruption and crash on Windows 2000

Andrew, a possible reason for the corruption is that you have enabled write caching in the disk controller or in the disk, but those caches are not battery-backed. Then a hard reboot may destroy the contents, and the database becomes corrupt. What kind of hardware are you using? Do you have

Re: MySql Limitations??

Hey guys... Thanks a lot... Guess I will stick with MySql then harish On 5/30/06, peter lovatt [EMAIL PROTECTED] wrote: Hi We have tables of 1.5M rows 25 fields, in heavy use with frequent inserts and updates on a P4 with 1GB of RAM. Performance is fine, and the table size is 400MB,

Re: case sensitive table names in mysql-5.0.21

Hi, yes it makes a huge difference, as the tables are stored in files and therefore if the filesystem is case-insensitive (Windows) you can use either case in your queries, while on a case-sensitive filesystem (linux etc) you can't. See:

Re: MySql GUI

Dan Trainor wrote: I highly suggest staying away from PHPMyAdmin. :-\ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySql GUI

At 10:23 +0200 30/5/06, Anthony wrote: :-\ Very helpful - thanks. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ What contemptible scoundrel has stolen the cork to my lunch? -- W.C. Fields

Re: How to find out about SSL connection?

On 21.05.2006 00:16 (+0100), Yves Goergen wrote: Hello, I'm using MySQL Query Browser on Windows XP to connect to a remote MySQL 4.0 and 5.0 database server, both on Linux. In Query Browser, I can check the options Use SSL if available but how do I know if it is available and used? I couldn't

MySQL Clustering

Dear MySQL, I am interested in clustering for MySQL. This claims to offer the redundancy scalability and performance we require. One thing I am really disappointed at is that clustering seems not to offer much Referential Integrity (RI). Specifically, Foreign Key References. For better

RE: MySql Limitations??

[snip] I need to store something like a couple of million rows is a MySql table. Is that ok or do I have to split them up. I intend to index each of the columns that I will need to access so as to speed up access. Insertion will be done only when there is very little or no load on the

[solved] Re: grant modify, doc on grant.

Thanks Dilipkumar, the syntax works fine mysql grant file on *.* to 'wr'@'localhost'; so the file privilege is for ALL databases. by the way, to allow alter, the syntax is like : mysql grant alter on dr4.* to 'wr'@'localhost'; here the alter privilege is specific to a database, on a

set DEC as a column name : forbidden

Hello I could not find the answer through the online Search the MySQL manual. I run MySQL 4.1 In astronomy, RA and DEC are widely used coordinate names. Then I try to add a column named DEC : mysql alter table my_table add dec float; ERROR 1064 (42000): You have an error in your SQL syntax;

RE: set DEC as a column name : forbidden

[snip] It seems that the reason is that DEC is a keyword standing for decimal. I do not understand why this cannot be allowed for a column name. [/snip] There are several reserved keywords in MySQL, none of which are recommended for column names. You can try the SQL statement using backticks

RE: MySQL Clustering

Hello, We are aware that some user require FK's and would like to see them supported in MySQL Cluster. We are hoping to offer this functionality initially through the MySQL interface (not the NDB API) some time next year. Look for announcements on the MySQL Cluster forum and mailing list for

Re: MySQL Clustering

At 12:47 pm +0100 30/5/06, Ben Clewett wrote: I am interested in clustering for MySQL. This claims to offer the redundancy scalability and performance we require. One thing I am really disappointed at is that clustering seems not to offer much Referential Integrity (RI). Specifically, Foreign

Re: MySQL Clustering

Jimmy, Thanks for the info. I'll look out for FK's in clustering and hopefully we can do some testing at that time. Regards, Ben Jimmy Guerrero wrote: Hello, We are aware that some user require FK's and would like to see them supported in MySQL Cluster. We are hoping to offer this

Re: set DEC as a column name : forbidden

Hi Gilles! Just use `dec` and it will work fine. DEC is as you suspected a reserved word and can only be used as column namne if you put it in `column`-syntax. Example: create table astronomicalvskeywords ( `dec` float not null, `ra` float not null ); ...will create: desc

Re: How to find out about SSL connection?

Hi Yves, all! Yves Goergen wrote: On 21.05.2006 00:16 (+0100), Yves Goergen wrote: Hello, I'm using MySQL Query Browser on Windows XP to connect to a remote MySQL 4.0 and 5.0 database server, both on Linux. In Query Browser, I can check the options Use SSL if available but how do I know if it

Re: [solved] Re: grant modify, doc on grant.

Firstly, I apologize for my incorrect db level grant in the syntax I posted. Secondly, by going to mysql.com/grant I found the GRANT syntax page, which states: The FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SHOW DATABASES, SHUTDOWN, and SUPER privileges are administrative

measuring query time

Is there a way to get the time spent in the server for each query? Write it in a log or append it to the result ??? Thanks, Deniz Ersoz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem in using LOAD DATA LOCAL INFILE

What's the error you are getting? What MySQL version are you using? On 5/26/06, Neeraj [EMAIL PROTECTED] wrote: Hi all I have a table with following structure CREATE TABLE `dsc` ( `ch_code` varchar(255) default NULL, `name` varchar(255) default NULL, `inof` blob )

Help Please: ERROR 1010 (HY000): Error dropping database (can't rmdir '.\a', errno: 41)

I am using MySql 5.0.21-community Edition for widows XP. I can successfully connect to the MySql Server as a root and create a database 'a'. Which creates a directory 'a' under my mysql\data directory with a single file 'db.opt'. Now dropping the database 'a' gives the following error ERROR

Re: Running Two Different Versions of MySQL

http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html -Sheeri On 5/29/06, Michael Monaghan [EMAIL PROTECTED] wrote: Hi, I have a machine [Solaris 9 x86] that has MySQL v3.22.xx installed. I am not familiar with the applications [quite a few] that use this instance. I need to install

Re: LOAD DATA FROM MASTER stops unfinished with Query OK

If it worked on your test box, but not in production, what is different about those 2 boxes? Common sense says If it worked on one box but not another, it's not the software, but a difference between the 2 boxes. And you can always file a bug report with MySQL or get a consultant (through MySQL

Re: Binding mysql to more than 1 ip address but not to all

People who've asked the same question have gotten the answer that it's not possible with MySQL, if I'm remembering correctly. -Sheeri On 5/29/06, Ghaffar [EMAIL PROTECTED] wrote: Hello all, I have seen that there are some people asking the same question. How to bind to multiple ip addresses

Re: Running Two Different Versions of MySQL

Ah yes, the docs. - Thank you. ~mm On 5/30/06, sheeri kritzer [EMAIL PROTECTED] wrote: http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html -Sheeri On 5/29/06, Michael Monaghan [EMAIL PROTECTED] wrote: Hi, I have a machine [Solaris 9 x86] that has MySQL v3.22.xx installed. I am

Re: How to find out about SSL connection?

On 30.05.2006 16:28 (+0100), Joerg Bruehe wrote: To find out whether your server(s) support(s) or not, you need to check the corresponding variables. All this is described in the manual, section 5.9.7. Using Secure Connections: I still think that the client should actually inform me when I

Re: select 9000000000000.10*19.80 wrong result 178200000000001.97

Hi Wang, select 9.10*19.80 wrong result 1782001.97 if = 9000.10*19.80 right result178201.98 This is similiar to sum(qty*unitpri) result . Welcome to the world of floating point arithmetic. If you need such precision, try MySQL 5.0, as it should

Re: select 9000000000000.10*19.80 wrong result 178200000000001.97

At 13:13 -0700 5/30/06, Jeremy Cole wrote: Hi Wang, select 9.10*19.80 wrong result 1782001.97 if = 9000.10*19.80 right result178201.98 This is similiar to sum(qty*unitpri) result . Welcome to the world of floating point arithmetic. If you need

Re: select 9000000000000.10*19.80 wrong result 178200000000001.97

wang shuming wrote: Hi, select 9.10*19.80 wrong result 1782001.97 if = 9000.10*19.80 right result178201.98 This is very typical floating point error. Computers don't have infinite precision or it would take infinite time to compute the

RE: select 9000000000000.10*19.80 wrong result 178200000000001.97

You don't need to take it to 16 digits : mysql 4 : select 1/666; +---+ | 1/666 | +---+ | 0.00 | +---+ mysql 5.0.18: select 1/666; ++ | 1/666 | ++ | 0.0015 | ++ George Law -Original Message- From: Chris W [mailto:[EMAIL PROTECTED] Sent:

Re: select 9000000000000.10*19.80 wrong result 178200000000001.97

Hi, You don't need to take it to 16 digits : mysql 4 : select 1/666; +---+ | 1/666 | +---+ | 0.00 | +---+ mysql 5.0.18: select 1/666; ++ | 1/666 | ++ | 0.0015 | ++ Actually, this is an entirely different case, it's a matter of where MySQL decides how

Re: select 9000000000000.10*19.80 wrong result 178200000000001.97

George Law wrote: You don't need to take it to 16 digits : mysql 4 : select 1/666; +---+ | 1/666 | +---+ | 0.00 | +---+ mysql 5.0.18: select 1/666; ++ | 1/666 | ++ | 0.0015 | ++ That has nothing to do with the precision of the calculation. It is

Re: select 9000000000000.10*19.80 wrong result 178200000000001.97

At 13:46 -0700 5/30/06, Jeremy Cole wrote: Hi, You don't need to take it to 16 digits : mysql 4 : select 1/666; +---+ | 1/666 | +---+ | 0.00 | +---+ mysql 5.0.18: select 1/666; ++ | 1/666 | ++ | 0.0015 | ++ Actually, this is an entirely different

Query problem

Setup TITLES: TITLE_ID AUTHORS: AUTHOR_ID TITLE_AUTHOR: (TITLE_ID,AUTHOR_ID) Problem: Given a title, I need to find all the authors who aren't connected with that particular book. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Query problem

- Original Message - From: John Meyer [EMAIL PROTECTED] To: List: MySQL mysql@lists.mysql.com Sent: Tuesday, May 30, 2006 5:09 PM Subject: Query problem Setup TITLES: TITLE_ID AUTHORS: AUTHOR_ID TITLE_AUTHOR: (TITLE_ID,AUTHOR_ID) Problem: Given a title, I need to find all the

Re: Query problem

Rhino wrote: - Original Message - From: John Meyer [EMAIL PROTECTED] To: List: MySQL mysql@lists.mysql.com Sent: Tuesday, May 30, 2006 5:09 PM Subject: Query problem Setup TITLES: TITLE_ID AUTHORS: AUTHOR_ID TITLE_AUTHOR: (TITLE_ID,AUTHOR_ID) Problem: Given a title, I need to

report of last transaction?

(Excuse the beginner's question, but I couldn't find an answer in the documentation or in searching online. Please cc me on replies if possible.) Does mysql have a way to report on the last committed change to the database? I gather there is no undo in databases, in the sense of an editing

Re: set DEC as a column name : forbidden

You are right, the DEC is a reserved keyword in the MySQL system. We use DE in our databases, which will be better then DECL. cheers, Gilles MISSONNIER wrote: Hello I could not find the answer through the online Search the MySQL manual. I run MySQL 4.1 In astronomy, RA and DEC are widely

Re: set DEC as a column name : forbidden

At 15:46 +0200 5/30/06, Gilles MISSONNIER wrote: Hello I could not find the answer through the online Search the MySQL manual. I run MySQL 4.1 In the 4.1 manual, the reserved words are listed here: http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html DEC is in the list.