Hi! All

I am working with database mysql5.0 on my system.
But when i upload every thing in web it is not recognising
host as http://205.178.146.79/
and giving
Warning: mysql_connect()...

That means u are not getting what i wrote.

I clearly mentioned that go through this query and correct it as needed.

In my sense its the correct way to learn something.

Hi!
Try this..
create table data2 as select rpad(name,10,' ') as name from data
select length(name) from data2

here i am creating a table with the select statement to find out the length on...

Hi!
Try this one but go through the query and apply as you need.
for any problem regarding this bug me.

select tblbcategory.bCategoryId,tblbcategory.bCategoryName,

if(COUNT(tbltopic.TopicId),...

Hi!
Try this
select if(name='Jon',replace(name,'Jon',''),name) as name from data

Regards,
Manoj

Hi Vele,

You can try this one--
select id, title from data where title LIKE '%PHP developer%' union select * from data

The above query will return the exact string with all other rows in the...

I am writing a stored procedure in which i want to catch all the exceptions.So. i need how to catch the error code from an exception.