Subscribe via rss
Guest
or Ask a Question
Discussions
Add a reply View Replies (3)

Mysql

Version 2
Monday, August 15 2011, 07:15 AM
Gorog
Gorog
Offline
0
Hi i need some help with Mysql

I am in jos_muscolsongs table

i whant a command that say

In Table jos_muscol_songs From ID 795 to 800 SET filename=video

CAn someone help me with this command?
Responses (3)

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Monday, August 15 2011, 10:04 AM - #Permalink
    0
    well.. it's pretty much what you already said!

    UPDATE jos_muscol_songs SET filename = "yourvideo" WHERE id BETWEEN 795 AND 800
    The reply is currently minimized Show

  • Accepted Answer

    Gorog
    Gorog
    Offline
    Monday, August 15 2011, 07:54 PM - #Permalink
    0
    hmm i think i dont say it correctly

    i have songs with the id form 800 to 850 and i have in the Field "filename" a youtube link and i dont whant to edit each song extra and put the link in the "video" field.

    song id 1 filename= "link1"
    song id 2 filename= "link2"

    the "video" field is empthy so i need a command wath does

    Song id 1 filename= "link1" video="link1"
    Song id 2 filename= "link2" video="link2"

    sorry for my englisch
    The reply is currently minimized Show

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Tuesday, August 16 2011, 03:09 PM - #Permalink
    0
    you mean this:

    UPDATE jos_muscol_songs SET video = filename WHERE id BETWEEN 795 AND 800
    The reply is currently minimized Show
Your Reply