[PHP-DB] A new GUI client for mySQL

greetings... Webyog has released mySQLyog, a win32 based Query analyzer. Its FREE and gives all the features that a mysql developer can ask for by a query analyzer. please visit www.webyog.com you can execute query of results of more than 10 records, supports multiple query execution and you

[PHP-DB] Re: last 10

Crosswalkcentral [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... How can i obtain the last 10 entries that are in mydatabase that have a certain colum set to 1? SQL does not guarantee to return your records in any specific order unless you use an ORDER BY

[PHP-DB] indexing text fields in mysql ?

Hi there, I am wondering if it would be anyhow possible to make a search on a textfield faster. Right now the table contains 294000 entries and takes about 40 MB of space. Is there a way to apply a index with a resonable amount of disk space? I am also not so sure if I should use text or

[PHP-DB] mysql crashed and created huge .MYI files. All data lost? :-((

Hi there, during a wrong select statement on a table containing over 2 mill. records (involving other tables) mysql and the whole linux server crashed. After rebooting I did run myisamchk and this reported that some tables are damaged but still can be read. So I did shut down the server und

[PHP-DB] Re: mysql connection problem

Sounds like you don't have privileges to access the server from the host you're using. You need to establish privileges in the appropriate mysql db tables (user, db, host, etc) to allow access from the host from which you are attempting to connect. Christian Weilbach [EMAIL PROTECTED] wrote in