Dammann: J_hertz123: both of those things are possible
Umland: Hi, does mysql workbench support granting replication slave to a user or is that only a command line priv?
Dammann: Skywise: workbench can execute arbitrary SQL statements, which would include any GRANT statement you’d execute using the command-line client
Balwinski: Kolbe: my experiance is that if there are keys on the tables mysql will use does and the data will be returned in some kind of order, but the user can sort create order by on the data which removes that problem
Mcgurl: Much to learn, I have
Dammann: Skywise: i have no idea whether workbench includes support for clicking on buttons and checkboxes to grant the replication slave privilege, though
Higashida: Kolbe, understood, but i’m wondering if that is in a menu i haven’t seen
Dammann: J_hertz123: if you don’t write ORDER BY, you have zero guarantee about the order of the data you get back
Dammann: Skywise: i have no idea.
Cabada: Kolbe, yeah thats what i was asking, i’ll do it via command, but i was just checking
Dammann: Skywise: you can try #workbench, maybe?
Muellerleile: Oh, i didn’t know about that, thx
Dammann: Skywise: or look at the do***entation :
Dammann: Skywise: https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-users-and-privileges.html
Kunesh: Kolbe: I get that, but in my opion the behaviour seems to be that most of my tables are returned in a predictable way, if that is not the case it is not very hard to add a default order by
Dammann: J_hertz123: stop saying that you think you’ve observed some behavior. i’m telling you that at best it’s coincidental and at worse probably just wrong
Clerf: Kolbe, thx, i see i have to first enable replication admin for them to show up, thats not exactly inuitive
Dammann: It’s fairly hard to add a default order by, since that could drastically change the execution plan of the query
Dammann: Skywise: or you can select “Custom” presumably
Dammann: Skywise: i think “not exactly intuitive” is a great description for the entirety of MySQL Workbench, and I must wonder why you are trying to do this silly task in the first place instead of just granting the privileges you know you want to grant using a GRANT statement
Segota: Kolbe: now, you probably know more then I do about MySQL, but you have no idea what my use case is, so please stop telling me what I can and can not say
Dammann: J_hertz123: i already asked you want your use case is, so you’ve had an opportunity to share that information
Dammann: If indeed that’s the case, and you want to provide some additional contextual information, go for it
Dammann: Otherwise the very best i can do is provide generic warnings that the kind of thing you appear to be doing is unwise or unsafe or otherwise objectionable
Junker: Kolbe: which is absolutely ok, but there is a difference between that and telling someone that they can’t have an opinion. no matter how wrong you think it is
Dammann: J_hertz123: yeah, it’s absolutely fine to tell someone that their *opinion* is incorrect or based on faulty information
Dammann: But i’m gonna leave you and your opinions alone for a while and get back to some other work : good luck!
Milson: Kolbe: Thank you, I appreciate that you took the time to answer my questions and pointed out where there might be problems with my approach :
Anderholm: Oh “drop” means “delete” 😀
Mattiace: Kolbe, only because i thought it should work and i was missing something, but yes at this point the command would be simpler
Chillo: Hmmm no delete is actually something else
Neumiller: Tylak: MySQL Tutorial: http://dev.mysql.com/doc/refman/5.6/en/tutorial.html SQL Tutorials: http://www.sqlcourse.com http://tut.php-quake.net/en/mysql.html and sqlzoo.net
Perruzza: Is “SERIAL” just “BIGINT” ?
Newcome: I read it’s an alias of, so i ***ume they are used interchangeably without issue?