All gists matching topic database

0 喜歡

0 分支

1 檔案

automation data-management data-storage database python rss sqlite

1	import sqlite3
2
3
4	# 初始化資料庫及表格
5	def initialize_db(db_name="database.db", table_name="entries"):
6	conn = sqlite3.connect(db_name)
7	cursor = conn.cursor()
8	cursor.execute(
9	f"""
10	CREATE TABLE IF NOT EXISTS {table_name} (

0 喜歡

0 分支

1 檔案

crud data-editor database join pandas python sql sqlite streamlit

1	import sqlite3
2	import pandas as pd
3	import streamlit as st
4	from datetime import datetime, date
5
6	def initialize_database(conn):
7	cursor = conn.cursor()
8
9	# 建立 Customers 資料表
10	cursor.execute('''

0 喜歡

0 分支

1 檔案

database mysql remote-access root security sql user-management

1	CREATE USER 'root'@'%' IDENTIFIED BY 'my_root_pwd';
2	GRANT ALL PRIVILEGES ON . TO 'root'@'%';
3	FLUSH PRIVILEGES; -- 重新整理權限表
4
5	ALTER USER 'root'@'%' IDENTIFIED BY 'my_root_pwd';
6	FLUSH PRIVILEGES; -- 重新整理權限表