This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
/** | |
* Export MySQL users and permissions | |
* | |
* This script exports raw CREATE USER and GRANT queries of a given database | |
* to help migrate MySQL users and permissions to a new server. | |
* Users will keep their passwords across the migration. | |
* | |
* Warning: The import queries expects exactly the same database structure! | |
* |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var mysql = require('mysql') | |
var connection = mysql.createConnection({ | |
host : 'localhost', | |
user : 'root', | |
password : 'Passphrase', | |
database : 'mydatabase' | |
}); | |
connection.connect() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- use wp_sample; | |
-- select * from wp_posts group by post_date order by post_name; | |
DELIMITER $$ | |
DROP PROCEDURE IF EXISTS wp_sample.vx_multiple_select $$ | |
CREATE PROCEDURE wp_sample.vx_multiple_select() | |
BEGIN | |
DECLARE l INT DEFAULT 0; | |
declare tmp INT default 0; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!DOCTYPE html> | |
<html> | |
<body> | |
<video width="444" controls> | |
<source src="https://www.w3schools.com/html/mov_bbb.mp4" type="video/mp4"> | |
<source src="https://www.w3schools.com/html/mov_bbb.ogg" type="video/ogg"> | |
Your browser does not support HTML5 video. | |
</video> |