mysqlsqldatabase
How to link pharmacies table with medicine table?
I have this two MySQL tables.
Pharmacies table
Medicine table
How can i link this two tables So that each pharmacy have their own medicine stock(One medicine can be in multiple pharmacies).
Solution
I would create a third table to join the two, something looking like this.
------------------------
| pID | mID | Quantity |
------------------------
- C# Entity Framework: Keyword not supported: 'port'
- mysql update with regexp
- Checking for valid MySQL result resource
- How to connect and insert record to mysql using c language?
- MySQL JSON datatype count and groupby
- Scan error: unsupported Scan, storing driver.Value type <nil> into type *string
- MySQL Testcontainer Timezone Issue When Using Spring Data JDBC
- How to start MySQL server from command line on Mac OS Lion?
- Import data.sql MySQL Docker Container
- Fire a trigger after the update of specific columns in MySQL
- MySQL auto-increment between tables
- After MySQL install via Brew, I get the error - The server quit without updating PID file
- Database error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
- How to select both sum value of all rows and values in some specific rows?
- MySQL: Cloning a MySQL database on the same MySql instance
- How to get number of a specifc row php
- MySQL collation to store multilingual data of unknown language
- Is there any bad of disable FULL_GROUP_BY
- WordPress Editor not updating files: Unable to communicate back with site to check for fatal errors
- Weird autoincrement issue on Spring Boot 3.3.0 with MySQL 8
- Data truncated for column?
- MySQL get a random value between two values
- Convert Mysql Dump File from INSERT to INSERT IGNORE
- MySQL column that will check if a date column is past 30 days
- Can't connect to mySQL server from wsl
- All data is become NULL when run Update Query MySQL
- Cross Join to DQL
- How to implement Fuzzy search in strapi cms
- one query for all array data! result is by separating for each id of array
- Invalid datetime format: 1366 Incorrect string value