#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2016
    Location
    Lakewood, WA
    Posts
    192
    Rep Power
    17

    Show create table


    There are a bunch of SHOW functions...

    What does SHOW CREATE TABLE mean and how is it used?
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,685
    Rep Power
    4288
    Originally Posted by Arty Zifferelli
    What does SHOW CREATE TABLE mean and how is it used?
    what happened when you tested it? ™
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2016
    Location
    Lakewood, WA
    Posts
    192
    Rep Power
    17
    Code:
    SHOW CREATE TABLE LL_track_points
    results in
    Code:
    CREATE TABLE `LL_track_points` (
     `uid` int(11) N...
    Shows the beginning of a CREATE TABLE query, but not the whole thing. Doesn't seem useful.
  6. #4
  7. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,685
    Rep Power
    4288
    Originally Posted by Arty Zifferelli
    Shows the beginning of a CREATE TABLE query, but not the whole thing. Doesn't seem useful.
    no, it produces the entire CREATE TABLE statement, including indexes

    whatever you're using to run the SHOW statement and display the results (phpmyadmin?) is not showing you all of it
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  8. #5
  9. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2016
    Location
    Lakewood, WA
    Posts
    192
    Rep Power
    17
    I shal try it on the command line, then. Thanks.

IMN logo majestic logo threadwatch logo seochat tools logo