Interested to Buy Any Domain ? << Click Here >> for more details...
Let us suppose we have a table with structure in order
empno
empname
empdesig
empcountry
and now i want to re-organize the columns of this table to
empno
empdesig
empname
empcountry
how can i do this with queries ?
assume that table contains the data.
- 3 Answers
- 6733 Views
- I also Faced
- E-Mail Answers
Answer Posted / s. syam sundar
try this
create table emp1 as select
empno,empdesig,empname,empcountry from emp
this would creat a new table named as emp1 and
u can retrive the data from this table as of emp
but constraints,indexs which u have on emp table are
created on this emp1 table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is 'mysqladmin' in mysql? : Sql dba
What is cursor in pl sql with examples?
What are sql procedures?
What is the difference between an inner join and an outer join?
how to create a table index in mysql? : Sql dba
What does desc stand for?
What are the triggers associated with image items?
Enlist the advantages of sql.
Which kind of parameters cannot have a default value in pl sql?
What is left join in sql?
What does the acronym acid stand for in database management?
What is %s in sql?
What is dml statement?
What are all the ddl commands?
What is foreign key sql?
