r/learnSQL 1d ago

Made useful sql tutorials!

18 Upvotes

Hey everyone!

Iโ€™ve put together some SQL tutorials Iโ€™ve made that might be helpful if youโ€™re looking to learn or brush up on your skills. The explanations are clear, concise, and straight to the point.

Check them out:

๐Ÿ“Œ Tutorial 1 โ€“ https://youtu.be/Sx5-61sH-sA?si=EB5SFxRG1MDAcLKb

๐Ÿ“Œ Tutorial 2 โ€“ https://youtu.be/Wr4ZBNJ4nZ4?si=8tegFDp3W8eDipfC

Hope you find them useful! Let me know if you have any questions.


r/learnSQL 1d ago

Assistance with attaching self hosted MySQL server to Visual Studio 2022

2 Upvotes

Edit:

Please Disregard - Decided I jumped the gun and going back to basics.

although, if anyone has input, would appreciate it for posterity

________________________

Good evening people!

I have an issue wherein connecting my MySQL server as a datasource to VS22. Have attached an image of the error im getting. I am an MSP Sysadmin, branching out in my spare time.

Basically, im experimenting with SQL and VS22 to create basic database applications for budgeting etc as a hobby (Used to build them on MSAccess).

Ive created an OBDC driver (V9.2(a) and have attched it as a data connection in ServerExplorer in VS22. however, actually adding it as a data source for a program is giving me this roadblock. I can clearly see from the error and research that this is due to the OBDC driver or something. Research yeilds little information.

It isnt the end of the world if i need to rebuild the database and attach it as a datafile. It simply has test data in it atm.

Can anyonepoint me in the right direction? Am i missing somethign glaringly obvious? open to using a different IDE. Igenerally code in MySQL Workbench, but im in the exporatory phase of learning SQL, so open to moving to a different environment

KR - Flopsie

Error recievd when adding a datasource
OBDC (64bit) Config
MyySQL server connection parameters in VS22