MySQLi – Data Types Properly defining the fields in a table is important to the overall optimization of your database. You should use only the type and size of field you really need to use; don”t define a field as 10 characters wide if you know you”re only going to use 2 characters. These types […]

MySQLi – Regexps You have seen MySQL pattern matching with LIKE …%. MySQL supports another type of pattern matching operation based on regular expressions and the REGEXP operator. If you are aware of PHP or PERL, then it”s very simple for you to understand because this matching is very similar to those scripting regular expressions. […]

MySQLi – Administration Running and Shutting down MySQL Server First check if your MySQL server is running or not. You can use the following command to check it − ps -ef | grep mysqld If your MySql is running, then you will see mysqld process listed out in your result. If server is not running, […]