[plug] auto-increment in mysql

[Jon Miller]

Yeah, I'm beginning to believe this is the way to go.
Although I worked through a php tutorial I found it to be nice, but
still I needed more than what the tutorial was offering.


On Thu, 2003-01-02 at 14:18, Shayne O'Neill wrote:
> For simplicity, if you have a winbox DreamweaverMX really is the king of
> the castle.... MsFrontpage, will only do ASP pages, although that may be
> OK if you use suns chilli-asp (perhaps?).
> 
> As for a non gui thing..... I'm a bigfan of  emacs personally. :)
> 
> Shayne.
> 
> ----- Original Message -----
> From: "Jon Miller" <jlmiller at mmtnetworks.com.au>
> To: "plug" <plug at plug.linux.org.au>
> Sent: Wednesday, January 01, 2003 10:23 PM
> Subject: Re: [plug] auto-increment in mysql
> 
> 
> > I would like to know what application most folks find good and easy to
> > use when creating a web-based front-end for a MySQL database.  I've
> > heard MS Frontpage is one, but I want a Linux (RH) package if possible.
> > It really would not make a difference where the field was in the
> > database I guess as long as it can be manipulated in the front-end
> > system.
> > This is a test system I'm designing to get a feel for MySQL and
> > Web-based systems.
> >
> > Thanks
> >
> > On Wed, 2003-01-01 at 22:05, Daniel Pearson wrote:
> > > Get a dump of the table.. then modify the order, and copy the commands
> and
> > > paste them back through the command line, maybe - or get it to input
> data
> > > from the text file.
> > >
> > > Just a suggestion..
> > >
> > > Daniel
> > >
> > > ----- Original Message -----
> > > From: "Jon Miller" <jlmiller at mmtnetworks.com.au>
> > > To: "plug" <plug at plug.linux.org.au>
> > > Sent: Wednesday, January 01, 2003 10:06 PM
> > > Subject: Re: [plug] auto-increment in mysql
> > >
> > >
> > > > Seems the only way is to create a new table with the columns in the
> > > > correct order and then copy the data from the old table to the new
> > > > table.  Is there a better/quicker way?
> > > >
> > > > Thx
> > > >
> > > > On Wed, 2003-01-01 at 22:02, Jon Miller wrote:
> > > > > Thanks for that just one more question is there a way to make the
> new
> > > > > column the first column?
> > > > >
> > > > > Jlm
> > > > >
> > > > > On Wed, 2003-01-01 at 21:46, James Bromberger wrote:
> > > > > > Craig Ringer (craig at postnewspapers.com.au) wrote:
> > > > > > > ALTER TABLE tablename ADD COLUMN colname TYPENAME
> AUTO_INCREMENT;
> > > > > > >
> > > > > > > thats the general idea, anyway. I mainly use postgresql these
> days
> > > so I
> > > > > > > may be a bit rusty. Hmm... when I tried it the db said:
> > > > > > >
> > > > > > > mysql> ALTER TABLE test ADD COLUMN testing int AUTO_INCREMENT;
> > > > > > > ERROR 1075: Incorrect table definition; There can only be one
> auto
> > > > > > > column and it must be defined as a key
> > > > > >
> > > > > >
> > > > > >  mysql> ALTER TABLE test ADD COLUMN testing int PRIMARY KEY
> > > AUTO_INCREMENT;
> > > > > >
> > > > > >
> > > > > > But "there can be only one"... primary key per table (hence the
> name
> > > > > > 'primary', and thus there can be only one auto_increment). ut I am
> > > sure
> > > > > > that mysql 4 is a whole new world, just bursting to get out of
> > > > > > Debian/experimental into debian/unstable.... at some time...
> > > > > >
> > > > > >
> > > > > >    JB
> > > > > >
> > > > > > PS: All you PLUGers and lurkers who are thinking about registering
> for
> > > > > > LCA; hurry up and DO IT! It's only 2 and a bit weeks away! Hurry
> up!
> > > > > > http://www.linux.conf.au/
> > > > --
> > > > Jon Miller <jlmiller at mmtnetworks.com.au>
> > > > MMT Networks Pty Ltd
> > > >
> > > >
> > > >
> > > >
> > --
> > Jon Miller <jlmiller at mmtnetworks.com.au>
> > MMT Networks Pty Ltd
> >
> >
> >
-- 
Jon Miller <jlmiller at mmtnetworks.com.au>
MMT Networks Pty Ltd