Unsigned is exactly what it says on the tin - no positive/negative sign. Or rather, no negatives and twice as large a range. ie: an UNSIGNED INT(4) is 0..255 compared to a SIGNED INT(4) which is -127..128. I'm assuming you're using an INT(1) for your booleans? If so you can probably do something like "UPDATE table SET bool_column = -1*bool_column" to get them all inline with what you need.
I can't think of any other columns, aside from dates, that might cause problems, but I've not done much migrating (and none using the mysql migration tool) so I don't really know. You want to setup indexing - it'll speed things up. An index should go on anything commonly referred to in a where clause Eg: "SELECT name, email FROM user WHERE id = 5;". In that example, id should have an index on it, but name doesn't need one. If you did "SELECT id, email FROM user WHERE name = 'bob';" often then you'd set an index on name instead/aswell. Essentially, all primary and foreign keys should have indexes. Stored procedures can be beneficial but they're not essential. If you want to learn about them, go ahead, but it's fair enough to ignore them for the moment. The MySQL Workbench tool gives a dropdown of datatypes (create a table: fifth icon down on left, click in main area, double-click title, select columns tab), but it's an Alpha and prone to crashing so don't use it on your database (or do anything you want to keep with it). Goodluck. :) -- Peter On 1/29/07, stylo stylo <[EMAIL PROTECTED]> wrote: > > Access to mysql using the mysql migration tool: > > What to do with booleans? They all went to -1 and queries now turn up > nothing. Do I need to set them all to 1 and that's it? I read something > about signed/unsigned but have no idea what that means. > > Is there a list of gotchas anywhere that people know of? I'm wondering: > > 1) what columns or datatypes I'm going to have to check and repair like > the booleans (why didn't the migration fix that???) > > 2) what sort of things I'm going to have recode in the queries (already > saw one timestamp error) > > 3) anything else I'm going to have to setup or do with the db? I have no > real clue about databases, what a stored procedure is, indexing, anything. > I'm converting an old web app to mysql on my own. I'd like to avoid anything > that will slow it down unnecessarily :-) > > I'm surprised the mysql gui doesn't have a dropdown of datatypes to select > from. Is there a good list anyone knows of? > > Thanks. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2711 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
