I'm now trying to insert into a table with MySQL, but getting a fatal error message:
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 25833 bytes) in C:\wamp\apps\phpmyadmin3.2.0.1\libraries\sqlparser.lib.php on line 342
There are only 241 records of 7 fields, all varchars:
Table:
create table lawyer_info
(firm_name varchar(100),
firm_url varchar开发者_C百科(100),
firm_address varchar(100),
firm_city varchar(100),
firm_state varchar(100),
firm_zip varchar(12),
firm_phone varchar(15));
Now, if it's the case that the table is too big (which I find hard to believe,) is there a better way of getting it to insert the data?
That's a PHP error.
134217728 Bytes = 134,217,728 Bytes = 134 MB. With only 241 small records, you must have a logic error in your script that is getting into an infinite loop and continuing to allocate memory. This is not a MySQL issue.
Check your code.
精彩评论