Skip to content
The Webs Development
We build the identity
  • Home

Category: Mysql

Import .sql file in mysql database using php

June 6, 2017 wbrnd

<?php //ENTER THE RELEVANT INFO BELOW $mysqlDatabaseName =’test’; $mysqlUserName =’root’; $mysqlPassword =”; $mysqlHostName =’localhost’; $mysqlImportFilename =’dbbackupmember.sql’; //DONT EDIT BELOW THIS…

Continue Reading →

Posted in: Command Line, Mysql, PHP

Export | Import DB Using CMD

May 15, 2017 wbrnd

If you want to export DB tables from any server by using CMD: Step 1. go to mysql path: for…

Continue Reading →

Posted in: Command Line, Mysql

MySQL Update Query using a join

May 8, 2014 wbrnd

If you want to update any records with join of two tables than please write below code:Update wp_posts as pLEFT…

Continue Reading →

Posted in: Mysql Filed under: update with join

mysql count like and dislike average from one column

July 12, 2013 wbrnd

likes_id video_id Descending user_id like_status like_ip datetime13 290 2 y 2013-07-01 17:15:2925 290 3 y 2013-07-01 17:26:1242 290 9 y…

Continue Reading →

Posted in: Mysql

MySQL search and replace in whole database

March 21, 2012 wbrnd

<?php function generate_queries($database, $user, $password, $host, $search, $replace) {     $conn = mysql_connect($host, $user, $password);    if (!$conn) {        die(‘Unable to…

Continue Reading →

Posted in: Mysql, PHP

Post navigation

Page 1 of 2
1 2 Next →

Categories

.htaccessACFCommand LineConstant Contactcontact form 7CronCron Jobcustom post typedateGravity FormIEjavascriptjQueryjQuery CycleKohanaLaravelMagentoMSSQLMysqlPhone GapPHPphpmyadminPythonRewriteRSSVimeoWampserverWoocommerceWordpresswordpress pluginXMLXSS scriptsYoutubezencart
Copyright © 2021 The Webs Development