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.
Identifier
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 w
(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 undo,
Rhino wrote:
- Original Message - From: "John Meyer" <[EMAIL PROTECTED]>
To: "List: MySQL"
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 aut
- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To: "List: MySQL"
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 authors who are
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:http://list
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 case,
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 due
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 m
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: Tuesd
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
answer
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
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
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
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 went through a lot of trouble with Load data local infile... There are a
lot of things regarding Local that MySql does not allow due to security
reasons. As mentioned before this you could give us the error... that might
help
alternatively try out mysqlimport
http://dev.mysql.com/doc/refman/5.
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
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 MySQ
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
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 10
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
) ENGINE=Inn
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]
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
pr
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 i
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
``-syntax.
Example:
create table astronomicalvskeywords (
`dec` float not null,
`ra` float not null
);
...will create:
desc astronomicalvskeywords;
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 func
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, For
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 it'
[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
backtick
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
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, o
[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 server
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 o
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 co
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
-
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]
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: http://dev.mysql.com/doc/refman/5.0/en/cannot-find-table.htm
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
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
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 Inn
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
41 matches
Mail list logo
