zlacker

[return to "Pipe Syntax in SQL"]
1. ku1ik+R5[view] [source] 2024-08-24 16:14:37
>>legran+(OP)
I would welcome this! I’ve been using SQL for over 20 years and I still sometimes have trouble expressing certain queries, which in my head are well understood. I typically get there but I wish the amount of trial and error was shorter, and the process of turning what I have in my head inside out disappeared.
◧◩
2. atum47+26[view] [source] 2024-08-24 16:16:34
>>ku1ik+R5
Same here. I often connect to mariadb via console and try my queries there. I confess that I've used gpt to help me with some hairy ones and it worked quite good.
◧◩◪
3. vinnym+I7[view] [source] 2024-08-24 16:29:57
>>atum47+26
It's difficult for me to tell how sincere your confession was, I am guessing you meant it in jest.

But it is worth stating nonetheless. No one confesses when they search StackOverflow for something they've solved 100 times before, or when they ask Google a question a dozen times a day. Asking ChatGPT for some insight should equally not be considered sinful :)

◧◩◪◨
4. atum47+Jj2[view] [source] 2024-08-25 15:02:02
>>vinnym+I7
There are variations between mysql and mariadb, I've used mysql for a long time now, when I switched to mariadb I found those differences. I find writing complex queries on the console first and then committing it to the code a good strategy. I can see the results right away and some error that I might have done.
[go to top]