|
|
| Line 8: |
Line 8: |
| | </p> | | </p> |
| | | | |
| − | ==MariaDB Examples==
| |
| − |
| |
| − | ===In-Class Example of Manually Creating a Table===
| |
| − | <p>This data table was uploaded as a TSV (tab separated values) file.</p>
| |
| − | <p>LOAD DATA INFILE '[data table pathname]' INTO TABLE `test` FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINE</p>
| |
| − |
| |
| − | ===Answer to In-Class Question===
| |
| − |
| |
| − | <p>Q: Find the maximums in column 2 of quintiles based on column 1 </p>
| |
| − |
| |
| − | <p>
| |
| − | The following will create a temporary table that will order [var1], hold [var2] and also create a column with a counter variable named "id".
| |
| − | <br /><br />
| |
| − | A: CREATE TEMPORARY TABLE `rank` (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY) SELECT [var1],[var2] FROM `test` WHERE [var3] = "string" AND [var1] <10000000 ORDER BY [var1];
| |
| − | <br /><br />
| |
| − | Then the use of the next command will need to be repeated for each quintile to find the maximum for each one.
| |
| − | <br /><br />
| |
| − | A: SELECT MAX([var2]) FROM `rank` WHERE id BETWEEN [calculated lower bound of quintile] AND [calculated upper bound of quintile];
| |
| − | </p>
| |
| | | | |
| | {{This Is Your Brain On Informatics}} | | {{This Is Your Brain On Informatics}} |
Revision as of 03:28, 18 January 2014
MariaDB is an opensource project that is an offshoot of MySQL because the developers felt that Oracle was doing a poor job managing MySQL (actually, the developers came from Oracle). Because MariaDB was built to be a better managed version of MySQL, many of the resources on the internet for MySQL will be applicable for MariaDB. Below are several topics on MariaDB to make it operate in the context of an NGINX server.
