Staredit Network

Staredit Network -> Computers and Technical -> help with mysql
Report, edit, etc...Posted by -bilal92- on 2006-09-01 at 15:39:02
im trying to find a good database place, I got microsoft access but i dont think theres a place where u can input anything, so im trying to find a mysql thing from www.mysql.com but icant find anythiung can someone help me plz?

k the book tells u to input queries like this

# Use the "my_database" database
USE my_database;

#create a table called "user_log" with 3 columns
CREATE TABLE OF NOT EXISTS user_log
(
id INT,
date TIMESTAMP,
first_name VARCHAR(20)
last_name VARCHAR(20)
);

#confirm the "user_log" table format
EXPLAIN user_log;

#delete this sample table
DROP TABLE user_log;

Now it shows this in the book, but in microsoft access all there is this...

user posted image

So I cant type anything for the queries, does this mean that I dont have to create tables? BUT, I need queries right?? Say if I want a database for someone to log in, or keep records of accounts. This is confusing I dont even know what im saying, but do you know anything about mircosoft access or how to input queries? Then how do you create a blank page, with no tables on it? but what do you prefer i use, cause access is pretty confusing
Report, edit, etc...Posted by Mini Moose 2707 on 2006-09-01 at 16:26:12
I don't understand exactly what you're asking (I'm assuming you already have hosting and a database and are looking for something to actually use the databases), but I think you're looking for something like phpMyAdmin.
Report, edit, etc...Posted by -bilal92- on 2006-09-01 at 18:09:43
k well i read directions in the book and i think i got it
Next Page (1)