Skip to content
  • Home
  • Feature Story
  • Curriculum Vitae
  • Interview Questions
  • Creative Blog
  • Monetize
  • Google Adsense
  • Technology
  • Write For Us
  • HTML
    • Html
    • Html5
  • CSS
    • CSS
    • CSS3
  • JavaScript
    • AngularJS
    • KnockoutJS
    • jQuery
    • Json
  • DATABASE
    • MySQL
  • SUPPORT
04 Mar, 2018
You May Like
10 Out-of-the-box E-commerce Tips To Boost Sales
What Do We Do on Our Computers?
How To Grow Your Blog With Collaborations?
  • HTML
    • Html
    • Html5
  • CSS
    • CSS
    • CSS3
  • JavaScript
    • AngularJS
    • KnockoutJS
    • jQuery
    • Json
  • DATABASE
    • MySQL
  • SUPPORT
Namaste UI
  • Home
  • Feature Story
  • Curriculum Vitae
  • Interview Questions
  • Creative Blog
  • Monetize
  • Google Adsense
  • Technology
  • Write For Us
  • Home
  • mysql

Tag: mysql

INSERT … ON DUPLICATE KEY UPDATE

January 7, 2016January 7, 2016 Namaste UI
MySQL Best Practices

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, […]

Leave a commentMySQLdatabase, mysql

Update from one table to another with condition in MySQL

December 5, 2015 Namaste UI
MySQL CASE

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 […]

Leave a commentMySQLdatabase, mysql

MySQL GROUP_CONCAT() maximum length

October 29, 2015October 29, 2015 Namaste UI
MySQL SELECT

In MySql, GROUP_CONCAT() is used to convert multiple rows into a single string. However, the maximum length of the result of this function is 1024 characters. So, You should first check the character length that […]

Leave a commentMySQLdatabase, mysql

mysql_fetch_array() expects parameter 1 to be resource, boolean given

September 18, 2015October 4, 2015 Jacob Frazier
MySQL Best Practices

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 […]

Leave a commentMySQLdatabase, mysql

SQl MATCH AGAINST find results with only more than 3 characters in the result

August 28, 2015October 4, 2015 Namaste UI
MySQL SELECT

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 […]

Leave a commentMySQLdatabase, mysql

MySQL Best Practices

August 8, 2015August 14, 2016 Namaste UI
MySQL Best Practices

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 […]

Leave a commentMySQLdatabase, mysql

MySQL CASE Statement

July 31, 2015November 8, 2016 Namaste UI
MySQL CASE

MySQL has an alternative of IF statement i.e. MySQL CASE statement by which you can check conditional statement. Besides the IF statement in MySQL, this provides an alternative conditional statement i.e. called CASE. The MySQL […]

Leave a commentMySQLdatabase, mysql

MySQL Query Functions

July 31, 2015October 1, 2015 Namaste UI
MySQL Best Practices

There are so many MySQL functions that commonly used to minimize the statements like string operation functions, date time functions, aggregate functions etc. MySQL LAST_INSERT_ID To get the last generated sequence number of the last […]

Leave a commentMySQLdatabase, mysql

IF statement in MySQL stored procedures

July 30, 2015October 1, 2015 Namaste UI
MySQL CASE

If statement allows you to execute a set of SQL statements based on condition. If certain condition returns true then statement executes, otherwise not. Example: DELIMITER $$ CREATE PROCEDURE MyifCond() BEGIN DECLARE x  INT; SET […]

Leave a commentMySQLdatabase, mysql

Cursor in MySQL stored procedures

July 30, 2015October 1, 2015 Namaste UI
MySQL SELECT

Cursor allows you to iterate a group of rows fetched by a query and process each row. It is read only, non-scrollable and asensitive. Declare a cursor: DECLARE <cursor_title> CURSOR FOR SELECT_statement; Open a cursor: […]

Leave a commentMySQLdatabase, mysql

Posts navigation

1 2 … 7 Next

Feature Stories Continue

Digital Marketing Mistakes

5 Digital Marketing Mistakes and How To Avoid Them

  • 24 Feb 2018
Traffic Ecommerce Website

4 Great Ways to Boost The Traffic to Your Ecommerce Website

  • 30 Jan 2018
successful marketing

The key to successful marketing is enforcing the basic need of technical reliability

  • 12 Dec 2017
Writing curriculum vitae

Tag The Love

Adsense android AngularJS api app audio blog Business css css3 database design facebook Google adsense Google map hello world html html5 image Interview Interview question Javascript jQuery json KnockoutJS magento marketing Monetize Money mysql Online income page rank pdf php plugins regex regular expression seo serialize slideshow social media technology video Web wordpress

Latest insights and analysis

10 Out-of-the-box E-commerce Tips To Boost Sales

What Do We Do on Our Computers?

How To Grow Your Blog With Collaborations?

Top Node.js Frameworks: What to Choose for Backend Development

How clutter in your room is killing your productivity

5 Digital Marketing Mistakes and How To Avoid Them

How 5G and Artificial Intelligence Are Intertwined

3 Easy Ways to Manage Your Documents on iOS

Best Entertainment And Social Apps That Can Set Your Day

How to Use CRM System for Business Management

Highly Recommended

Talk Tee
Next-Gen VPS Hosting
99designs
Your Ad Here
Your Ad Here
Your Ad Here

About Namaste UI

namasteui.com is a web magazine that provides information around creativity, creation, creative people and creative world. It has focus on simplicity, beautification, practicing easy and straight-forward learning.

We use simple code description, and illustrate how to use it.

Browse by Category

AngularJS API Business Careers Classified Ads Creative blog Css Css3 E-commerce Feature Story Google Adsense Hello World Html Html5 Interview questions Javascript jQuery Json KnockoutJS Monetize MySQL Photoshop Php Programming SEO Social Media & Marketing Technology Uncategorized WordPress

Socialize With Us

  • Facebook
  • Twitter
  • LinkedIn
  • Google+
  • Pinterest
  • Quora
  • Tumblr
  • Feed
  • feedburner
Copyright © All rights reserved. Namaste UI.
  • About Us
  • Privacy Policy
  • Terms & conditions
  • Advertise
Magazine Plus by WEN Themes