Re: Password storage

Use MD5 function to encrypt the password column C K wrote: Friends, I have one question - How to store passwords in MySQL database table in a secure way so that no one can see the password(understand the password string)? Please help Thanks CPK -- Yoge, AdventNet, Inc. 925-965-6528

Re: Mysql monitering and performance tool

Thanks Yoge krishna chandra prajapati wrote: Hi Everybody, I am looking for a tool which can moniter mysql and if any thing goes wrong with mysql then it can send a mail or alert. It can show the innodb status and all the complete details about mysql. Regards, Krishna -- Yoge, AdventNet, Inc

Re: Greater function ?

You can use IF function ... */IF(last_conneciton_date> insert_date,last_conneciton_date, insert_date)/* --Yoge [EMAIL PROTECTED] wrote: Hi all, I'm looking for the mysql equivalent to oracle Greater function. In fact, I want to order by the greater of two timestamp fields order by

Re: monitoring mysql

You can use the Application Manager <http://appmanager.com> to monitor your mysql server. For more info http://manageengine.adventnet.com/products/applications_manager/mysql-management.html http://manageengine.adventnet.com/products/applications_manager/index.html --Yoge Baron Schwartz

Re: DELETE query help please?

Item, ItemTag WHERE ItemTag.TagID = '168' AND ItemTag.ItemID = Item.ProductID; but I'm not sure how to go about it. Can anyone help? Thanks Mark -- Yoge, AdventNet, Inc. 925-965-6528 [EMAIL PROTECTED] site24x7.com -- MySQL General Mailing List For list archives: http://l

mysql ended problem

ySql Version is 4.0.20 I have attached my.ini file with this mail Thanks in Advance for your help. --Yoge #This File was made using the WinMySQLadmin 1.0 Tool #12/27/02 2:51:42 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld]

Re: I'd like to know SQL query for table description.

Try this query - show table status from YourDatabaseName; ninjajs wrote: Hi. ALL i have a database in MySQL. A middleware request to MySQL DB server. and then, result is table description. ex) dbms_type,table_name,column_name,data_type,data_size,constraint_type What SQL query can I get this infor

Re: distinctSelection(veryUrgent)

select * from secondtable left outer join second.flower=first.flower and second.color=first.color where first.flower is NULL N. Kavithashree wrote: hello, i m using mysql 4.0.18-standard version it is not accepting subqurries. problem is: i have 2 tables: First(id,Flower,Color); => color is ch

Re: how to select last records

To select row 10 to 30 below query might be useful select * from mytable limit 10,20; The query will list 11th record to 30th record. N. Kavithashree wrote: hello, ususally we use : select * from table limit 50; This will display the rows which were entered first the table created (i..e, that end

Re: If statement in a where query....

Check whether below query helps u ? Select * from db where IFNULL(last_renewal_date,signup_date) between '2004-11-01' and '2004-11-30' Regards --Yoge Mike Morton wrote: I am trying to find a list of people based on renewal dates, the logic of the query would be: Select ev

Doubt in Isolation level

there any side effects for this?. Thanks in advance for your suggestions. --Yoge