Re: data struct mysql

[Devart Team]

You could create a table with specified fields, e.g.-

CREATE TABLE table1(
  IDS INT(11) DEFAULT NULL,
  DES1 VARCHAR(512) DEFAULT NULL
);

To limit row count you can use an INSERT trigger. Trigger should check row count and throw an error if neccessary.

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/



Edited 1 time(s). Last edit at 10/25/2010 06:10AM by Devart Team.