try select * from table where field2=0 order by field3 desc limit 30
I think you need the column to compare.
> If I have a query like:
>
> select field1 from table where field2=0 order by field3 desc limit 30;
>
> and I have keys:
>
> key field2 (field2)
> key field3 (field3)
>
> Will MySQL u
this is a php question, try:
http://www.php.net/manual/en/function.number-format.php
> Hi,
>
> I just want to know if mysql can set the output of a certain currency to
> this pattern :
>
> $1,500.00
>
> If I use a comma on a certain amount then I add it up to another amount with
> a comma I ge
when I installed mysql 3.23.43 it instructed me to be sure to add a password with the
following results-
:
seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password'
Enter password:
/usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'r
How do I get rid of the MySql column in Welcome to phpMyAdmin 2.2.6 page?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
what dir is mysql.sock in?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubsc
I have a database called test
in the mysql database db table it is listed as
"test" and "test\_%"
what is the significance of two record that have all the Y/N entries the same?
.
-
Before posting, please check:
http://ww
seaport:/# mysqladmin -h `hostname` version variables
mysqladmin: connect to server at 'seaporthost.com' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
What does this mean?
Dave
-
Before posting
is there a password file accessable from root for mysql?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <
I seem to have lost the "mysql" database tables.
I have other databases that work.
what is the best way to add the right tables to mysql
Dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht