I have a database with about 150 tables in it.

Now I wanted to copy all of the tables with something like tablename_copy at the end of each table.

Also the data that will go in each of the...

How do I analyze all tables in a database?

Sorry how do you update only one column?

In my mysql table there are following values:

ID (unique)(Auto incre.)
INI
URL
Name
DeprSize
Dept. Location
Knownsince
MeetingNotes

I have a column "ID" in a table, and I need to move that to another table in the same database. How do I do this?

So I have a sql query


SELECT *
FROM `database`
ORDER BY `database`.`Name` DESC


Is there anyway to index this so it uses a lot less Handler_read_rnd_next

I figure this one out thank you!

I accidently inserted a lot of my data wrong in mysql.

Its something like this

32-Bit versions
• Windows Vista
• Windows XP
• Windows Me
• Windows 2000
• Windows 98

I know this is pretty dumb question but I just wanted to ask because I am not sure if I can figure it out by myself. :(

So here is the deal. I have a mysql database called "appinfo" there there is...

I got it to work but it displays only one column instead of showing all of the columns from the database.

Is there anyway I can show all of the columns?

First of all this is a crazy thing I have just done.. so please sit back and read the whole post.............. Today I finished my math final and decided to learn a new programming language........