Kulka: Hi everyone, are global and database level privileges the most likely to be granted when creating a mysql user ?
Wykes: Xemdetia: it’s in a select statement
Schuchart: You cannot do : insert into foo select X from bar on duplicate key update foo_column = Y
Haddon: Naftilos76: what kind of question is that?
Nuchols: Because Y is not selected from bar
Hulbert: Boleware, it is a question of someone who is building a webinterface to a mysql managing app and would like to know whether it is really usefull to include table level, column level and routine level privileges editor apart from global and database level to his app : .
Tellis: JesusTheHun, ok- but looking at the original problem from a parsing angle you have still introduced multiple tables to the name space of that particular statement. Clumsily I am suggesting that when it is trying to dealias your sql statement from the form you wrote to an absolute form that describes what tables there is a duplicate lookup
Kotnik: It is mostly a question where your preferences are the answer. It is not a technical question. Can i have your preferences?
Huskins: Xemdetia: I think the conflict comes from the fact that you can either use VALUEScolumn or mySelectStatement.column to insert the duplicate row column value
Furutani: Naftilos76, I’d say support everything in privileges editor
Mizer: So as you suggested, it cannot exclude the non-prefixed column ***uming its from the insert table
Gorton: JesusTheHun, yes this might just be something that is part of the query p****r where this sort of transform is applied before the Niedzwiedzki of the statement is validated and any ‘scoping’ cheats it could apply come into play
Schlaffer: Naftilos76: starting by something trivial like “create a user and his db, give the user all the privileges on this db”
Lodrigue: Wrksx, i hoped that you didn’t say that, lol! Anybody else? Boleware ? You were the curious guy.
Dangelis: JesusTheHun, thanks very much.
Furutani: Naftilos76, actually I used a GUI interface recently and it was very nice to be able to give very specific privileges like execute on a stored procedure
Seegert: Naftilos76: the workflow is very important
Pruneda: Wrksx, you are right, thanks.
Bickers: When you create a user, it’s because you want to split privileges
Dauphinais: So you create a global website user = you create a db with it
Harelson: JesusTheHun, yes that is true other why have users!
Sharps: You want to create a user for your crons or so = you create a user
Broas: Can someone please look at this query if there is anything wrong? https://gist.github.com/PEMapModder/2115371c8f4f11d3d0d8
Collaer: Table old.players has 186492 rows and table old.ktipvp_kits has 10978 rows
Sawatzke: And the query has run for more than half an hour
Louil: PEMapModder: surprising x
Nordin: Do you realize the number of subquery in your query ?
Natalello: Each of it will be casted for every single row
Edds: So is there a way to optimize it?
Bachinski: PEMapModder: when are you going to learn how to use JOIN queries? :-
Furutani: PEMapModder, yes there is a way
Wybenga: I have just heard of it a few seconds before 😀
Stpaul: Does anyone have an app that uses prepared statements? I’m trying to reproduce a bug I’m seeing in performance_schema.events_statements_summary_by_digest
Harns: And btw, Arrow extends DamagingItem, not the opposite
Furutani: Cheramie, I have an app which uses prepared statement
Hartke: Arrow extends DamagingItem?
Frieman: Do you see the the statements with “SELECT DIGEST,LEFTDIGEST_TEXT,50 FROM performance_schema.events_statements_summary_by_digest WHERE SCHEMA_NAME = ‘whatever_your_db_is_called'”
Cuestas: The opposite makes no sense
Grupa: I was making an item that copies the behaviour of an arrow, and Arrow is part of the API but DamagingItem is my own cl***