Making a Simple Table

Databases
1

Hey, I was just wondering how I could go about making a simple MySQL table with 3 columns, i.d (#), first name, and last name?

It’s for practice, and I can figure it out easily on MS access, but not MySQL. What is the best way to create tables in a MySQL database, I’m a new user :wink:

Basically, something like this, but in a MySQL table;

I.D | First Name | Last Name

1 | John | Doe

etc

Elementax

2

run this query –

CREATE TABLE simple
( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT
, firstname VARCHAR(99)
, lastname VARCHAR(99)
);
3

If you haven’t done it already, read through the tutorial in the MySQL manual. Chapter #3.

It will help you get familiar with this database app if you are going to use it.

4

I was just confused about one thing (I may be realllllly off, but please let me know).

In order to view my tables, etc, I must be running mysql server on either my PC (local) or my webhost if I were to upload it, correct?

5

you have to be running it on your PC or host. The host most likely WILL NOT allow you to install it, they would either provide it or not. If you find a host that doesn’t provide mysql, keep looking for a better host.