Mcclenon: Voce, awesome. Ačiū :
Whisenand: Croutch: So an entity set does not refer to a specific table in a database, but to “Movie” as a cl***ification?
Heximer: Miesco: Entity is term from Relational theory. In practice it is rarely used
Croutch: Well, a table usually is a model of the entity set
Dedicke: Mithani, it should be fine, cronjob just automates what you would do by hand
Heximer: Miesco: In practice we talk about Tables, Columns, Rows
Heximer: Miesco: What we call Tables in the theory is called Relation because it defines or describes the relation between entities and as such it also stores information regarding thos entities
Nuuanu: Croutch: So an entity is like an instance of a cl*** in c++, and entity set is like a cl*** in c++?
Heximer: Miesco: Be careful with ****ogies with cl***es and instances
Croutch: Miesco: yeah, pretty close
Rossing: Croutch: So if I saw a table ‘select * from movie’, this would NOT be an entity set, but rather a model of an entity set? The entity set would be the string “movie”?
Heximer: Miesco: movie is not a string in your example. It is a table
Croutch: It’ll return you all the entities you have information about.
Croutch: And your table is your model of the entity set of movies
Heximer: Miesco: You can think of a table as of cl*** definition and rows within the table as set of instances although it is better to avoid such ****ogy
Heximer: Miesco: You can think of a definition of a table as of .”
Heximer: Miesco: It is bad ****ogy because the properties of single entity can be scattered across multiple tables
Heximer: Miesco: If you design database for movies you will end up with at least 5-6 tables. Maybe more
Durrah: Okay thanks. One last question. Should one name an entity set with all lowercase, and should it be plural?
Helmsing: Miesco: pick a naming pattern, and be consistent
Motayen: Helmsing: Is it suppost to be “Star Wars” _is a_ movie? Or is it “Star Wars” _is in_ movies?
Heximer: Miesco: Entities are abstract.
Heximer: Miesco: “Star Wars” is mere string :
Heximer: Miesco: “Star Wars: Episode IV – A New Hope” is a name of particular movie which can be idenitified by particular Primary Key value. In imdb for example it sems to be “tt0076759”
Heximer: Miesco: “Star Wars” alone is ambiguous because it can refer to several different movies
Atherley: Hi, on another server, I got issues to get a mysqldump of a database that is corrupt.
Kukielka: I’ve got a database with ch****t=utf8, collation and characterset are utf8 utf8_general_ci too. now from stored procedure i’m getting: SQLSTATEHY000: General error: 1267 Illegal mix of collations latin1_swedish_ci,IMPLICIT and utf8_general_ci,COERCIBLE for operation ‘ifnull’ – how do i fix that?
Kukielka: I’ve also tried to recreate database after server reconfiguration & restart, but that didn’t help either :
Heximer: Kukielka: How exactly did you get this error and when?
Heximer: Kukielka: When creating the procedure or when CALLing it?
Teeples: Mysqldump: Couldn’t find table: “usr_web27_1.sql”
Heximer: Kukielka: That’s not even stored procedure, but stored function
Ngoun: Mysql -uroot -pR8VnXKCZ -e’SHOW DATABASES;’ grep web27 usr_web27_1
Kukielka: Salle, thats a function that calls a procedure actually :
Heximer: Kukielka: Pretty bad idea
Kukielka: Works and can’t be changed for now
Heximer: Kukielka: If you can’t change them you can’t fix the error :
Kukielka: Salle, i can’t change the overall structure, but i can change syntax
Heximer: Kukielka: Find out what statement returns that error and fix it. Most likely it depends implicitly on the connection character set