Hi Peter,
Thanks for the reply. So are you saying like this?
Repair
RID INT, Date DATE, Tech_ID INT, R_TYPE_ID INT
1 2015-07-28 3243 3
2 2015-06-15 1253 1
Repair_details
ID, APL_TYPE VARCHAR(35), REPAIR_CODE CHAR(4), DESC
1 Refridgerator
C
I installed MySQL on a Mac Pro running OS Lion.
The installation was successful, but starting the mysql server generated the
following error message:
Martin-Muellers-Mac-Pro:~ martin$ sudo
/usr/local/mysql/support-files/mysql.server start
Starting MySQL
... ERROR! Manager of pid-file quit
Hi Richard,
On 7/29/2015 10:19 AM, Richard Reina wrote:
If I were to create a database table(s) to tract most common repairs to
different appliances I can't decide if it would be better to create one
table with a long ENUM column that contains repairs that could be
attributed to any appliance
If I were to create a database table(s) to tract most common repairs to
different appliances I can't decide if it would be better to create one
table with a long ENUM column that contains repairs that could be
attributed to any appliance or different repair tables for each appliance.
All the