SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Member
    Join Date
    Oct 2010
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Vertical ellipsis

    Hi Guys, am currently studying Kevin Yank's Book; "Build Your Own DataBase Driven Website using PHP. My question is; how do I type vertical ellipsis while creating databases in MYSQL? Please help!

    Regards
    Bernard

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,323
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by ogolabernard View Post
    how do I type vertical ellipsis while creating databases in MYSQL?
    you don't

    can you give the query where you saw the vertical ellipsis?

    what you have to do is replace the vertical ellipsis with something else
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Member
    Join Date
    Oct 2010
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The vertical ellipsis are on page 61 (under the Topic: Creating A Table) of Kevin Yank's Book: "how to build your own database driven website using php and mysql. I don't even know what to replace the vertical ellipsis with!

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,323
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by ogolabernard View Post
    The vertical ellipsis are on page 61
    the reason i asked you to show the query is because i don't have the book, but i'm pretty good with queries once i see what's going on...
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Addict
    Join Date
    Feb 2004
    Location
    Staffordshire, UK & Florida, USA
    Posts
    314
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Code:
    mysql> CREATE TABLE table_name (
    -> column1Name column1Type column1Details,
    -> column2Name column2Type column2Details,
    -> ⋮
     -> ) DEFAULT CHARACTER SET charset;

    This is just an example showing you the general syntax for a CREATE TABLE statement. The syntax isn't valid, because you need to replace column1Type and column1Details with actual SQL definitions. Look on the next page and you'll see an actual example:


    Code:
    mysql> CREATE TABLE joke (
    -> id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    -> joketext TEXT,
    -> jokedate DATE NOT NULL
     -> ) DEFAULT CHARACTER SET utf8;

  6. #6
    SitePoint Enthusiast erangalp's Avatar
    Join Date
    Oct 2010
    Location
    Israel
    Posts
    37
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It's not actual syntax, it's just the author's way to say "do the same with all the other columns"... the same as it's used in natural language


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •