Hello,
I would like to know if anyone knows the maximum number of tables and Values in the command below.
[php]INSERT INTO table_name (table1, table2, table3,…)
VALUES (value1, value2, value3,…);[/php]
I am at 64 tables and values however when I add additional table and value it does not add anymore on my database. I don’t know what causes this issue.
Please advise. Thanks.
Roggie
Hello I seems to found the culprit. It is a code that cannot be seen by Notepad++. I notice it when I open it using VIM in linux.
See the link below. It is circled in yellow.
http://www.mediafire.com/view/4bci2bub4f00iyq/Ghost_in_the_Machine.PNG
This is very weird. Can anyone recreate this issue so I can avoid it? thanks.
There is a limit of 4096 col’s in any DB row. This is if you are using MySQL. BUT, the size of the fields may limit it down to only 85 cols depending on your formatting.
Below is a link that discusses it from MySQL manual. Perhaps it will help. Since you did not post your query, it is hard to help you further. In the “yellow” circle on your graphic you show a mistyped entry, so I am not sure what you need for help. If this does not help, post your query inside of CODE or PHP tags so we can see your code… Good luck!
http://dev.mysql.com/doc/refman/4.1/en/column-count-limit.html
Very interesting. I tried to duplicate it in my Notepad++ and it shows up. So, I am guessing that your version must have a setting that is different. You might want to uninstall it and reinstall the latest version. Load your file after that and see if it shows the blue-code.
But, glad you located it. Nice catch!
