Oracle , what else ?

hello people, bad joke is not it ? After MySQL bought by the java maker, and now Sun bought by Oracle, what are we gonna run as RDBMS ? _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - g...@iap.fr 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

how to display numbers with exponent

/refman/5.0/en/precision-math-numbers.html thanks. _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

default, Nullable and NULL : confused

| +-+--+ mysql select * from t where c is null or n is null; Empty set (0.00 sec) For my purpose, '0' , '' and NULL Thank you for any help. regards, _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http

how to suppress the SHOW WARNINGS limit ?

be painfull to look at billion of warnings... but) SET max_error_count=1000; Is there just a way to suppress the limit , and so never being limited to 64 default value ? thanx ! _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list

MySQL 5 et les charset sur debian etch

:cçoôeêeèeëi 4:EÉEÈEË 5:c'est tout _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

problems with accents and display alignement

mysql CREATE TABLE t2 (id int(10) unsigned NOT NULL auto_increment,nom varchar(255) NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=UTF8; after loading the file data2, I display the content _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General

columns_priv : how it works ? [ MySQL 4.1 ]

! _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: revoke SELECT on a column [ MySQL 4.1 ] + column Comment

Hello, thanks again to ViSolve DB Team. so, it turns out that for MySQL4.1, il will have to built a sql file, built with script (shell or perl). [ note that so far I use MySQL 4.1 on production server, and I only test features on MySQL 5 on an other machine linux Debian]. at last, my LAST

Re: revoke SELECT on a column [ MySQL 4.1 ] + column privileges

'a_user'@'localhost' identified by 'a_passwd'; Note: Always TABLE PRIVILEGES override COLUMN PRIVILEGES Thanks ViSolve DB Team - Original Message - From: Gilles MISSONNIER [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, February 06, 2007 11:05 PM Subject: revoke SELECT

revoke SELECT on a column [ MySQL 4.1 ]

? regards, _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to take advantage of STR_TO_DATE

dispaly, go for DATE_FORMAT(). For Instance, mysql select DATE_FORMAT('2007/10/01','%d/%m/%Y'); or mysql select DATE_FORMAT(datecolumn,'%d/%m/%Y') from table1; Thanks ViSolve DB Team - Original Message - From: Gilles MISSONNIER [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday

how to take advantage of STR_TO_DATE

? how to do this ? regards, _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

solved : Re: system : Install Mysql 5.x binaries with php4 on Debian

('the_password') WHERE User='the_user'; regards to all, this list is great, mysql too. - gilles - On 13 Dec 2006 at 18:59, Gilles MISSONNIER wrote: Hello, I use Debian Linux, and I could install (with apt-get install) fine the Mysql-4.1+apache+php4. I

system : Install Mysql 5.x binaries with php4 on Debian

? thank you _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

geometry with MySQL-5.0

Hello, I am discovering the Spatial Extensions features of MySQL-5.0 Is there a way to use a spherical geometry ? (instead of Euclidean) like for navigation, or on sky coordinates,... _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives

question+comment : Re: set DEC as a column name : forbidden

+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-quoting

Re: question+comment : Re: set DEC as a column name : forbidden

on the same page telling about - maximum length, - Unicode, - ANSI_QUOTES SQL mode, - default character set - recommendation on naming == Hope not being asking too much. regards. -Gilles Missonnier - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

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

) For all the Databases. == Gilles Missonnier IAP - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

set DEC as a column name : forbidden

. Is there a turn around ? This is annoying ; I add to name the column as DECL which is much less meaning full in the astronomy community. thanks, =_==_==_==_==_==_= =¯==¯==¯==¯==¯==¯= Gilles Missonnier IAP - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: grant modify, doc on grant.

, sheeri kritzer wrote: GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd'; It won't set up a new account, just add the privilege for you. -Sheeri On 5/26/06, Gilles MISSONNIER [EMAIL PROTECTED] wrote: Hello How to set FILE privilege enable to an already defined user ? It seems

grant modify, doc on grant.

. =_==_==_==_==_==_= =¯==¯==¯==¯==¯==¯= Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: describe table : improvement

keyword: CREATE TABLE a_table ( a_column CHAR(30) CHARSET utf8 COMMENT 'Some comment' ); Is this... what you needed ? -- Gabriel PREDA Senior Web Developer =_==_==_==_==_==_= =¯==¯==¯==¯==¯==¯= Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list

describe table : comment (some progress done, but...)

=_==_==_==_==_==_= =¯==¯==¯==¯==¯==¯= Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

describe table : improvement

of a field. Extra is to be used for other info. I could make a table especially for this purpose : create table comment (field varchar, comment varchar); but this will end into inconsistency at last [ 2 times the same field ]... Any ideas ? cheers. = Gilles Missonnier IAP - [EMAIL

describe table : improvement ?

but could not figure out how to do what I want. I could make a table especially for this purpose : create table comment (field varchar, comment varchar); but this will end into inconsistency at last [ 2 times the same field ]... I run MySql 4.0.24 Any ideas ? cheers my-folks ! = Gilles

RE: good database design

I agree totaly to what Sujay Koduri writes : http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html My 2 cents.. Before you actually start worrying about the performance tuning of database parameters or hardware required for the DB, you should make sure that you have designed

how do I select among 2 columns ?

Hello, a simple question : I have a table like this : name, email_1, email_2 and I want to display in a web page name, email_1 if it exists, or email_2 if email_1 do NOT exist. of course I can do this inside a php script, by checking the content of the columns, BUT I had like to get the values

need help to display values but only when NOT NULL.

how to do that. any hints ? == Gilles MISSONNIER - Projet Terapix phone : [33] 01 44 32 81 36 http://terapix.iap.fr - Before posting, please check: http://www.mysql.com/manual.php (the manual

how to select only NOT NULL fields ?

that are NULL. and I would try something like : mysql select * from tabID where tabID.login='john' and tabID.* NOT NULL; but the syntax is wrong ... the point is : how to use the * or a wild card ? my MySQL version is 3.22.22 on DIGITAL osf1 cheers, == Gilles