Differences

This shows you the differences between two versions of the page.

--- reference:portable_sql [2015/12/04 18:36] – mnewnham
+++ v5:reference:portable_sql [2016/01/13 02:31] – ↷ Page moved from reference:portable_sql to v5:reference:portable_sql mnewnham
@@ Line 153: / Line 153: @@
 ===== DDL and Tuning =====
-There are database design tools such as ERWin or Dezign that allow you to generate data definition language commands such as ALTER TABLE or CREATE INDEX from Entity-Relationship diagrams.
+There are database design tools such as ERWin or Dezign that allow you to generate data definition language commands such as ''ALTER TABLE'' or ''CREATE INDEX'' from Entity-Relationship diagrams.
 However if you prefer to use a PHP-based table creation scheme, ADOdb provides you with this feature. Here is the code to generate the SQL to create a table with:
@@ Line 272: / Line 272: @@
 The best way to ensure that you have portable SQL is to have your data tables designed using sound principles. Learn the theory of normalization and entity-relationship diagrams and model your data carefully. Understand how joins and indexes work and how they are used to tune performance.
-Visit the following page for more references on database theory and vendors: [[http://php.weblogs.com/sql_tutorial]]. Also read this article on Optimizing PHP.
 (c) 2002-2014 John Lim.