What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-03-02 15:30:16
check mysql status on commandline
$ systemctl status mysql ● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: loaded (/etc/init.d/mysql; generated) Active: active (running) since Tue 2021-05-18 13:34:02 CEST; 12s ago Docs: man:systemd-sysv-gene... Add solution -
SQL 2022-03-01 11:15:16
open transactions sqlskills
SELECT [s_tst].[session_id], [s_es].[login_name] AS [Login Name], DB_NAME (s_tdt.database_id) AS [Database], [s_tdt].[database_transaction_begin_time] AS [Begi... Add solution -
SQL 2022-02-28 13:50:18
deadlock table in mysql
1 141013 6:06:22 2 *** (1) TRANSACTION: 3 TRANSACTION 876726B90, ACTIVE 7 sec setting auto-inc lock 4 mysql tables in use 1, locked 1 5 LOCK WAIT 9 lock struct(s), heap size 1248, 4 row lock(s), undo log entries 4 6 MySQL thread id 155118366, OS thread ha... Add solution -
Python 2022-02-28 13:00:02
read a csv file in pandas
import panda as pd file_csv = pd.read_csv("file path") ## as csv format file_excel = pd.read_excel("file path") ## as excel format file_json = pd.read_json("file path") ## as json format file_html = pd.read_html("file... Add solution -
SQL 2022-02-28 11:30:02
access the postgres psql
psql -h localhost -U username databasename Add solution -
Other 2022-02-27 23:55:01
group by mongo
#It's the equivalent of the following SQL instruction: # SELECT COUNT(*) FROM Table # GROUP BY your_field # HAVING COUNT(*) > N query = db.collection.aggregate([ { "$group": { "_id": "$your_field", #GROUP BY yo... Add solution
Best helpers
Ranking is empty