← Back to team overview

oqgraph-dev team mailing list archive

Re: show create table

 

We have no control over that as a storage engine.

Antony T Curtis
On Feb 25, 2013 2:03 AM, "Arjen Lentz" <arjen@xxxxxxxxxxxxx> wrote:
>
> In SHOW CREATE TABLE output, I reckon the option quoting is wrong. It
shouldn't be quoted at all but definitely backticks are bad since they're
not identifiers.
>
>
> mysql> show create table graph\G
> *************************** 1. row ***************************
>        Table: graph
> Create Table: CREATE TABLE `graph` (
>   `latch` smallint(5) unsigned DEFAULT NULL,
>   `origid` bigint(20) unsigned DEFAULT NULL,
>   `destid` bigint(20) unsigned DEFAULT NULL,
>   `weight` double DEFAULT NULL,
>   `seq` bigint(20) unsigned DEFAULT NULL,
>   `linkid` bigint(20) unsigned DEFAULT NULL,
>   KEY `latch` (`latch`,`origid`,`destid`) USING HASH,
>   KEY `latch_2` (`latch`,`destid`,`origid`) USING HASH
> ) ENGINE=OQGRAPH DEFAULT CHARSET=latin1 `data_table`='graph_base'
`origid`='origid' `destid`='destid'
>
>
> --
> Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
> Australian peace of mind for your MySQL/MariaDB infrastructure.
>
> Follow us at http://openquery.com/blog/ & http://twitter.com/openquery
>

References