Bin-Co http://www.bin-co.com Great Scripts. For Free. For Everybody. Sat, 05 Jul 2008 00:00:00 -0700 RSSPhpilot V1.00.A http://blogs.law.harvard.edu/tech/rss LIMIT Command http://www.bin-co.com/database/sql_tutorial/limit.php if you use the LIMIT option you can limit the number of results. To get the just 5 characters, the command would be...

Read 'LIMIT Command'... ]]> Sat, 05 Jul 2008 00:00:00 -0700 http://www.bin-co.com/database/sql_tutorial/limit.php Database Relations http://www.bin-co.com/database/sql_tutorial/database_relations.php data in one table is related to the data in another table. This connection between two tables is called a relation. When there is such a relation between two tables, these tables will be connected by inserting the primary key of one table into the corresponding row of the other table. The field used in such a way to connect the two tables is known as the foreign key.

Read 'Database Relations'... ]]> Thu, 05 Jun 2008 00:00:00 -0700 http://www.bin-co.com/database/sql_tutorial/database_relations.php Joining Data From Multiple Tables http://www.bin-co.com/database/sql_tutorial/join_tables.php join these tables together to get the data. The JOIN statement in SQL is created for a situation like that.

Read 'Joining Data From Multiple Tables'... ]]> Wed, 28 May 2008 00:00:00 -0700 http://www.bin-co.com/database/sql_tutorial/join_tables.php Update/Delete Existing Data in a Table http://www.bin-co.com/database/sql_tutorial/update_delete.php insert new data, let see how to edit the existing data. You can edit the data in a table using the UPDATE command.

Read 'Update/Delete Existing Data in a Table'... ]]> Fri, 16 May 2008 00:00:00 -0700 http://www.bin-co.com/database/sql_tutorial/update_delete.php Inserting Data http://www.bin-co.com/database/sql_tutorial/insertion.php
Read 'Inserting Data'... ]]> Wed, 14 May 2008 00:00:00 -0700 http://www.bin-co.com/database/sql_tutorial/insertion.php URL Lister Firefox Plugin http://www.bin-co.com/tools/firefox/extensions/urllister/ URL Lister is a Firefox Plugin that shows the URLs of all the open tabs in a textarea so that it can be copied easily.

Read 'URL Lister Firefox Plugin'... ]]> Thu, 08 May 2008 00:00:00 -0700 http://www.bin-co.com/tools/firefox/extensions/urllister/ joinPath() - Combines Multiple Path Fragments http://www.bin-co.com/php/scripts/filesystem/join_path/
Read 'joinPath() - Combines Multiple Path Fragments'... ]]> Tue, 06 May 2008 11:12:59 -0700 http://www.bin-co.com/php/scripts/filesystem/join_path/ SQL Functions http://www.bin-co.com/database/sql_tutorial/sql_functions.php grouping. We saw AVG() in action. Here we are going to see the other available functions. Some of the functions may be same across different SQL databases - but many others will be different. Here is a few links to the SQL function documentation for the most popular database servers...

Read 'SQL Functions'... ]]> Tue, 29 Apr 2008 00:00:00 -0700 http://www.bin-co.com/database/sql_tutorial/sql_functions.php Group Multiple Rows using GROUP BY http://www.bin-co.com/database/sql_tutorial/grouping.php group together multiple rows in the result and then get an aggregate from the grouped rows - that's the function of GROUP BY.

Read 'Group Multiple Rows using GROUP BY'... ]]> Sat, 19 Apr 2008 00:00:00 -0700 http://www.bin-co.com/database/sql_tutorial/grouping.php Sorting the Results using ORDER BY http://www.bin-co.com/database/sql_tutorial/sorting_order_by.php
Read 'Sorting the Results using ORDER BY'... ]]> Thu, 17 Apr 2008 00:00:00 -0700 http://www.bin-co.com/database/sql_tutorial/sorting_order_by.php