| |
| |
| |
|
Comments:
<0> guys, what is the correct syntax of a query which will update the "hits" field in my "articles" table by increasing the current number of hits by 100 in all records?
<1> not enough information
<0> i'm using mysql
<0> i don't really know much about SQL, but it should be something like UPDATE hits FROM articles SET hits = hits + 100
<1> not quite
<1> UPDATE articles SET hits...
<1> the rest will get you by
<0> well, i have no idea about sql (i'm a web designer) that's why I tried your channel ...
<0> and you know, desginers and coding don't mix
<1> tell me about it (c:
<1> UPDATE articles SET hits = hits + 100
<1> should do what you want
<0> :)
<1> it's like admin staff and web-design
<1> that don't happen either
<1> no matter how much they think it does
<0> #1064 - You have an error in your SQL syntax;
<0> UPDATE 'articles' SET hits = ( hits +100 ) ;
<0> what's wrong with this?
<1> you don't need brackets, or the quotes
<0> cheers mate, it worked :)
<2> hello
<2> Im trying to display a number of values that have a certain id's connected them. Is there a way to display the values connected to one id without dipslay the id again?
<3> Hi! I got this error from my SQL query "SQL insert into `sharpmind_language` values (? , ? , ? , ?) failed : Duplicate entry '127' for key 1".. What could caouse this?
<3> cause*
<4> hello all
<4> i need some hlp
<4> on a login script
<5> hi all
<6> evening
Return to
#mysql
or
Go to some related
logs:
fun_girl
#c++
#AllNiteCafe
#london
Where does the girl come from in Astrid Gilberto's most famous song ?
#linux
#chatzone
mysql count weekends
#linuxhelp
#java
|
|