First, enter MySQL space with this typing followed by your password: mysql -u root -p You will get a prompt. > Let's check where is the Unix Socket file so type: >status -------------- mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.2 Connection id: 2229 Current database: Current user: root@localhost SSL: Not in … [Read more...] about MySql opera operations
Here I used wp_postmeta table and meta_value column in WordPress (MySQL database) This could be used for any other table and column. I checked this for MySQL and similar functions should exist in other databases also. SELECT * FROM `wp_postmeta` where `meta_value` LIKE '%unwanted_text%' The Update looks like this: UPDATE `wp_postmeta` SET `meta_value` = … [Read more...] about Column text replace
Database is used to store information like your customer’s information – first name, last names, email address, address, and etc… Database is very useful on a dynamic website (type of website that needs frequent change of content like news, e-commerce, blog, and etc…), because you can easily retrieve, save, update, and delete data. Database is composed of tables. A Table is … [Read more...] about What is a database?