RE: BOOLEAN Variable

2001-10-29 Thread D Campbell
Shomaail [SMTP:[EMAIL PROTECTED]] wrote: > > I am using MySQL 3.23.22-beta > > pls tell is there any way to define boolean variable in this db > > what is the BOOL for ? > > declaring a var BOOL make it TINYINT(1)! but not boolean > > > > thanks > > Shomaai --- Noel Clarkson <[EMAIL PROTECTED]> w

Re: Problem with Batch mode

2001-10-28 Thread D Campbell
--- Feny Suha <[EMAIL PROTECTED]> wrote: > Hi all! > I've got trouble when i need to run mysql with batch mode. I can't run it. > I did these following steps > > shell> mysql -u root -p --batch > password : ** > - > > then the screen had no effect. > I do this step too > > shell> mysql -u

can auto_increment wrap?

2001-10-27 Thread D Campbell
quickie: can auto_increment wrap? I have a system that uses mysql for temporary storage of data. The records are kept unique in the usual lazy man's way of having an auto_increment ID field. A large number of records come and go from this database. At SOME point in the future, the integer val