MySQLi – Indexes A database index is a data structure that improves the speed of operations in a table. Indexes can be created using one or more columns, providing the basis for both rapid random lookups and efficient ordering of access to records. While creating index, it should be considered that what are the columns […]
Category Archives: mysqli
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, […]
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. […]