chico1st

i tried to do this with update 128000 times and it appears that the speed bottle neck was UPDATE and not any of those C functions.

acutally this is in C so here is my code: for (i=1; i<= 128000; i++){ strcpy(query, "INSERT INTO StartData (INDEX1) VALUES ("); ltoa (i,query2,10); strcat(query, query2); strcat(query, ")"); if (mysql_query(conn, query)) { fprintf(stderr, "%s\n", mysql_error(conn)); exit(0); } }

i have to create a table and i have to create an index for it, truncate the table, index it... its rather slow because i have 128000000 rows is there a faster way than to go : INSERT INTO StartData (INDEX1) VALUES (i) 128000000 times? *i being a counter*

what is the sql command to do auto index? i have an index column and i need to fill it with numbers from 1-128 000 000 i cant find anything on mysql.com also can i quickly empty a lot of values out of a table but leave the index column? or should i re auto index it once i empty out my table? i know i can delete from table but would emptying the table and re-indexing it be quicker?

Hi I am having an issue with a database I have that holds pictures I just read pictures in as long blobs and a table in MySQL holds them but I have just run into a FATAL ERROR Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1736612 bytes) in D:\wamp\phpmyadmin\libraries\common.lib.php on line 2418 Can I increase this size? or do I have to change teh entire way that I hold pictures.

Hi I was wondering how I can turn a string that is "05" into a string that is "5" Thanks

Here is the code that Im using $userName = "ccem"; $serverName = "localhost"; $password = ""; $dbConn = mysql_connect($serverName, $userName, $password);

Okay I havent touched phpMySQL in a long time but I loaded up a previous site that I made to make an adjustment. But im getting this error Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ccem'@'localhost' (using password: YES) in D:\wamp\www\Lib.php on line 31 problem connecting to database... Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\wamp\www\Lib.php on line 38 Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in D:\wamp\www\Lib.php on line 38 Access denied for user 'ODBC'@'localhost' (using password: NO) What am I doing wrong? How do I check what password im supposed to by using?

it was ugly but it worked thanks

I cant import my database, it is 2.3MB but my phpmyadmin wont let me import anything larger than 2MB. Is there any way that I can change this? This is the error that I get when I attempt to import. Error No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16. Im using Apache 2.2.4 PHP 5.2.1 + PECL SQLitemanager MySQL 5.0.27 Phpmyadmin Thank you very much for your time.

Im always curious about the advantages of certain programs. What is the advantage of this?

ima teen! we are everywhere.. you meet them all in your programming classes in high school. and you form friendships as you try to make the server into a vast gaming resource!

i get this error when i make an index table in phpmyadmin: "PRIMARY" must be the name of and only of a primary key! does this mean anything to you this was the sql to create my index table CREATE FULLTEXT INDEX full_index ON news(   name ,   abstract ,   coresearch   ); any idea what it means?

ive noticed that i can make more than one index. the one that the search seems to default to is 'full_index' can i make more than one index then just point my search at different index's? also i eliminated  the text area and just left the title, abstract,... 4 fields in total... it officially doesnt work.. but there is no error here is the query: $sql = "SELECT research.researchID, research.name AS research, research.coresearch, research.affiliation, research.abstract, research.fulltext, date.name AS date, author.name AS author,               MATCH(research.name, research.abstract, research.coresearch, research.affiliation)               AGAINST ('$searchstring') AS score FROM research, date, author               WHERE MATCH(research.name, research.abstract, research.coresearch, research.affiliation)               AGAINST ('$searchstring')   AND date.dateID = research.dateID AND author.authorID = research.authorID   ORDER BY score DESC"; this is what its searching:   research name: More crazy research abstract: The plague is bad co-researcher: botton affiliation: school it has 9 words to search and if i type in any of them it wont find the article.. are all the words occuring too often?

well i did make my own index but i want to be able to search the title OR the abstract OR the fulltext okay.. well that just means that the inaccuracy is out of my control :P which is good news... take that users!