| |
| |
| |
|
Comments:
<0> hello, how can i get the number of chars the biggest value in a column has?
<1> select length(col) from table order by col DESC limit 1.... ?
<2> CHAR_LENGTH
<2> length returns bytes
<1> indeed it does
<0> selext max(length(column)) from table
<2> and did that work for you?
<3> when i take something out from mysql can i limited to take only one value exemple if in dabase is values : a a and b. to take only a and b ?
<2> distinct
<3> how ?
<3> is it on query ?
<3> or after ?
<2> SELECT DISTINCT ...
<3> mysql_query("SELECT * FROM
<3> here i put : mysql_query("SELECT DISTINCT FROM
<3> like this ?
<3> or distinct *
<2> http://dev.mysql.com/doc/refman/5.1/en/select.html
<3> excelent !
<3> thanks
<3> what type of table have to make to can put number like 22.1 ?
<4> is there a function i can use to select records randomly?
<4> i mean the results will be random ordering or records
<5> how can i make query that return all columns in my table?
Return to
#mysql
or
Go to some related
logs:
pantherebel
masachutes
chpasswd + setuid: Operation not permitted
#c
the file is ''corrupt arhive'' problem
#london
sshfs darwin
#MissKitten
#java
#linux
|
|