Vertical ellipsis

Databases
1

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

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

3 

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:


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

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!

5

you don’t :slight_smile:

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

what you have to do is replace the vertical ellipsis with something else

6

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…