Illegal character found in search text!
[Only A - Z, a - z and 0 - 9 are allowed]
<div class="left"><p><strong>About the Structured Query Language (SQL)...</strong><br /><br />SQL commands are mainly categorized into four categories as:</p><p><strong>DDL</strong>: Data Definition Language<br /><strong>DQL</strong>: Data Query Language<br /><strong>DML</strong>:<strong> </strong>Data Manipulation Language<br /><strong>DCL</strong>: Data Control Language<br /> </p><ol start="1" style="list-style-type: lower-alpha;"> <li>DDL creates the tables with the required columns and with corect data types (numbers; dates; text strings; etc.)<br /> </li> <li>DQL reads from one or more rows of one or more tables in the database.<br /> </li> <li>DML writes a <u>new</u> row (<u>insert</u>) to one or more tables in the database or <u>update</u>s existing fields in one more rows of a table. DML can also <u>delete</u> one or more rows in a table in the database.<br /> </li> <li>DCL authorizes (<u>grants</u>) the database user to perform DDL; DQL or DML operations or <u>revoke</u> the database user's privileges to perform database operations.</li></ol><p><br />SQL is a common database language used in many Relational Database Management Systems (RDBMS) but it has a lot of dialects.<br /><br /><a href="https://en.wikipedia.org/wiki/SQL-92" target="_blank">SQL-92</a> statements are interpreted by most RDBMS.<br /><br /><a href="https://en.wikipedia.org/wiki/SQL" target="_blank">Read more about SQL here</a>... <br /><br /> </p></div><div class="main"><span style="font-size:24px;">Selecting the right database definition file during </span><span style="font-size:24px;">installation</span><br />n-gen.net CMS offers all database table definitions and initial data compiled into one .sql file.<br /><br /><span style="font-size:20px;"><span style="color:#339900;"><u><span style="background-color:#ffff00;">If you are in doubt you should select the newest <span style="font-family:Courier New;Courier;monospace;"> </span></span><span style="font-family:Courier New;Courier;monospace;"><strong><span style="background-color:#ffff00;">install[</span><span style="background-color:#ffff00;">yyyy</span><span style="background-color:#ffff00;">-MM-dd].</span><span style="background-color:#ffff00;">sql</span></strong></span><strong><span style="background-color:#ffff00;"> </span></strong><span style="background-color:#ffff00;">file</span></u><span style="background-color:#ffff00;">!</span></span></span><br /><br />Typically the installation files follow these naming conventions:<p><span style="font-family:Courier New;Courier;monospace;"><strong>? install[yyyy-MM-dd].sql => </strong></span>an SQL-file that contains all you need for installing n-gen.net CMS;<br /> i.e. <strong><span style="font-family:Courier New;Courier;monospace;">install[2020-06-06].sql</span></strong><br /><span style="font-family:Courier New;Courier;monospace;"><strong>? install_addXXX[yyyy-MM-dd].sql </strong></span> => an SQL-file that contains new tables to be added to the database.<br /><br /><br /><img alt="" src="/images/install/SQLcommands.png" style="width: 100%; height: 79%;" /></p></div>