SQL Help

[Funny]

This is a easy code but I am not able to figure it as Im fairly new to SQL.

Example I have a table like this-
Name: ID:
abcde 1
efghia 3
pofjsa 5
asklda 6

I want to sort the tables according to increasing ID.
Like this-
Name: ID:
abcde 1
efghia 2
pofjsa 3
asklda 4


Assuming that the ID's are continuously increasing but there are some ID's missing like 11,14,15,16,17,20,21.. etc

Thanks

Funny Reviewed by Funny on 7th Feb 2012. SQL Help This is a easy code but I am not able to figure it as Im fairly new to SQL. Example I have a table like this- Name: ID: abcde 1 efghia 3 pofjsa 5 asklda 6 I want to sort the tables according to increasing ID. Rating: 5

[soft2050]

Simply use ORDER BY column_name here in your sql query

Example:

SELECT * FROM mysecrettable ORDER BY names 

[Mr Happy]

Just to add to the above you can have ORDER BY something DESC or ORDER BY something ASC
which means you can have it decreasing (DESC) or ascending (ASC)

[Lock Down]

I believe soft meant to say :

SELECT * FROM mysecrettable ORDER BY id asc 

[soft2050]

nah
That would make it from ascending order of the id of the column
Specifying the name of the field would result in the data output in acending order of the column.

http://php.about.com/od/learnmysql/p/SQL_order_by.htm

[Lock Down]

This is a easy code but I am not able to figure it as Im fairly new to SQL.

Example I have a table like this-
Name: ID:
abcde 1
efghia 3
pofjsa 5
asklda 6

I want to sort the tables according to increasing ID.
Like this-
Name: ID:
abcde 1
efghia 2
pofjsa 3
asklda 4


Assuming that the ID's are continuously increasing but there are some ID's missing like 11,14,15,16,17,20,21.. etc

Thanks

He said he wanted it by id. check his quote again.

And I guess you can use this link http://php.about.com/od/learnmysql/p/SQL_order_by.htm and one for reading http://www.rif.org/

[Funny]

Thank you for the help guys.

[Funny]

Now I have another question-
I want to update a column in my sql but I think I got the syntax wrong-

UPDATE `url` SET `destination`="http://"+`destination` WHERE `destination` NOT LIKE 'http%'

It sets destination as 0 instead of http://+destination..

[Halcyon]

Use || for concatenating strings

UPDATE `url` SET `destination`='http://'||`destination` WHERE `destination` NOT LIKE 'http%'

[Lock Down]

You are welcome and for the update..
try this one:

UPDATE `url` SET `destination`=concat("http://",`destination`) WHERE `destination` NOT LIKE 'http%' 

PS backticks are a pain and most systems work without them.

so it could be simply:

UPDATE url SET destination=concat("http://",destination) WHERE destination NOT LIKE 'http%' 

BY the way when you use + mysql tries to add..

when you use || it means or not concat...