MySQL question

[CD]

Once you create a table, is there any way to insert a new column? Not row, just column?

Like, you have these columns so far:
ID
Title
Text
Creator
Date

Could you insert another one?

[Aaron]

Yes there is a way. That would suck if there wasn't XD You'd have to make a whole new table.
Are you using phpMyAdmin?

[CD]

No, but I have it. I create tables manually. But I'll look at phpMyAdmin then.

[Aaron]

Manually ....... ?

That must be .. fun .. lol.

Definately look into phpMyAdmin, if you have cPanel you should have it.

A cool thing about phpMyAdmin is you just fill in a few inputs and it automatically adds it for you, plus it gives you the source it used.

Example:

I just filled in inputs to create a table named "users" and it has two fields "id" and "name".
Then it shows me the source:

CREATE TABLE `users` (
`id` INT NOT NULL ,
`name` TEXT NOT NULL ,
PRIMARY KEY ( `id` )
);

It's easy to use .. and kind of teaches you SQL at the same time (even though I rarely look at the source in detail =P).

---

Also, those aren't called columns, they're called fields.

And looking at the source it gave me this is what you do:

ALTER TABLE `tablename` ADD `added_fieldname` TEXT NOT NULL ;

[CD]

XD Manually is fun. What if you ever make a code like PHPBB for someone to install? It has to be done manually. XP

But yeah, I like manual. >.> Its fun. Saves time. Learn more. Other crap like that, that makes it seem important. System of a Down.

[Aaron]

How does it save time? =P

Eventually I'll look more into it.

[CD]

Because eventually you'll be doing it from memory, instead of waiting for pages to load and clicking links.

[Aaron]

The page loads are practically instant .. even in 28.8 k XD

[CD]

So?.... <_< >_> Its a long wait to me! >.<

[Aaron]

Have you tried it?