Re: Ordering field names in a "DESC / DESCRIBE table" or "SHOW COLUMNS from table" command

2010-01-14 Thread Ricardo Dias Marques
Hi Peter (and MySQL list), On Wed, Jan 13, 2010 I (Ricardo Dias Marques) asked the following : >>It would be convenient for me to get a list of those fields ordered by >>field / column name. ... and on the same day, Peter Brawley kindly replied: > SELECT * > FROM informat

Ordering field names in a "DESC / DESCRIBE table" or "SHOW COLUMNS from table" command

2010-01-13 Thread Ricardo Dias Marques
g the wrong keywords for my searches). So, I'm asking this: does anyone know a MySQL command to get this list of fields sorted by field name? Or do you achieve this result by other means (e.g: using some GUI tool, copying the list of fields to a text file and sorting it, writing some scrip

Re: catch the error

2009-02-26 Thread Ricardo Dias Marques
e "mysql_connect" result to that $db variable. So, I think that you will solve your problem by changing your "mysql_connect" line FROM the current form: mysql_connect('biggie', 'user', 'password', 'test'); .. TO this one: $db = mysql_connect(

Re: Suse Linux (SLES10), Portuguese characters and "dead keys" in "MySQL monitor" in SSH sessions with Unicode (UTF-8)

2007-08-08 Thread Ricardo Dias Marques
m UTF-8 back to ISO-8859-1? *Or* do you enter directly as "root", as I'm doing now (to work around this issue)? *Or* do you simply do NOT type accented characters directly in the MySQL Monitor (that is, the command line mysql client)? Thanks in advance for any info that you may

Suse Linux (SLES10), Portuguese characters and "dead keys" in "MySQL monitor" in SSH sessions with Unicode (UTF-8)

2007-07-31 Thread Ricardo Dias Marques
UTF-8" LC_ALL= My sshd_config file DOES have the following lines, at the end: AcceptEnv LANG LC_CTYPE LC_NUMERIC LC_TIME LC_COLLATE LC_MONETARY LC_MESSAGES AcceptEnv LC_PAPER LC_NAME LC_ADDRESS LC_TELEPHONE LC_MEASUREMENT AcceptEnv LC_IDENTIFICATION LC_ALL The SSH Daemon of the Linux Serv