Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create table from SELECT statement with and autoincrement field?

Status
Not open for further replies.
james0816

james0816

Programmer
Jan 9, 2003
295
US
Is that possible?
 
Sort by date Sort by votes
i have the following

create table `temptbl1` as (select yr, count(yr) from tbl1 where yr='2005'

I want to be able to add another field to this table as an autoincrement field.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
478
lupidol
lupidol
Gerrit Broekhuis
  • Locked
  • Question
create connection by code
Replies
2
Views
409
Gerrit Broekhuis
Gerrit Broekhuis
penguinspeaks
  • Locked
  • Question
Stored Procedures and triggers
Replies
9
Views
440
penguinspeaks
penguinspeaks
boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
491
spamjim
spamjim
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
444
EdLentz
EdLentz

Part and Inventory Search

Sponsor

Back
Top