29.Jun.200612:29 am
Mood: NA
INSERTING YOUR NEW FIELD
Now that you have your field planned, you have to add it.
I usually do mine through a program my host has on my site called phpMyAdmin, but you can also do this by hand.
To do it by hand, you would write:
MySQL:
-
ALTER TABLE `fanfiction_authors` ADD `yourdatabasename` DATATYPE( LENGTH ) DEFAULT 'your default value' NOT NULL AFTER `FIELD your new one comes after`;
Through phpMyAdmin, you would click on the author's table and then scroll down below the structure listing to add your field in there. Choose the number of fields you want to add and where you want to add it. You'll then be taken to a page where you can fill in your necessary information.
Step 1: Choose the number of fields you need and where you want the new field added (Screenshot 1)
Step 2: Fill in your information (Screenshot 2)
|
|
