segmentation fault when insert data into mysql
How is everybody doing today! I am a little mad since I have tried to put the URLs and anchor texts into mysql database using mysql c API. I kept getting segmentation fault error after I insert URLS more than 3000 or 4000. you know the log files are always more than 10000 records and up to 1G. I am not sure if somthing wrong with my database design but I only insert three fields.
Anyway, the code I am using is:
mysql_query(conn, "CREATE TABLE anchor_db (id int(11) NOT NULL auto_increment, input_url TEXT(8192) default NULL, input_referer TEXT(8192) default NULL, anchor_text TEXT(1024) default NULL, PRIMARY KEY (id)) TYPE=MyISAM");
Please offer to help if tou are expert in mysql since I just got into it a couple of weeks ago.