about innodb_file_per_table

2006-09-25 Thread Takanobu Kawabe
Hello. In InnoDB tables , some "table name.ibd" files are created when the "innodb_file_per_table" parameter is specified. I want to know How the MySQL server determines the initial size of "table name .ibd" files and the extended size of them. Please tell me about this . With regards -- M

Re: About the leftmost index prefixes using nounique index

2006-06-21 Thread Takanobu Kawabe
Thank you very much for your understandable representation, Mr.PREDA and Mr.Vegerin. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

About the leftmost index prefixes using nounique index

2006-06-20 Thread Takanobu Kawabe
hello, I want to know about the leftmost index prefixes using nounique index/ About the composite index using primary key, in the reference 7.4.5, I can understand the following: -- M

How can I show the contents of warning using mysqlimport?

2006-06-20 Thread Takanobu Kawabe
I imported the data of the table using mysqlimport. I used the following command line. $ mysqlimport -ukawabe -paaa -h192.168.1.92 --local kawabe "C:\index_test.txt" kawabe.index_test: Records: 4 Deleted: 0 Skipped: 4 Warnings: 2 I want to show the contents of warning ,so I ex

The number of left join in one SQL statement.

2006-06-16 Thread Takanobu Kawabe
Hello, my name is Takanobu Kawabe. I have some questions about left join SQL statement. I want to join some tables, and using left join statement . the system is the following. I use two machines. I created the same databases and tables on both machines. OS : Debian

How to set host table?

2006-06-13 Thread Takanobu Kawabe
Hello, my name is Takanobu Kawabe. I use MySQL 4.1.19 server now. I don't know how to set Host table in mysql database. For db table,tables_priv table and so on, can set using GRANT SQL statement. Can I use this statement for setting Host table? If I can, what

I cannot login MySQL Network

2006-06-12 Thread Takanobu Kawabe
Hello, my name is Takanobu Kawabe. I have gotten a MySQL Network, and the service level is gold , I could login MySQL Network on May 20th , but now I can't login. I have tried some times last week, and today , but I cannot do it. If I try to login (U

question

2006-04-12 Thread Takanobu Kawabe
Is there any way to set many columns of the table in one line? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]