distal-attribute
distal-attribute
distal-attribute
distal-attribute

How to add a field name to existing database?

User, date Message
Written by surgey46
4 years ago
Category: General
4 posts since Fri, 24 Dec 10
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.
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
Databases do not have fields, tables do. In order to add columns, just double click the relevant table and click the "Add" button.
Written by surgey46
4 years ago
4 posts since Fri, 24 Dec 10
How to create a table?
Written by surgey46
4 years ago
4 posts since Fri, 24 Dec 10
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...
Written by member
4 years ago
32 posts since Fri, 23 Apr 10
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)
Written by member
4 years ago
32 posts since Fri, 23 Apr 10
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.
Written by surgey46
4 years ago
4 posts since Fri, 24 Dec 10
Finally I created table in my database. I named column also.
How would I add data to my table?
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
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.