Go Back   Computer Forums > General Computing > Programming
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 09-19-2012, 11:42 PM   #1
In Runtime
 
WYSIWUG's Avatar
 
Join Date: Aug 2012
Location: New Zelaland
Posts: 381
Exclamation SQL-Code wont execute

Will this code execute on your mySQL? It wont on mine and the code is perfect!



Drop database if exists dbCardID;
Create database dbCardID;
Show Databases;
/**************************
Create Table Card IDs
Department
Card ID
***************************/
Use dbCardID;
Drop table if exists tblDepartment;
create table tblCardID
(
Department varchar(20),
CardID varchar(20),
Name varchar(15),
CardUnlockAreas varchar(100)
);
show tables;
Describe tblCardID;
Use dbCardID;
/************************************************** ********************************
These are all the employees that have Swype Cards to disarm alarms and unlock doors.
If a value is ALL DOORS AND ALARMS, the only doors and alarms the card will work
with, is in the department the name is under. I.E Account cards will not unlock
Shipping doors.
CLEANERS HAVE FULL ACCESS TO ALL AREAS
************************************************** ********************************/
Insert into tblCardID values
('Shipping','001','Dale Heywood','ALL DOORS AND ALARMS'),
('Accounts','002','Sam Banks','Accountting Office & Staff Room & Toliets'),
('Cleaners','003','Sarron Hanks','ALL DOORS ONLY MAIN BUILDING ALARM'),
('Truck Arrivls','004','Harry Kiles','Main Entrey and Toliets'),
('Truck Loading Ramp','005','Peter Ravon','Accountting Office & Staff Room & Toliets'),
Select * from tblCardID;
__________________
I hope that the world runs out of oil today so we can build a world free of hate and greed and money. Build one based on love and respect for all forms of life.
WYSIWUG is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 03:32 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0