Question : I just started using MySQL Workbench drawing an entity-relationship diagram that I previously designed in paper. I want […]
Tag: table
Get number of deleted pages in PostgreSQL table/index?
Question : How can I get the number of deleted pages in a table or index? My purpose in asking […]
Copy column rows to be the first rows in column
Question : I have two database tables named vegan_ar_sheet1 (old) and vegan_en_sheet1 (new). Now I want to copy the column […]
Does SQL Server automatically update the foreign key relationships between tables when one of those tables is renamed?
Question : What happens to the foreign key relationships on a table if that table is renamed? Answer : Renaming […]
Create a DELETE statement that deletes Models that haven’t had a purchase since December 31st 2014
Question : We are given 5 tables. Orders Order number (Primary Key) Date of order Customer ID (Primary Key for […]
Update two tables, each on separate MySQL servers, on two different machines in one query?
Question : Have two MySQL servers running on two different machines in a local network. Using PHP and accessing via […]
How to create a table in a database on a different server
Question : I need to create Table B in database B on SQL Server B by querying Table A in […]
Return unique records based on shared column in 3 tables
Question : This is the database schema that I’m working with and I’ve included some sample data as an example […]
SQL Order by particular letters [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Two tables with same name in MySQL
Question : I got this weird issue today when I dropped a temporary table. I dropped the temporary table and […]