How to add a field name to existing database?

[expired user #5407]'s profile image [expired user #5407] posted 13 years ago in General Permalink
Hi, I am new to this, I need to add just one field to my existing database, like for example "name" . Could you tell how this can be done. Thanks in advance.
ansgar's profile image ansgar posted 13 years ago Permalink
Databases do not have fields, tables do. In order to add columns, just double click the relevant table and click the "Add" button.
[expired user #5407]'s profile image [expired user #5407] posted 13 years ago Permalink
How to create a table?
[expired user #5407]'s profile image [expired user #5407] posted 13 years ago Permalink
And I forgot also to ask, how to specify table name after creating it, also I need just one column for this table for example "IP".
The column name would be "IP_Id".
waiting for replay...
[expired user #4881]'s profile image [expired user #4881] posted 13 years ago Permalink
Click on the database name on the left, then click on the third tab on the right labeled table.

Choose add, use the dropdown choices on the line it opens up.

Just a guess you can probably use datatype int, length 11, no checkmarks and auto increment (if you want each id to be the next available number)
[expired user #4881]'s profile image [expired user #4881] posted 13 years ago Permalink
Click on the third tab on the right labeled table. Table name is below all of the tabs but above the add button.

Remember to hit save when adding a row and when renaming the table. You can make all needed changes and then hit save.
[expired user #5407]'s profile image [expired user #5407] posted 13 years ago Permalink
Finally I created table in my database. I named column also.
How would I add data to my table?
ansgar's profile image ansgar posted 13 years ago Permalink
When you have your table doubleclicked / selected, you will see a Data tab right besides the active Table tab. Go to the Data tab and press Ins to add the first row.

Please login to leave a reply, or register at first.