#mysql
10 November 2007
Total 22 pages. You are browsing page 3/22.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
02:37 <****> if I create an index
02:37 <****> is it possible to see the actual index
02:38 <****> tators: shwo create table tblname; should show them.
02:38 <****> show, that is.
02:38 <****> that will just be the table right
02:38 <****> not the index?
02:38 <****> or will the table be indexed
02:38 <****> I'm not sure how it actually works
02:39 <****> anyone know how to connect to mysql command line when using xampp?
02:39 <****> show index from table;
02:39 <****> thanks
02:40 <****> show create table name; shows all the indexes as well.
02:44 <****> create index fnamelname
02:44 <****> on voter
02:44 <****> firstname, lastname
02:44 <****> using hash;
02:44 <****> error near 'firstname, lastname using hash'
02:46 <****> is there a sample of this command anywhere
02:47 <****> tators: http://dev.mysql.com/doc/refman/5.0/en/create-index.html
02:48 <****> yeah thats where I got my command from
02:48 <****> I must be reading it wrong
02:48 <****> tators: CREATE INDEX part_of_name ON customer (name(10));
02:49 <****> what if you have 2 columns you want to index
02:49 <****> likes first and last
02:49 <****> two different indexes?
02:49 <****> tators: CREATE INDEX part_of_name ON customer (f1,f2);
02:50 <****> ah
02:50 <****> That's one index.
02:50 <****> yeah, thanks
02:50 <****> tators: For two separate indexes, use two create statements.
02:50 <****> why don't you use "USING {BTREE | HASH}"
02:51 <****> the using isn't in ()
02:51 <****> tators: It's not required.
02:51 <****> hrm
02:51 <****> [index_type]
02:51 <****> how do you know its not required
02:52 <****> like its obviously not required because my server is making the index without it
02:52 <****> CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [index_type] ON tbl_name (index_col_name,...);
02:52 <****> but reading the description at the top
02:52 <****> tators: We just discussed what the meaning of [] was.
02:52 <****> CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name
02:52 <****> [index_type]
02:52 <****> ON tbl_name (index_col_name,...)
02:52 <****> index_col_name:
02:52 <****> col_name [(length)] [ASC | DESC]
02:52 <****> index_type:
02:52 <****> USING {BTREE | HASH}
02:52 <****> tators: I just showed that. No need to repeat.
02:53 <****> there isn't a [] around index type or using...
02:53 <****> tators: index_type is optional.
02:53 <****> how do you know that
02:53 <****> there isn't a box bracket around it
02:53 <****> [index_type]
02:53 <****> in what you wrote...
02:53 <****> tators: You yourself showed that.
02:53 <****> I am looking at the website
02:53 <****> CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [index_type] ON tbl_name (index_col_name,...);
02:53 <****> there is no box bracket
02:53 <****> yes I see what you are typing
02:53 <****> the website says differently
02:54 <****> tators; That's directly from the docs. The [] is obviously there.
02:54 * ToeBee thinks tators needs some glasses
02:54 <****> http://dev.mysql.com/doc/refman/5.0/en/create-index.html
02:54 <****> go there
02:54 <****> do you see the []
02:54 <****> ?
02:54 <****> I don't
02:54 <****> yes
02:54 <****> tators: Do you not see the [index_type] in that statement?
02:54 <****> tators: One more time...
02:54 <****> CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [index_type] ON tbl_name (index_col_name,...);
02:54 <****> I see index_type:
02:54 <****> I don't see [index_type]
02:54 <****> hit CTRL-F and do a search for [index_type] in your browser
02:54 <****> tators: Read slowly and find all the [ characters.
02:55 <****> so that entire description is actually 2 descriptions
02:55 <****> not one
02:55 <****> kind of tricky
02:56 <****> tators: It has non-terminal symbols/phrases.
02:56 <****> what
02:56 <****> tators: Those non-terminal symbols expand based on their definition.
02:57 <****> tators: index_type is called a non-terminal symbol.
02:57 <****> tators: When talking about languages, we use the term terminal and non-terminal symbols to refer to panguage fragments/components.
02:57 <****> language
02:58 <****> so the blue means its non terminal
02:58 <****> tators: You'll notice that the non-terminal symbols, like identifiers and complex structures are on lower case.
02:58 <****> s/on/in
02:58 <****> ah
02:59 <****> tators: For instance: index_name is a non-terminal symbol that represents the given name. It is not *the name*. It represents some structure that would expand or be replaced by the name.
02:59 <****> tators: CREATE INDEX are two terminal symbols. They mean literally those words.
03:00 <****> terminal: final form / symbol.
03:00 <****> non-terminal: Not the final form.
03:00 <****> one could call them place holders
03:01 <****> tators: That's the typical form of most language descriptions.
03:03 <****> tators: The terms are well known from more general texts on compiler construction and general language theory. See: http://en.wikipedia.org/wiki/Backus%E2%80%93Naur_form
03:06 <****> tators: If you find the SQL specification, it uses this type of notation throughout.
03:15 <****> !man btree
03:15 <****> Nothing found.
03:15 <****> lame
03:15 <****> !man hash
Total 22 pages. You are browsing page 3/22.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last