MySQL Forums
Forum List  »  Oracle

Re: data struct mysql
Posted by: Devart Team
Date: October 25, 2010 01:13AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3571
October 20, 2010 09:50PM
1826
October 21, 2010 12:46AM
1593
October 24, 2010 07:19PM
Re: data struct mysql
3186
October 25, 2010 01:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.