Recent Posts

Breaking News
recent

CONFIGURATION TO HANDLE QUERY CASE SENSIVITI ON MYSQL SERVER

STEP 1 : 

Show all table on database :
root# show tables;
STEP 2 : 
root# select * from BAGIAN;
error message

STEP 3:
root# nano /etc/mysql/my.cnf
and add command
lower_case_table_names = 1
include this command on the top line
and restart mysql
root# service mysql restart
thanks...










alipvbb

alipvbb

Tidak ada komentar:

Posting Komentar

Diberdayakan oleh Blogger.