Lho lho kok ada perbedaan saat nguery
[sourcecode language="sql"]select * from barang;[/sourcecode]
dengan
[sourcecode language="sql"]select * from BARANG;[/sourcecode]
,, query yang satu sukses tapi query yang lain error ??? ooo iya sekarang kan pke linux ,, makanya case sensitive.
q> Edit configurasi mysql pada file my.cnf
[sourcecode language="bash"]sudo nano /etc/mysql/my.cnf[/sourcecode]
tambahkan lower_case_table_names=1 setelah baris [mysqld]
[sourcecode language="text"][mysqld]
#
# * Basic Settings
#
lower_case_table_names=1
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
[/sourcecode]
q> Berhasil. hore hore
No comments:
Post a Comment