Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 13 of 13

Thread: My sql

  1. #1
    Regular Coder
    Join Date
    Aug 2013
    Posts
    181
    Thanks
    8
    Thanked 0 Times in 0 Posts

    My sql

    How can create sql file.Step by step video or image tutorial.

  • #2
    Super Moderator
    Join Date
    May 2005
    Location
    Southern tip of Silicon Valley
    Posts
    2,871
    Thanks
    2
    Thanked 164 Times in 159 Posts
    [root@099-91-RKB-2 ~]# ls sql
    ls: sql: No such file or directory
    [root@099-91-RKB-2 ~]# touch sql
    [root@099-91-RKB-2 ~]# ls -l sql
    -rw-r--r-- 1 root root 0 Mar 29 07:42 sql

    If that's not what you are looking for, then you'll need to explain what you want.

  • #3
    Regular Coder
    Join Date
    Aug 2013
    Posts
    181
    Thanks
    8
    Thanked 0 Times in 0 Posts
    I need sql file which i will put some date from google and import into php database,i hope you will understand better if i say that i making search engine and some informations i want put into datebase from google.

  • #4
    Super Moderator
    Join Date
    May 2005
    Location
    Southern tip of Silicon Valley
    Posts
    2,871
    Thanks
    2
    Thanked 164 Times in 159 Posts
    Your question still doesn't make any sense.

  • #5
    Regular Coder
    Join Date
    Aug 2013
    Posts
    181
    Thanks
    8
    Thanked 0 Times in 0 Posts

    My sql

    HHhmm how come is simple i want import some date into database from google,i want copy some informations from google and paste in sql file then import in PHp dataabse.

  • #6
    Super Moderator
    Join Date
    May 2005
    Location
    Southern tip of Silicon Valley
    Posts
    2,871
    Thanks
    2
    Thanked 164 Times in 159 Posts
    I can't find it now, but I'm sure I saw this same question earlier today or yesterday on one of the other forums and the people there were also unable to decipher what you were asking.

    You need to give more details on what you're needing and post the code that you're testing and ask a specific question regarding the portion of your code that is giving you trouble.

  • #7
    Regular Coder
    Join Date
    Aug 2013
    Posts
    181
    Thanks
    8
    Thanked 0 Times in 0 Posts

    My sql

    It is not word about code it is about inserting 100 links,100 title at once in php Datebase.

  • #8
    Super Moderator
    Join Date
    May 2005
    Location
    Southern tip of Silicon Valley
    Posts
    2,871
    Thanks
    2
    Thanked 164 Times in 159 Posts
    Is this the sql statement that you're looking for, which uses 1 statement to insert 3 rows into the database?
    Code:
    insert into links(title, link) values('title1', 'link1'), ('title2', 'link2'), ('title3', 'link3');

  • #9
    Regular Coder
    Join Date
    Aug 2013
    Posts
    181
    Thanks
    8
    Thanked 0 Times in 0 Posts

    My sql

    #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 '), ('title2', ), ('title3', )' at line 1 that is what i am getting.

  • #10
    Regular Coder Linux_Sage's Avatar
    Join Date
    Mar 2014
    Location
    Sterling,VA
    Posts
    105
    Thanks
    0
    Thanked 10 Times in 10 Posts
    If you're going to populate information from google into a database you're likely going to need some kind of script to parse those results and run the queries but judging from what I've seen so far you may need to brush up on MySQL or just computing in general before you attempt such a thing.

  • #11
    Regular Coder
    Join Date
    Aug 2013
    Posts
    181
    Thanks
    8
    Thanked 0 Times in 0 Posts

    my sql

    I want copy information's from google and paste in sql file then import into datebase,But is problem sql file, i don't know how to work with sql file.

  • #12
    Regular Coder Linux_Sage's Avatar
    Join Date
    Mar 2014
    Location
    Sterling,VA
    Posts
    105
    Thanks
    0
    Thanked 10 Times in 10 Posts
    Do you even have a schema setup to support that? Did you create the necessary tables to hold this information?

  • #13
    Regular Coder
    Join Date
    Aug 2013
    Posts
    181
    Thanks
    8
    Thanked 0 Times in 0 Posts

    My sql

    Yes i do have table ready.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •