Tags » Mysql

Perkembangan Cara Koneksi PHP Dengan MySQL

Sejak kemunculan PHP 5.5.x beberapa fungsi mysql resmi menyandang status “deprecated“, informasi ini resmi disampaikan di halaman website manual PHP. MySQL extension seperti mysql_query(), mysql_connect(), mysql_fetch_array(), mysql_num_rows(), mysql_select_db(), dan ext/mysql lainnya tidak lagi dapat digunakan lingkungan PHP 5.5.x. 152 more words


AWS Linux에 MySQL 5.7 설치

AWS 인스턴스에 MySQL을 설치할 일이 생겼다.

환경은 다음과 같다.

AWS Linux(Red Hat Enterprise Linux 6), MySQL 5.7 이상




처음에는 관련 rpm 파일을 다운 받아 설치하면 되는줄 알았다. 256 more words


Show each tables size in mysql database

Show each table size in mysql database:

    table_name AS "Table",  
    round(((data_length + index_length) / 1024 / 1024), 2) as TEST   
FROM information_schema.TABLES  
WHERE table_schema = "YOUR_DATABASE_NAME"  
ORDER BY TEST; 31 more words

It is important to validate the form submitted by the user because it can have inappropriate values. So validation is must.

The JavaScript provides you the facility the validate the form on the client side so processing will be fast than server-side validation. 171 more words


Using MySQL Load Data Local Infile

Security Issues with MySQL have resulted in changes to command procedures. An error 1148 is kicked up when load data local infile ‘…’ is used. To avoid this you must start mysql from the command line: 283 more words

Want to increase your earning potential in 2017? Learn these skills.

The Robert Half 2017 Salary Guide for tech professionals was recently released.  In addition to breaking down salary data for jobs in information technology, it also discusses the most in-demand skills and certifications.  155 more words

Script to automatically backup MySQL database

Its obvious to say that so much important to keep your data safe when systems are in production, but there are so many ways to this. 160 more words