install php mysql extension ubuntu sudo apt-get install php7.2-mysql Your PHP installation appears to be missing the MySQL extension which is required by WordPress. Your PHP installation appears to be missing the MySQL extension which is required by WordPress. – The requested PHP extension ext-http * is missing from your system. Install or enable PHP’s […]

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements mysql> SET GLOBAL validate_password.policy=LOW; Your password does not satisfy the current policy requirements SHOW VARIABLES LIKE ‘validate_password%’; remove Your password does not satisfy the current policy requirements UNINSTALL COMPONENT ‘file://component_validate_password’;

year sql server function YEAR(input_date)

xml file sql server ALTER PROCEDURE manageImpactItemsList @ImpactXml, @ProductID AS BEGIN DECLARE @Handle INT; EXEC SP_XML_PREPAREDOCUMENT(@Handle OUTPUT, @ImpactXml); INSERT INTO ImpactItemsList_tbl(ProductID, ImpactItem, ImpactID, Answer) SELECT X.ImpactItem, X.ImpactID, X.Answer FROM OPENXML(@Handle, ‘/RT/ITEM’, 2) WITH( ImpactItem VARCHAR(50) ‘ImpactItem’, ImpactID INT ‘ImpactID’, Answer VARCHAR(100) ‘Answer’, ) AS X; EXEC SP_XML_REMOVEDOCUMENT(@Handle); RETURN ‘SUCCESS’; END

xampp mysql shutdown unexpectedly 1. Exit Xampp and navigate to xampp/mysql/data directory 2. delete the ibdata1 file 3. restart the XAMPP server or 1. Exit Xampp and navigate to xampp/mysql/data directory 2. delete the ibdata1, ib_logfile0,ib_logfile1,ib_logfile101 files 3. restart the XAMPP server or Try to check the error log at the installed location: /xampp/mysql/data/mysql_error.log This […]

xamarin sqlite get each row of table public List<albumtable> getalldata() { try { using (var connection = new SQLiteConnection(Path.Combine(dir.AbsolutePath, “album.db”))) { return connection.Table<albumtable>().ToList(); } } catch (SQLiteException ex) { return null; } }</albumtable></albumtable>

xamarin sql lite create table if not exist if (!conn.TableMappings.Any(m => m.MappedType.Name == typeof(TableName).Name)) { conn.CreateTable<tablename>(); }</tablename>

sql crate database CREATE DATABASE databasename; Write the SQL statement to create databas CREATE DATABASE STORE ;

wordpress change http to https phpmyadmin UPDATE wp_options SET option_value = replace(option_value, ‘oldurl.com’, ‘newurl.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’; UPDATE wp_posts SET guid = replace(guid, ‘oldurl.com’,’newurl.com’); UPDATE wp_posts SET post_content = replace(post_content, ‘oldurl.com’, ‘newurl.com’); UPDATE wp_postmeta SET meta_value = replace(meta_value,’oldurl.com’,’newurl.com’);

wordpress address url accidentally changed USE wp_database_name UPDATE wp_options SET option_value=”new_value” WHERE option_name=”siteurl”; UPDATE wp_options SET option_value=”new_value” WHERE option_name=”home”; wordpress address url accidentally changed // wp-content/theme_name/functions.php update_option( ‘siteurl’, ‘new_value’ ); update_option( ‘home’, ‘new_value’ ); // wp-config.php define( ‘WP_HOME’, ‘new_value’ ); define( ‘WP_SITEURL’, ‘new_value’ );