How can i add a subquery to.

 
Badlam: How can with a SQL query drop all the triggers?

Aholt: Mathys: SHOW TRIGGERS; and loop through them

Aholt: Mathys: Or select from information_schema.triggers and loop .

Guidetti: Is the AS keyword optional?

Tio: Can’t think of any use case where it is mandatory

Tio: Salle, that was just a disclaimer of sorts

Aholt: Tio: I think it would be stupid to mandate AS word, but you never know

Tio: Salle, yep, but I suppose there is nothing in manual saying “AS is always optional” – only those cases where it is specified per case mostly on man page for select

Aholt: Tio: I’d say it is stupid to say “something is always optional”. It either is optional or not

Aholt: Jkavalik_: Haha! Great point and I just remembered earlier today we had example of that here. CASTfoo AS bar where AS is mandatory :

Fyall: I have an RDS instance with a security group that allows some inbound traffic, but on the RDS page it still says the endpoint has no inbound permissions. Where else should i look? The subnet it’s in also has full ACL access :/

Bascom: Salle, ah, yes I was afraid I missed something like this :

Niedbalski: Guys, since last night was trying to make this query working, can someoen please check if are OK? http://sqlfiddle.com/#!9/5c60b/6 im trying to get all the products with the latest know stock and updated time

Kawaguchi: I need to change replication to row based. however i would like to compare the performance before and after the change. can you guys suggest a way to do that ?

Montijano: SamSagaZ: http://jan.kneschke.de/projects/mysql/groupwise-max/ http://dev.mysql.com/doc/refman/5.6/en/example-maximum-column-group-row.html

Valone: Naktibalda: yes i was reading that docs, was the urls that someone send me lastnight :

Erekson: You have to JOIN productvariations t3 ON t2.productID =t3.productID AND t2.Date = t3.productVariationUpdate to get t3.productVariationStock

Willardson: Mmm im getting stock with my select without JOIN :/

Gerrard: SamSagaZ: Most implementations of sql don’t allow the mixing of grouped and ungrouped columns in the SELECT clause. mysql does, but the row selected for the ungrouped column is an unpredictable value. The groupwise max solution is a way to specify the value selected for the ungrouped column.

Splatt: Damn, mysql not easy anymore. hehe

Valeriano: And sqlfiddle is damn lagged

Hodgson: You are getting stock, but it isn’t a stock of latest date

Ipsen: Added the JOIN and now errors

Workinger: Mmm looks like are not working like i need

Arguilez: Groupwise max on the productVariationUpdate?

Trebesch: Hi, I’m following the instructions here https://help.ubuntu.com/community/Etherpad-liteInstallation to grant all privileges to a table for a user but I keep running into error 1064

Saska: Zaggynl: the Doldo checker bails out at the first thing it cannot understand, either something immediately before is incorrect, or you used a reserved word or its just plain bad Doldo and you are not following the manual

Mckesson: Zaggynl: avoid tutorials

Mcinturff: ProductVariationUpdate are the datetime when i store when the stock are updated

Kihlstrom: How do I proceed without them

Mckesson: Zaggynl: read the official do***entation

Thomes: Zaggynl: are you trying to create database?

Medal: Naktibalda: get it working.

Simila: Have you modified quotes manually?

Yambao: Zaggynl: Use around identifiers database/table/column/alias names and ‘ around strings and dates. MySQL does allow ” for strings, but ANSI standard uses ” for identifiers which you can enable with ANSI QUOTES option.

Bridegroom: I might have changed the to ‘

Eschenburg: Hi, is new mysql client dlls is compatible with old mysql servers?

Trinidad: How can i add a subquery to the query to filter using this SELECT supplierId from suppliers WHERE supplierMainCategoryId = 1;? http://sqlfiddle.com/#!9/e9154/1 im using to separed queryes and loop trough the first one, maybe using all in a single query will be the best