I like the idea and the look of the whole thing but I couldn't figure out how to easily
SELECT * from customers
so... I'm kind of bummed out. The blocks seemed to not stick together. They'd just "island" and sit by themselves. I finally managed to push them together for a "SELECT FROM customers" combination of blocks. But there was a "clause" thing stuck on the screen.
I felt like this should be a really quick thing to do.
The * is hiding under "Tables & Attributes"; choose the yellow box with * in it, then snap it to the end of the SELECT block, then snap the SELECT block on top of a FROM block which has a yellow "customers" block snapped into it. Voila, the "Show SQLCode" button now emits "select * from customers" (FF Beta, macOS)
I got there too after some puzzling. There's not even a distinction between attributes and table names to guide you. I got there by thinking "what would the correct syntax be". Kind of ironic.
Comments
I like the idea and the look of the whole thing but I couldn't figure out how to easily
SELECT * from customers
so... I'm kind of bummed out. The blocks seemed to not stick together. They'd just "island" and sit by themselves. I finally managed to push them together for a "SELECT FROM customers" combination of blocks. But there was a "clause" thing stuck on the screen.
I felt like this should be a really quick thing to do.
After all that I then got:
Ungültige Abfrage: Unknown table 'web1312.customers'
so the table I selected didn't even exist. Possibly.
Sadness.
(Maybe its a firefox thing? Can I blame firefox?)
The * is hiding under "Tables & Attributes"; choose the yellow box with * in it, then snap it to the end of the SELECT block, then snap the SELECT block on top of a FROM block which has a yellow "customers" block snapped into it. Voila, the "Show SQLCode" button now emits "select * from customers" (FF Beta, macOS)
I got there too after some puzzling. There's not even a distinction between attributes and table names to guide you. I got there by thinking "what would the correct syntax be". Kind of ironic.