Restart, Start, Stop MySQL from the Command Line Terminal, OSX, Linux To restart, start or stop MySQL server from the command line, do the following at the shell prompt… Start Stop Restart Mysql Commands Start Mysql on Linux — /etc/init.d/mysqld start Stop Mysql on Linux — /etc/init.d/mysqld stop Restart Mysql on Linux — /etc/init.d/mysqld restart […]
MySQL provides a LIMIT clause that is used to specify the number of records to return. The LIMIT clause makes it easy to code multi page results or pagination with SQL, and is very useful on large tables. Assume we wish to select all records from 1 – 30 (inclusive) from a table called “Orders”. […]
If you want to loop throuh the mysql result set twice then use below way. $result = mysql_query(“SELECT * FROM my_table”);while($row = mysql_fetch_assoc($result)) {// inside the loop} The problem is, if you want to loop through the same result set again, you will get an error because the internal pointer is currently at the end […]
