http://www.highlycohesive.net Just another Dev Blog Sun, 11 Apr 2010 23:23:23 +0000 http://backend.userland.com/rss092 en How to page in MySql MySql uses the LIMIT keyword Syntax:  LIMIT <first item>, <numberofrows> The first item is 0, not 1. EX:  SELECT * FROM user ORDER BY name WHERE name LIKE 'j%' LIMIT 10, 5 Example returns the "third" page of a set paged as 5 items per page. How to List Indexes in ... http://www.highlycohesive.net/2010/04/more-mysql-paging-etc/ How To Login to MySql mysql -uuser -ppassoword Example mysql -uroot -pthisismypassword mysql --user=user --password=password Example mysql --user=root --password=thisismypassword How to List databases in MySql at mysql command prompt> show databases; Ex:  mysql> show databases; Select a database in MySql at mysql prompt> use databasename; Ex:  mysql> use my_db; Select list of tables in MySql at mysql prompt> show tables; Ex:  mysql> show ... http://www.highlycohesive.net/2010/04/basic-mysql-starter/ Ever noticed how everything in software is clannish?   We must be near the top of industries driven by "trendy" production processes... right after organic farmers. http://www.highlycohesive.net/2009/08/welcome-join-the-collective/