about innodb_file_per_table
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: About the leftmost index prefixes using nounique index
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]
How can I show the contents of warning using mysqlimport?
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 executed the following: $ mysql -ukawabe -paaa -h192.168.1.92 -e show warnings; But I cannot show the contents of warning . If I use LOAD DATA INFILE・・・ I can show. For mysqlimport How can I show?
About the leftmost index prefixes using nounique index
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: -- MySQL can see that if a column is a leftmost prefix of the primary key, I can use it as though it were a separate index. I don't need to define a second index on the column alone. On the other hand, if a column is not a leftmost, I need to define a second index . -- Is the above content legal about the leftmost index prefixes using nounique index?
The number of left join in one SQL statement.
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 Linux the newest stable 3.1 Server : Apache 2.0 MySQL : 5.0.20 PHP : 5.1.4 OS : WindowsXP Server : Apache2.0 MySQL : 5.0.19 PHP : 5.1.2 And I considered the following SQL statement to select some columns from some tables using left join. SELECT `MST`.`no`, `MST`.`denhyono`, `GUS`.`TANI` AS `GUS`, `SUIDO`.`TANI` AS `SUIDO`, `DENKI`.`TANI` AS `DENKI`, `SYOKUIN1`.`SYOKUINNAME` AS `SYOKUIN1`, `SYOKUIN2`.`SYOKUINNAME` AS `SYOKUIN2`, `TANTOSYA`.`TANTOSYANAME` AS `TANTOSYA` FROM `MST` Left Join `TANIMST` AS `GUS` ON `MST`.`GUSno` = `GUS`.`no` Left Join `TANIMST` AS `SUIDO` ON `MST`.`SUIDOno` = `SUIDO`.`no` Left Join `TANIMST` AS `DENKI` ON `MST`.`DENKIno` = `DENKI`.`no` Left Join `SYOKUINMST` AS `SYOKUIN1` ON `MST`.`SYOKUINno1` = `SYOKUIN1`.`no` Left Join `SYOKUINMST` AS `SYOKUIN2` ON `MST`.`SYOKUINno2` = `SYOKUIN2`.`no` Left Join `SYOKUINMST` AS `TANTOSYA` ON `MST`.`TANTOSYAno` = `TANTOSYA`.`no`; - I tried this statement without error. But Ihave some questions. 1.How many left join keywords can I use in one SQL statement if there are 5000 datas in one table? 2. when some customers use this query, can they read this query exactly? 3. Will the above query speed become slowly if there are 5000 datas in one table? Will the processing efficiency improve if I use multiple SQL statement? 4.Is there any other effective SQL statement I can get better processing efficiency?
How to set host table?
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 SQL statement can I use? Otherwise, can I only insert the host table depended on db table?
I cannot login MySQL Network
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 (URL is https://network.mysql.com), the following message is displayed. Your email address [EMAIL PROTECTED] has multiple contracts with MySQL Network. You must choose only one contract to use for this login session. As I can continue to login there, when I press the button Continue Login, the following error message is displayed. Error: You need to be a MySQL Network customer in order to have access to this service. I want to know what is the reason of this error, and to solve this problem. Where can I callto solve this problem? Please tell me the telephone number.
question
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]