Output of "show create table" for Disk Data Table

Hi all,

After creating of the table, "show create table"
shows the following
information.
The definition of storage disk is shown as comment.
 /*!50100 TABLESPACE ts_1 STORAGE DISK */
Is this correct result of "show create table"?

mysql> create table t1 (c1 int primary key, c2 int, c3
char(255), c4
char(255)) tablespace 
ts_1 storage disk engine ndb;

mysql> show create table t1;
+-------+-----------------------
| Table | Create Table
|
+-------+-----------------------
| t1    | CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` int(11) DEFAULT NULL,
  `c3` char(255) DEFAULT NULL,
  `c4` char(255) DEFAULT NULL,
  PRIMARY KEY (`c1`)
) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster
DEFAULT
CHARSET=latin1 |
--------------------------------
1 row in set (0.00 sec)

Best regards,
Yotaro Nakayama

That isn't a comment for versions of mysql greater than or
equal to 50100

bit of info here:

http://dev.mysql.com/doc/refman/5.1/en/comments.html


yotaro.nakayamauniadex.co.jp wrote:
> Hi all,
> 
> After creating of the table, "show create
table" shows the following
> information.
> The definition of storage disk is shown as comment.
>  /*!50100 TABLESPACE ts_1 STORAGE DISK */
> Is this correct result of "show create
table"?
> 
> mysql> create table t1 (c1 int primary key, c2 int,
c3 char(255), c4
> char(255)) tablespace 
> ts_1 storage disk engine ndb;
> 
> mysql> show create table t1;
> +-------+-----------------------
> | Table | Create Table
> |
> +-------+-----------------------
> | t1    | CREATE TABLE `t1` (
>   `c1` int(11) NOT NULL,
>   `c2` int(11) DEFAULT NULL,
>   `c3` char(255) DEFAULT NULL,
>   `c4` char(255) DEFAULT NULL,
>   PRIMARY KEY (`c1`)
> ) /*!50100 TABLESPACE ts_1 STORAGE DISK */
ENGINE=ndbcluster DEFAULT
> CHARSET=latin1 |
> --------------------------------
> 1 row in set (0.00 sec)
> 
> Best regards,
> Yotaro Nakayama
> 

-- 
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com
/cluster
To unsubscribe:    http://list
s.mysql.com/cluster?unsub=bondyahoo.com

Hi,

>
> After creating of the table, "show create
table" shows the following
> information.
> The definition of storage disk is shown as comment.
> /*!50100 TABLESPACE ts_1 STORAGE DISK */
> Is this correct result of "show create
table"?


/*!50100 */ is a special sort of comment syntax in MySQL.

The manual says, "If you add a version number after the
! character,  
the syntax within the comment is executed only if the MySQL
version is  
greater than or equal to the specified version
number."


JD





-- 
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com
/cluster
To unsubscribe:    http://list
s.mysql.com/cluster?unsub=bondyahoo.com