Re: [Squirrel-sql-users] MySQL ENUM DataType
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Wedra <pe...@in...> - 2009-04-14 07:29:28
|
I put 2 case (1) Right click on table name -> Refactoring -> Column -> Add (Modify) column -> Dialect: MySQL In Type field ENUM is not present (2) Right click on table name -> Scripts -> Create table script The output is: CREATE TABLE `dbname`.`tablename` ( id int, description longtext, flag char(2) ) ; But the right struct is: CREATE TABLE `dbname`.`tablename` ( id int, description longtext, flag enum('t','f') ); I can live without ENUM (in squirrel), but some old software require it, and would be convenient for me use it in squirrel wedra Matthew Dahlman ha scritto: > Did you run into some sort of problem? What did you encounter? > > Regards, > Matt > > -----Original Message----- > From: Wedra [mailto:pe...@in...] > Sent: Thursday, 09 April, 2009 23:29 > To: squ...@li... > Subject: [Squirrel-sql-users] MySQL ENUM DataType > > The MySQL ENUM DataType is not supported? > > I have a table with some fields "enum('t','f')"... > > > -------------------------------------------------------------------------- > ---- > This SF.net email is sponsored by: > High Quality Requirements in a Collaborative Environment. > Download a free trial of Rational Requirements Composer Now! > http://p.sf.net/sfu/www-ibm-com > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |