Croutch: So a “set entity”.

 
Sorrel: But 1M might be too small

Sermeno: Salle, I’ll try to define tmpdir=something as you suggested.

Heximer: Floogy: 1MB is too small for any practical purposes

Byro: Yes I have to moive the server to a decent one.

Eaglen: Salle: yeah I realised after it was just my gui pretending to rename it

Eaglen: So I switched to phpmyadmin and it did a better job

Heximer: Eaglen: switch to mysql cli and you will never see it pretending

Heximer: Eaglen: RENAME DATABASE was implemented once, but then removed because there are lot of problems with it

Ashlin: Salle: Sorry, I have no idea about that manual entry.

Heximer: Ah yes indeed it is not in 5.6 manual

Heximer: Eaglen: http://dev.mysql.com/doc/refman/5.1/en/rename-database.html

Eaglen: But I really do find gui tools quicker to use except when I’m writing proper queries

Evens: Salle, thank you! tmpdir=/var/cache/mysql_temp solved it. – Checking for corrupt, not cleanly closed and upgrade needing tables.

Troha: Http://sqlfiddle.com/#!9/9eecb7d/22250 – MySQL is saying that I am missing a Semi-Colon at line 24, however there clearly is one there. This code runs perfectly outside of a ‘create event’ but won’t run when side one?

Admas: Probably you have to change delimiter

Morentin: Mithani: look at second example in https://dev.mysql.com/doc/refman/5.1/en/stored-programs-defining.html

Alrais: Voce: Tested, still the same result unfortunately.

Benevento: It’s in the link I posted for sqlfiddle

Atkison: Http://sqlfiddle.com/#!9/9eecb7d/22250

Hone: It doesn’t run on sqlfiddle anyway, so it would be much easier to see it if you just used some pastebin service

Raya: Http://sqlfiddle.com/#!9/9eecb7d/22252

Mock: Mithani: use ; inside your create event statement, use $$ to end it

Mccrohan: Mithani, “LOAD DATA is not allowed in stored procedures” – http://dev.mysql.com/doc/refman/5.6/en/stored-program-restrictions.html

Vigor: All the blue dots next to each command telling me that the code is correct disappear though. does that matter?

Garbe: So how do I automate a load and unload event?

Caponi: Hello. I need you ***istance. https://gist.github.com/cerkauskas/690d388771a1bd496b39 how can I make update work? I think gist explains logic I need. If you have any questions, ask. Thank you

Segui: Jkavalik: so if I run the .sql script with the import through a cron job it’s fine. just not through mysql’s own event scheduler?

Meysembourg: Hi. What is an entity?

Croutch: Is this an SQL or philosophical question?

Hlastala: I read the sailboat book, I read Ullman’s “A First Course In Database Systems”, and I do not know what an entity is.

Croutch: Http://whatis.techtarget.com/definition/entity

Vaine: Cerkauskas: add JOIN and GROUP BY

Feutz: Miesco: http://dev.mysql.com/doc/mysqldoc-guide/en/entities.html

Casilla: So, “Star Wars” would be an entity, and “Star Wars”, and “Gone With The Wind” would be part of the same entity set?

Pietrini: Then what is “Movie” an example of?

Heximer: Miesco: What is an line? :

Heximer: Miesco: What is a sheet?

Goolia: Voce, I updated update query in gist. However, it doesn’t like to be grouped by anything :/

Heximer: Miesco: In context of sailboats these two have very specific meaning which is way too different from their meaning in computing and SQL in particular. Sheets don’t exist in SQL

Heximer: Miesco: I don’t know recall “entity” being used in sailing though

Luhman: Cerkauskas: I added comment

Froebe: Croutch: https://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html There, Buffy is an example of an entity, and Buffy and Bowser are both in the entity set?

Dinneen: Croutch: So a “set entity” can refer to either a group of entities OR a entity category?