What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-08-31 06:04:01
uninstall mysql 8 ubuntu 20.04
$ sudo apt-get remove --purge mysql-server mysql-client mysql-common -y $ sudo apt-get autoremove -y $ sudo apt-get autoclean $ sudo rm -rf /etc/mysql # Delete all MySQL files on your server: $ sudo find / -iname 'mysql*' -exec rm -rf {} \; Add solution -
SQL 2021-08-31 05:34:02
sql update multiple columns from another table
-- Oracle UPDATE table2 t2 SET (VALUE1, VALUE2) = (SELECT COL1 AS VALUE1, COL1 AS VALUE2 FROM table1 t1 WHERE t1.ID = t2.ID); -- SQL Server UPDATE table2 t2 SET t2.VALUE1 = t1.COL1, t2.VALUE2 = t1.COL2 FROM table1 t1 INNER JOIN t2 ON t1.ID = ... Add solution -
Shell/Bash 2021-08-30 20:53:01
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
>>> sudo mysql -u root -p >>> USE mysql; >>> UPDATE user SET plugin='mysql_native_password' WHERE User ='root'; >>> FLUSH PRIVILEGES; >>> exit; >>> service mysql restart; Add solution -
PHP 2021-08-30 10:24:01
get id of record created php
<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "myDB"; // Create connection $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if ... Add solution -
Shell/Bash 2021-08-30 02:18:02
how to delete docker images older than x days from docker hub using a shell script serverfault
#!/bin/bash #Script will delete all images in all repositories of your docker hub account which are older than 'X' days set -e # set your username, password and no. of 'X' days value in below lines. #UNAME="YOUR_USERNAME" #UPASS="YOUR_PASS... Add solution -