Log Stats
In this example we will log some user stats in a database and then display the resulting info on a seperate page . Firstly we need to create our database .
CREATE DATABASE stats;
Now we select this database
USE stats;
And now we create our table called stats.
CREATE TABLE stats (
id int DEFAULT '0' NOT NULL auto_increment,
browser varchar(255) NOT NULL,
ip varchar(15) NOT NULL,
recieved logdate NOT NULL,
PRIMARY KEY (id)
);
Now we shall check that we have created the table properly by typing the following
DESC stats;
This is what you should see in your MySQL client window (Windows).
In the next part of this tutorial / script we will show you how to add data in to the database
Goto PART 2
|
