Question

Doing a university course in web development and I ve been sick all the time we went thru databases. I ve read up on most stuff, like connect to mysql, select DB and that. But something I can t figure out is how to add data in the columns of a table.

I ve tried what i could find online but I haven t found anything useful really... So I was wondering if anyone here could be so kind to show me how write stuff to a table with these columns: http://imageshack.us/photo/my-images/851/sqla.png/

我无需帮助选择非行等,而只是如何将这些数据写进 d。或与象我这样的哺乳动物指南的联系...... 我尝试了多种不同的方式。

但我无法工作。

任何帮助都会得到真正赞赏,感觉完全消失。

提前感谢!

Answer 1

我的猜测是,song_id 与其他一些表格有关,因此,您在插入请求中需要一个有效的<代码>song_id,但这样一些表格就能够发挥作用:

 INSERT INTO `your_table` VALUES(NULL, Your Text ,song_id,CURRENT_TIMESTAMP);

关于<代码>song_id的通知如果与另一个表格有关,则应以有效的补偿取代:

 $song_id = 1;
 $text = "Sample text";
 mysql_query("INSERT INTO `your_table` VALUES(NULL, $text ,$song_id,CURRENT_TIMESTAMP)");

您还应努力检查,供此类问题使用。

Answer 2

沿此思路而论,应该 do。

INSERT INTO TABLE_NAME (text, songid, insertdate) VALUES ( TEXT VALUE ,  SONG ID , CURRENT_TIMESTAMP)

http://www.w3schools.com/sql/sql_insert.asp” rel=“nofollow”here。

Answer 3

为此:

INSERT INTO <table_name> (text, songid, insertdate) VALUES ( your_text_here ,  your_song_id_here , now());

http://www.w3schools.com/“rel=“nofollow”

友情链接