Namaste UI
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 CSV data with the columns of a table and the type of the each column of the table. Suppose we […]
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. Indeed, sellers are making a few steps, but they keep on thinking about the more significant issues. Simultaneousness, an asset […]
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 the business website will be the main focal point of your online business venture and the face of your business, […]
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 a table there are three columns i.e. a, b, c. If column ‘a’ is declared as UNIQUE and contains […]
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 one table to the value of another column where an user_id matches in both tables. So, in a single query […]
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 produce useful results. In MySql, GROUP_CONCAT() is used to convert multiple rows into a single string. However, the maximum length […]
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 mysqli extension will return false from their query functions. – Using a die() you can get a little to much. […]
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 CSS Image Sprites. There are few online CSS Sprite generator tool which is very handy to create sprites quickly. 1) […]
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 words to be indexed by full-text searching, it defaults to 4, so 3-letter words won’t be found by full-text searching. […]
Sometimes we may face about performance issues while opening a website. Not only databases but we need to optimize our programming code also. MySQL Best Practices means few tips to optimize the MySQL query: Avoid SELECT * and use particular fields from a table what you require. Use ENUM rather than VARCHAR because ENUM type […]