Select and Sort?

Hi All, I am wondering how to do that. Suppose we have data like this below ID Category - 1 Software Engg 2 Engg 62 Commerce 87 Ecommerce 45 physics 95 chemistry 6 biochemistry 7 math 5 Others I want to achieve recordset like below (sorting category by Name and

Re: Select and Sort?

Thanks for help. here is another solution for that... SELECT if (Category = 'others', '999', 0) as priority, ID, Category FROM TableName ORDER BY priority, Category Tariq Fred van Engen wrote: On Tue, Dec 10, 2002 at 03:32:13PM +0500, Tariq Murtaza wrote: I want to achieve recordset like

Unicode support?

Dear All Hope you are all fine and doing well. I would like to know the status of unicode support for mysql. I will appreciate if someone share his/her experience regarding data manipulation in unicode on mysql. Best Regards, Tariq Murtaza -- MySQL General Mailing List For list archives

How much user LOAD can Mysql bear???

Hi All! How much user LOAD can Mysql bear before die. Regards, Tariq -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How much user LOAD can Mysql bear???

the hardware and software. How much information are you storing in the DB? Any replication? Regards, Adam -Original Message- From: Tariq Murtaza [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 8:40 AM To: [EMAIL PROTECTED] Subject: How much user LOAD can Mysql bear??? Hi All

Weird problem for TIMESTAMP feild

Hi All, I am getting very weired problem after shifting our server. here is the details:- I have a table with two columns 1-TimeStamp timestamp(14) 2- SID bigint(20) when inserting _INSERT INTO _/_TABLENAME values (1258975462,125987)_ results in /_INSERT INTO _/_TABLENAME values

Best practices for sharing members database between different portals

Dear All, Please comment on Best Practices for sharing members database between different portals. Suppose we have 3 portals running on different networks. Assignment is to make a single Login/Pass for all portals, means once LogedIn in one of the portal, could able to access the other portals

Guru's advice needed ........[Security: SQL injection]

*Dear Friends!* Can someone shed some light on how SQL injection attack occurs when *magic_quotes_gpc *isON and how it prevents when its OFF. To my understanding apostrophise are escaped automatically in POST/GET/COOKIE when its ON, so how it tends towards SQL Injection. Someone suggested

stuck with simple query..... Plz have a look

We have two tables Table1: - ID |Name 1 |name1 2 |name2 3 |name3 4 |name4 Table2: --- PL | PC