I was making an item that.

 
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***