if you have worked in magento 2 then you might know that magento 2 had updated its table structure.If you are not aware of it then check below diagram for better understanding: Click On above Picture to enlarge Hope… Continue Reading
This Is a Quick Tutorial to Remove Unique or Primary Key From MySql Table.Sometime we add unique key on table column to prevent duplicate entries but a point you need some duplicate data in your column and that time you… Continue Reading
In this post i will explain an extremely basic MySql Problem of Replacing a Text in mysql Table.Suppose You have a table name posts with title and description. There are some normal content or links you have included in your all… Continue Reading
Suppose you are working on a project and your code or application is hosted on a server and your mysql database is hosted on another server but you need to get your mysql database from code server remotely then this… Continue Reading
Here I am not going to indicate most regular query like INSERT, UPDATE, DELETE and so on. I’ll demonstrate to you some other one stage up query which I feel we required these amid advancement, Generally we make basic function… Continue Reading
Hi readers ! in this tutorials i will tell you basic methods to access PhpMyAdmin without CPanel Login.Yesterday i required this method in my hostin actually i am using godaddy shared hosting and each time when you need to access… Continue Reading
sometime you want to copy data from one database to another database that are on same server.The columns and tables got diverse name and wanna insert column data from one database to another using mysql query.if you want same thing… Continue Reading
The MySQL database is one of the surely understand database motor, which utilizes a customer server engineering. The server, mysql is the program that really control the database. Keeping in mind the end goal to converse with server, we utilize… Continue Reading
MySQL has bolstered database sees since rendition 5.x. Perspectives are quite helpful in the event that you need to allude to values computed from expressions without composing the expressions each time you can recover them. What is a view A… Continue Reading
How to use REPLACE in mysql query with example suppose you have a list of Spa Centers in your mysql table.and you want to search in your tables to get similier results that user searched for.if you are looking for… Continue Reading
How to Backup your MySQL Database There are a few approaches to reinforcement MySQL information. In this article we’ll take a gander at how to reinforcement your databases utilizing diverse strategies, we will likewise figure out how to accomplish a… Continue Reading
how to use if else condition in mysql The MySQL IF statement permits you to execute an arrangement of SQL explanations in view of a specific condition or estimation of an expression. To shape an expression in MySQL, you can… Continue Reading
If You have a field arr_val (varchar(50)) in a your table tst_tbl that contains a comma delimited string such as PHP,MySql,Ajax,JQuery,PHP 5.
When running the query select * from arr_val where arr_val like ‘%PHP%’ to get all the only PHP Results ( not PHP 5) , But you will also get the result PHP 5.
Now the Question is “How should we rewrite the query so that is selects ONLY the PHP and not all values containing PHP ? Continue Reading
Suppose You Have a Table promo_code in Your Database Like This: add comma separated values in mysql ,comma separated values in mysql ,comma separated values in mysql data type ,comma separated values in mysql field ,comma separated values in mysql… Continue Reading