This might be a little more helpful with making clear what I need help with, sorry I didn't do this sooner.
when I click on control panel this is what it looks like
then I click on data base
then I click on mysql
now the database I wan to use is city motors. there is currently nothing in it. I click on open manager and it prompts me for my pass word. afterward I get a window that looks like this
Now when I'm in class and I want to make/add to a table I would go to something that looks like this
Which Is what I get when I click on Query Window.
-------------------
I think it's that I'm not coding correctly, but I'm not sure. Is it possible that I'm not going to the right place to make the first table for this database?
This is an example of code that I use when I'm in class that works in class but not here.
DROP TABLE CUSTOMERS;
Create table Customers
(Customer# NUMBER(4) PRIMARY KEY,
LastName VARCHAR2(10),
FirstName VARCHAR2(10),
Address VARCHAR2(20),
City VARCHAR2(12),
State VARCHAR2(2),
Zip VARCHAR2(5),
Referred NUMBER(4));
INSERT INTO CUSTOMERS
VALUES (1001, 'MORALES', 'BONITA', 'P.O. BOX 651', 'EASTPOINT', 'FL', '32328', NULL);
Commit;