Quickly Execute SQL Online | Run SQL Files from your browser

Pubblicato il: 19 aprile 2022
sul canale di: WayScript
3,077
16

Execute SQL in a browser!

All the description stuff:
Platform - app.wayscript.com

Code from video -
https://gist.github.com/Derrick-Sherr...

import os
import mysql.connector

mydb = mysql.connector.connect(
host='',
user='',
password='',
port=3306,
database=''
)

sql = "SELECT * FROM customers;"
mycursor = mydb.cursor()
mycursor.execute(sql)
if 'INSERT' in sql:
mydb.commit() # required to make table changes
print("Last inserted ID:", mycursor.lastrowid)
if 'SELECT' in sql:
myresult = mycursor.fetchall()
for x in myresult:
print(x)

Mysql-connect:
https://dev.mysql.com/doc/connector-p...

Secrets in WayScript -
https://wsxdocs.wayscript.com/buildin...



Using WayScript, devs rapidly build production-grade microservices and tools with unprecedented speed and security. Get started for free today: http://wayscript.com

---------------------------
➤ TIMESTAMPS

➤ Questions, comments, or anything else? Join our Discord or drop us a line directly at founders@wayscript.com. We’re always around to help:   / discord  

➤ Follow WayScript on Social Media:
GitHub - https://github.com/wayscript
Twitter -   / wayscripthq  
LinkedIn -   / ways.  .
Instagram -   / wayscript  
Facebook -   / wayscript  

Start shipping internal tools that make a difference today. Visit us at wayscript.com.


In questa pagina del sito puoi guardare il video online Quickly Execute SQL Online | Run SQL Files from your browser della durata di ore minuti seconda in buona qualità , che l'utente ha caricato WayScript 19 aprile 2022, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 3,077 volte e gli è piaciuto 16 spettatori. Buona visione!