You are here: HomeProjectsSeries 2 - Project and Product Management

Series 2 : MYSQL ERROR 1148 (42000) : The used command is not allowed

 

100018In 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.

Read more: Series 2 : MYSQL ERROR 1148 (42000) : The used command is not allowed

Series 2 : Examples Set 01

 Introduction

100019bSo 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.

Read more: Series 2 : Examples Set 01

Series 2 : Part 2 - A Practical Database Implementation of a Things To Do List

Abstract


100024In 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

Read more: Series 2 : Part 2 - A Practical Database Implementation of a Things To Do List

Series 2 : Part 1 - Project and Product Manangement: An Introduction

Abstract 

0000502In 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

Read more: Series 2 : Part 1 - Project and Product Manangement: An Introduction