- Created on Monday, 03 June 2013 15:30
- Last Updated on Thursday, 20 June 2013 15:54
In previous parts, of Series 2, data has been loaded into the database, from a text file, using the MYSQL statement:
LOAD DATA INFILE './ttd_entries.txt' INTO TABLE test.ttd FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES;
As it turns out using this statement is probably not the best way to load data into the database as it can lead to a series of errors, as we found out below.
- Created on Saturday, 01 June 2013 14:44
- Last Updated on Friday, 28 June 2013 05:13
So far in the series it has been demonstrated how to create a database table, ttd, a list of things to do and a notes table, used to store comments on things to do. A table ttdnotes relates the two activities and provides things to do with notes. In this example set a series of basic queries will be performed, using MYSQL's SELECT statement, to extract information from the ttd table.
- Created on Monday, 27 May 2013 14:21
- Last Updated on Friday, 07 June 2013 08:17
In this part of the series the two entities and their attributes, from the E-R Diagram developed in the previous part of the series, are used to define two database tables. Each tables, the things to do and note tables, are then created in the database by executing MYSQL statements from a file. Then finally, after each table is populated with data from a text file, a method of creating a composite key from the two table's primary keys, is used to create the relationship between the things to do and notes tables.
DOWNLOADS are almost available and are on our things to do list. See the Download section at the end of this document on how to download the data for Series 2 Part 2. Alternatively grab the code from Series 2 : Example Set 01
- Created on Friday, 24 May 2013 09:14
- Last Updated on Friday, 14 June 2013 00:25
In this article the case for requiring a database, to manage the site's FPGA based tutorials, projects and products, is presented. The decision is then taken to develop an in-house engineering database. The project is commenced with a task to create a things to do list entry by presenting a problem statement. From the problem statement the database's things to do list requirements are extracted. These requirements have then been presented graphically in the form of an entity-relationship diagram, which will be used as guidelines for coding the database