>
> What is the exact difference between
> this
> index(col1,col2).
> that
> index(col1),index(col2).
> and this
> index(col1),index(col2),index(col1,col2).
>
> I read in the manual about it, but it's not really clear about the way
> to should be used / created.
>
> Any sql pseudo-teacher in h
ique record."
...to read
"An index is conceptually a container of keys arranged in such a way that
each entry in the index refers to a unique record."
Its so easy to mis-communicate.
Peace,
Norman L. Smith
--
query language for requesting
information from a database. The original version called SEQUEL (structured
English query language) was designed by an IBM research center in 1974 and
1975. SQL was first introduced as a commercial database system in 1979 by
O
mmerical sources.
I have not researched this subject recently but I am sure that there are
many "search engine" solutions to be found.
If you want to "roll your own" I suspect you won't go wrong using MySQL.
Regards,
Norman L. Smith
adapted,
network model databases often used hashing for indexing. Hashing is still
used in those special cases where it is the best solution.
See "7.6.11.3 Adaptive hash indexes" in the MySQL Manual.
I don't think that you can directly take advantage of hashing in MySQL. Wit
> From: Demirchyan Oganes
>
> Hello everyone,
>
> I have a question with regards to the InnoDB data files.
> I have the following in my.ini file.
>
> innodb_data_file_path = ibdata1:200M
> innodb_data_home_dir = c:/innodb_data
>
> I just want to know the following. Does it mean that I have
> 200
>Description:
Install from RPM failed 'Problems running mysql_install_db'
Any attempt to start gets illegal instruction..
[root@elmo root]# Starting mysqld-max daemon with databases from
/var/lib/mysql
/usr/bin/mysqld_safe: line 278: 1381 Illegal instruction
$NOHUP_NICENESS $l
edir/$MYSQLD $de
