Current location - Loan Platform Complete Network - Big data management - How does pb add content to database tables?
How does pb add content to database tables?
No matter how you add it, you must first configure the database connection of PB, which is in DataBase Painter. Configure database connections.

After the configuration is successful, you can directly open the database you configured in DataBase Painter, select the table to which you want to add data, then right click, edit the data, and open all the data. Then there are two buttons in the menu above. Insert means adding a blank line, and Save means saving the data in the table. This can be done, but it's all handwritten.

You can also import data here, but the format must match, including the number, order and type of fields, and the structure of the query must match. For this so-called query, you can use the framework opened by edit data, or you can write a query statement yourself and click the execute button on the isql session page to execute the query. However, this executed query needs a table, otherwise you don't know which table to save.

You can also write your own program to insert it. Use the data window, or use the insert statement to insert data.