I want insert more information’s at once time in php datebase.I making search engine and inserting information’s from Google title,link,description by i am getting slow because i insert title,link,description into datebase (php admin).Is any way that i can insert maybe 100 hundreds or more title,link,description at once time.
You can try you the methods listed here…
https://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html
You can also check out the last query here for another example…
I am getting # 1064 error because i need change my isam to innodb engine type of my my sql when i do try is said doesn’t support full text.Any help.
Change it and test…
I saw this page but still i don’t know what to do,if you can write down step by step what i have to do.Or better video tutorials or image tutorials.
Using prepared statements the query is saved in memory on the database server and immidiatly executed on the next run, this makes it suitable for sequantial database queries with different data.
Or you can build a sql file and import it using mysql.
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax this what i am getting when i am trying import sql file in datebase.
The steps are listed in the link, I am really unable to explain it better.
In the first paragraph, it tells you how to change your table to InnoDB
[php]ALTER TABLE foo ENGINE=InnoDB[/php]
When i am trying to change engine type is said #1214 - The used table type doesn’t support FULLTEXT indexes.
Then drop the index, convert the table, and then re-add the index.
I successfully changed my engine type of the datebase but still getting error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near when i am trying to import date from sql file into datebase.
I’ll need to see your sql file or at least
Part of it.
Is said that sql file is not allowed. Allowed file types: doc, gif, jpg, mpg, pdf, png, txt, zip
Restrictions: 4 per post, maximum total size 500KB, maximum individual size 500KB
There is no SQL Statements in that file, it’s just a bunch of text…
That’s why you’re getting errors…
How i can make SQL Statements.
I don’t understand this i tried select in sql query but still getting error.
It seems like you don’t know anything about SQL Statements or how databases works, that’s why I recommend sites that teach you about queries, their’s hundreds of tutorials out their that will help you get your head around them.
Select Statements - Retrieve data from the data base
Insert Statements - Adds Data to a database
Update Statements - Changes data in a database
Delete Statements - Delete data in the database.
If you are trying to add data to a database, you need to write inserts statements to do that…
The file you uploaded does not have any “INSERT Statements”