| |
| |
| |
|
Comments:
<0> is there a way to make the results of a query all caps?
<1> check the string functions on the manual
<0> well i found UPPER
<0> but dont really see how to implement it
<1> SELECT UPPER('Hej');
<1> seems obvious
<0> ehh
<0> yeah i thought so too
<0> i tried it SELECT UPPER('*') FROM C_TOC ORDER BY C_TOC_ORDER ASC
<0> and SELECT UPPER(*) FROM C_TOC ORDER BY C_TOC_ORDER ASC
<1> you will have to sue the col names not *
<0> o
<0> fine fine
<0> thanks though ;)
<2> hey
<3> hi all
<3> i am typed these command in the pc (192.168.0.88) C:\Program Files\MySQL\MySQL Server 4.1\bin>mysql -h 192.168.0.49 -uroot -p but not work, cant connect to remote mysql,any advice?
<3> anyone???
<4> hi
<4> this is a channel about chick or mysql?
<5> j ai un site web et un scripte de recherche interne
<5> et je vx savoir comment je px cennecter la base de donn mysql
<5> alooooooooooooo
<6> barma
<6> hyar
<5> CR000 can u help me ?
<5> please
<6> i am not a pro
<6> :\
<5> CR000 ok
<5> CR000 do u know some one can he help me
<6> wait in the chan if some1 gets around they might
<5> Thx :)
<7> MrJoBLeSs use english and try repeat yr question again
<5> I need a help, because i can't connect my base mysql
<5> vexoid ?
<7> khm... what error ?
<7> r u trying connect to remotehost or localhost ?
<5> no
<5> Adresse du serveur SQL: imysql03
<5> i wanna ask u
<7> what error returned ?
<5> Parse error: parse error, unexpected '.' in /www/sites/1/ifrance.com/b/a/bayrouni/site/search.php3 on line 5
<7> khm... this php and not mysql error...
<5> yes
<8> salut
<5> vexoid the error in line server
<5> host
<7> Abaris zdrastvui .)
<9> hi
<8> vexoid, neatza. :P
<7> MrJoBLeSs and what u wanna ? 'I need a help, because i can't connect my base mysql' u have another error in yr code...
<7> Abaris ahuet' daite dve :P
<8> vexoid, uhmm.. ok (?)
<7> Abaris .) some words from russian slang... zdrastvui = salut = hi = hello
<9> -trying to display those all name of students that are in tbl_students but not yet in tbl_payments
<9> something like: select id,name from tbl_student where id is not present in tbl_payments
<8> vexoid, ok :)
<5> vexoid i have a site web
<5> and a script for search
<5> i wanna modify my script
<5> for connect the db
<10> select id,name from tbl_student where id not in (select id from tbl_payments)
<7> kn|6ht SELECT tbl_students.id, tbl_students.name FROM tbl_students LEFT JOIN tbl_payments ON tbl_students.id = tbl_payments.id WHERE tbl_payments.id IS NULL;
<7> MrJoBLeSs if u wanna got already worked script try ask at freelance.com .) if u wanna got help more specify yr question... currently u have error in yr php code... simple error...
<5> ok
<11> hi all
<12> Is there a way using MYSQL, in one query, to do UPDATE * from table SET field = 1 WHERE field 2 = 5 ?
<12> i figured that by doing
<12> WHERE x=1, all instances are getting updated
<13> i don't think the * from is correct
<12> yeah its alright i found a way
<12> UPDATE table set FIELD=X where Y=2
<12> its doing all instances of Y=2
<12> i thought i'd do only the first
<13> http://dev.mysql.com/doc/refman/5.0/en/update.html
<13> http://tyson.homeunix.org/***tant/
Return to
#mysql
or
Go to some related
logs:
ianlemmon
#AllNiteCafe
L-amPrins
rewallpaper
#php
#MissKitten
#squid
superman milking
#skype
foxx ohtok
|
|