Hello how to access odoo 15 database tables by queries ? I have installed Mysql any try to import SQL file but lot of errors can you please give a guide to you database of the current system on local machine ?? thanks
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
To access the Odoo 15 database tables using queries, you can use the pgAdmin tool (if you are using the PostgreSQL database) or the MySQL Workbench (if you are using the MySQL database).
Here are the steps to access the Odoo 15 database tables using pgAdmin:
Open pgAdmin and connect to your Odoo 15 database.
Right-click on the database name and select "New Query".
In the query editor, enter your SQL query and run it by clicking on the "Execute" button or by pressing the F5 key.
The query will return the data from the selected table.
Here are the steps to access the Odoo 15 database tables using MySQL Workbench:
Open MySQL Workbench and connect to your Odoo 15 database.
Click on the "SCHEMAS" tab to see the list of all the databases in your system.
Click on the database you want to access and then click on the "SQL" button on the top menu to open the SQL editor.
In the SQL editor, enter your SQL query and run it by clicking on the "Execute" button or by pressing the F5 key.
The query will return the data from the selected table.
It's important to note that, to avoid errors, you have to have the proper credentials to access the database and the proper understanding of the database structure, the sql language and the security policies of the company.
You can also use the Odoo ORM api that is built on top of the database to access the data in a more user-friendly and safe way.
ok thanks
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
1
May 24
|
246 | ||
|
0
May 23
|
533 | ||
|
1
Mar 15
|
3544 | ||
|
1
Mar 15
|
3643 | ||
|
0
Mar 15
|
3407 |