Question : I was logging slow queries of my system. Now I have few queries to be optimized and reset […]
Tag: mysql-workbench
ERROR 1091 (42000): Can’t DROP ‘created_date’; check that column/key exists [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Database design how to track a change on a patient row and set in a log table
Question : I need to track any update on my patients table. The table contains the following fields: Patient ID; […]
How do we express a weak entity to be dependent on another weak entity?
Question : Perhaps I am looking at my entities as a hierarchy rather than a set of relationships; for sake […]
What is an equivalent of EXCEPT(in PostgreSQL) in MySQL? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
I cannot access local database on terminal (MAC)
Question : I have access to my databases on phpmyadmin and mysql Workbench on my local computer but I have […]
MYSQL – How to make a table with a column that will sum columns from parent tables?
Question : I have a table called FOODS. FOODS has two foreign keys: IDsize and IDflavor. The parent tables FLAVOR […]
Copying MySQL tables, InnoDB tables not recognized
Question : I have to set up a database copy on my local computer. The problem is that that I […]
Error during table creation : is not valid at this position expecting an identifier
Question : I keeping getting this error during table creation: Order is not valid at this position expecting an identifier. […]
mysql workbench *reverse engineer* is not connecting tables graphically. How to fix?
Question : I thought that previously when I reverse engineered databases, mySql Workbench figured out the relationships from the id […]