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 To

how to display numbers with exponent

nd http://dev.mysql.com/doc/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

+ | n | c| +-+--+ | 0.12345 | qwer | | 1.2345 | | | 0 | asdf | +-+--+ 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, _-¯-_-¯-_-¯-_

how to suppress the SHOW WARNINGS limit ?

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

file '/le_repertoire/t' into table t fields terminated by ':'; et le fichier t contient : 1:aàb 2:été 3: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

quot;space" before each "end of line" character 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 Misson

columns_priv : how it works ? [ MySQL 4.1 ]

Column_priv". What is wrong ? (I have done any way "flush privileges;" ) cheers ! _-¯-_-¯-_-¯-_-¯-_ 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 Q

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

_schema.column_privileges; mysql> REVOKE SELECT(hide_this) ON the_base.t100 from 'a_user'@'localhost' identified by 'a_passwd'; Note: Always TABLE PRIVILEGES override COLUMN PRIVILEGES Thanks ViSolve DB Team - Original Message - From: "Gilles

revoke SELECT on a column [ MySQL 4.1 ]

7; on table 'current' Is there a turn around, or should grant the select on the 99 other columns ? 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

given format string to datetime value. So to change the format of the 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 D

how to take advantage of STR_TO_DATE

like "15/10/1999" then run a mysql procedure that use STR_TO_DATE to fill a date column ? 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

OLD_PASSWORD('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 instal

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

; doesn't help. any hint? 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

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

the relevant point for me was : The identifier quote character is the backtick (`): And it is found on the same page telling about - maximum length, - Unicode, - ANSI_QUOTES SQL mode, - default character set - recommendation on naming == Hope not being asking t

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

========= On Tue, 30 May 2006, Paul DuBois wrote: 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

set "DEC" as a column name : forbidden

ot understand why this cannot be allowed for a column name. 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 PRO

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

le on *.* to [EMAIL PROTECTED] identified by 'db123'; Query OK, 0 rows affected (0.03 sec) 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]

Re: grant modify, doc on grant.

alhost' IDENTIFIED BY 'the_passwd'; ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES - On Fri, 26 May 2006, sheeri kritzer wrote: GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd'; It won't set up a

grant modify, doc on grant.

tree-like doc. otherwise most people will continue to consider that grep into a file is fine for "database". =_==_==_==_==_==_= =¯==¯==¯==¯==¯==¯= 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 : comment (some progress done, but...)

ers =_==_==_==_==_==_= =¯==¯==¯==¯==¯==¯= 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

dd a comment using COMMENT 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 --

describe table : improvement

cribe the meaning 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. =

describe table : improvement ?

Any ideas ? cheers my-folks ! = 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]

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 t

need help to display values but only when NOT NULL.

turned, and if the item is NOT NULL I display it. I do not know how to do that. any hints ? == Gilles MISSONNIER - Projet Terapix phone : [33] 01 44 32 81 36 http://terapix.iap.fr - Before posti

how to select only NOT NULL fields ?

d ? my MySQL version is 3.22.22 on DIGITAL osf1 cheers, == 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)