Re[2]: Can I override the auto-increment setting?

2002-06-09 Thread Yegor N. Bryukhov
Hello Jason, I think you have to ALTER this field, insert what you want and then ALTER it back. Another way is to insert the record, detect the value of auto-increment field it got (there is a function mysql_insert_id / LAST_INSERT_ID) and update it. JL I have a mysql table

Re: MySQL + cygwin

2002-06-03 Thread Yegor N. Bryukhov
Hello Chris, I would recommend to try to compile MySQL itself under cygwin (or you already tried it?). Just use GCC version they suggest (I failed to compiled it using GCC 3.1). BTW, if you succeed, I would really appreciate if send me mysqlclient-library compiled under cygwin.

Re: Visualizing the shema of the db

2002-05-27 Thread Yegor N. Bryukhov
Hello andy, http://www.datanamic.com/ a Hi there, a I am wondering if there is a software (free or shareware) which is a visualizing the shema (table strukture) of the mysql database. a thanx for any hint, a Andy a query a