|
Post by CD on Jul 6, 2005 21:55:41 GMT -8
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?
|
|
100%
|
Post by Aaron on Jul 7, 2005 13:50:26 GMT -8
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?
|
|
|
Post by CD on Jul 7, 2005 19:02:36 GMT -8
No, but I have it. I create tables manually. But I'll look at phpMyAdmin then.
|
|
100%
|
Post by Aaron on Jul 7, 2005 21:17:16 GMT -8
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 ;
|
|
|
Post by CD on Jul 7, 2005 23:51:37 GMT -8
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.
|
|
100%
|
Post by Aaron on Jul 8, 2005 8:49:11 GMT -8
How does it save time? =P
Eventually I'll look more into it.
|
|
|
Post by CD on Jul 8, 2005 10:41:56 GMT -8
Because eventually you'll be doing it from memory, instead of waiting for pages to load and clicking links.
|
|
100%
|
Post by Aaron on Jul 8, 2005 14:08:55 GMT -8
The page loads are practically instant .. even in 28.8 k XD
|
|
|
Post by CD on Jul 8, 2005 18:04:07 GMT -8
So?.... <_< >_> Its a long wait to me! >.<
|
|
100%
|
Post by Aaron on Jul 10, 2005 12:45:04 GMT -8
Have you tried it?
|
|