The document at
http://www.mysql.com/doc/T/a/Table_size.html
seems to suggest that the reason why there's a limit to the table size is
because of the number of bytes used by the file system to store offsets,
so its more or less file system dependant (pls correct me if i'm wrong).
It also wrote t
connect to your database by
mysql -p
then type
drop table ;
On Sun, 24 Jun 2001, ricky gonzalez wrote:
> Hi, I need to delete a table from a database. I
> looked through the manual, but it's not listed in the
> table of content.
>
> Thank you for your help.
>
>
Hello,
I have a table where for each row, the tuple is
unique (when creating the table, i did a UNIQUE INDEX index1 (col1, col2))
I wrote a perl program to read lines from a file and insert accordingly
into the table.
How do I prevent insertions of duplicates? (as in during the insertion
loop, i
Hello,
I'm trying to create a table with columns A, B, C, D such that values in
columns A and B are not unique but if you consider them as a paired tuple,
then for every row, is
unique. Furthermore, I'd like to create a index to use for searching
through the database using this unique paired tup
