Request : Mysql Table Editor

[AMHFZ]

salah tu kot...

UPDATE nama_table_anda
SET str='1'

xle pn tuan?

Step sy buat

1) Login Mysql Query Browser
2) Tool -> MYSQL command line Client
3) ??

Saya ada banyak Schema kat sql saya. mcm mana nak choose Schema sy yang contain table saya tu ?

Lebih pencerahan . Schema " Testing ", Table " Char "

 

[ezee]

kalau camtu, step no 3 tu try taip "use testing;"
then taip "update char set str='1';"

 

[AMHFZ]

kalau camtu, step no 3 tu try taip "use testing;"
then taip "update char set str='1';"

xle laa tuan. tgk attachment saya

 

[ezee]

oo... x besa guna command line ni.. try "update char set str=1;".. tngk bole ke x?
kalu x bole try "update char set str=1"

 

[AMHFZ]

oo... x besa guna command line ni.. try "update char set str=1;".. tngk bole ke x?
kalu x bole try "update char set str=1"

xle gk tuan

 

[ezee]

aiseh.. try download heidisql pastu install tuan

 

[AMHFZ]

aiseh.. try download heidisql pastu install tuan

xpe2. dah boleh tuan. thanks

Edit table SQL

use < nama table >
update `char` set str=1;

klu x boleh
update `char` set `int`=1;

 

[ezee]

xpe2. dah boleh tuan. thanks

Edit table SQL

use < nama table >
update `char` set str=1;

klu x boleh
update `char` set `int`=1;

owh.. camtu plak.. hahaha oke.. tahniah

 

[ejad87]

salah tu kot...

UPDATE nama_table_anda
SET str='1'

owh..terima kasih betulkan.