Suppose you have a serialize string that have various values in different position and you need to search from serialized field. You want particular key’s value using MySQL query. It is very easy with MySQL […]
In MySQL using LOAD DATA INFILE statement you can read data from a text file and import the data into a MySQL table i.e. Import CSV file into MySql. But you need to match the […]
Sql Developer on each platform are battling, apparently stuck in a DO WHILE circle that commits them to rehash the same errors again and again. That is because the database field is still generally juvenile. […]
In the event that you are a business owner, then you will be aware of the immense importance of having both a business website and a business database. Both are vital for your success, while […]
If you mention ON DUPLICATE KEY UPDATE when a row is inserted that is causing a duplicate value in a UNIQUE index or PRIMARY KEY then MySQL performs an UPDATE of the old row. Suppose, […]
In MySQL, you can update fields of one table from another table with a conditional statement also. For example, you have two tables i.e. “user_activity” and “user”. And you need to update a column in […]
Here in this tutorial, you will learn how you can use the MySQL GROUP_CONCAT() function to concatenate strings from a group with various options. There are many cases where you can apply the GROUP_CONCAT() function to […]
Trying to select data from a MySQL table, but getting the error messages: mysql_fetch_array() expects parameter 1 to be resource, boolean given? – This may happen for various reasons like both the mysql_* and the […]
Image sprite is a collection of images put into a single image depends on particular position of a image. Basically CSS sprites are used for faster loading of your site. Read our previous article about […]
In MySQL, while searching column using MATCH AGAINST keywords then the result matches all the row with search character more than 3. If you see the system variable ft_min_word_len, which specifies the minimum length of […]