Posts by Pedro Cunha • 195 points
5 posts
-
3
votes1
answer1467
viewsQ: Mysql Error 1114 (HY000): The table is full
I exported a database with a 14GB Mysql size from a Windows OS computer and I intend to import it into Mysql from a Ubuntu 14.04 OS computer I used the following command to export the database…
mysqlasked Pedro Cunha 195 -
3
votes1
answer3611
viewsQ: Mysql Workbench does not start
I have been working daily on mysql Workbench. It turns out that out of nowhere the tool has stopped working. I click on the icon and nothing happens. I tried to restart the computer as well as…
mysql-workbenchasked Pedro Cunha 195 -
0
votes1
answer76
viewsQ: Remove duplicate records from a table
Having the following tables without keys still defined: Aeroplane (code_aviao, code_company, year, type_engine, type_airplane, status) Flight ( Flight code, Flight number, plane code, code_company)…
-
1
votes1
answer3043
viewsQ: mysql error code 1111. invalid use of group Function
I tried using the following query in my database: SELECT MAX(COUNT(DISTINCT c.unique_carrier)) FROM companhia_aerea c, avioes4 a, ponte2 v WHERE c.unique_carrier = a.UniqueCarrier AND a.TailNumber =…
-
2
votes1
answer1016
viewsQ: Populate tables with multiple foreign keys
I have a database with the following tables: Airport ( Iata PK, airport, city, state, country, lat, long) Causa_cancellation ( code PK, description) Manufacturer (Idfabricante PK, manufacturer name)…