Go Back   Computer Forums > General Computing > Programming
Join Computer forums Today

Thread Tools Search this Thread Display Modes
Old 09-19-2012, 10: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
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.
************************************************** ********************************/
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

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 07:24 AM.

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