Skip to content
28 Feb, 2021
You May Like
All About Brahmatal Trek
15 Best ways to learn Hadoop Technology
The Masai and Their Science-Defying Health
  • Write For Us
  • Advertise
  • Contact Us
namasteui

Reblog it

  • Home
  • Editor’s Choice
  • Curriculum Vitae
  • Business
  • Technology
  • Social Media Marketing
  • Apps
  • Creative Blog
  • Multifarious
  • Home
  • MySQL

Category: MySQL

MySQL in Namaste UI focused on mysql dbms, mysql tools, mysql database, mysql software, mysrl app, mysql server, learn mysql online, sql tutorial and mysql tutorial.

5 essential performance tips for MySQL

May 4, 2019April 30, 2020 Code Wilson
sql performance

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

Leave a commentMySQLdatabase, mysql

MariaDB Vs MySQL- Comparison, Features, Differences and Similarities

June 15, 2018June 15, 2018 Jade Gardner
MariaDB Vs MySQL

“Competitors push you to achieve more!”, the phrase could not me more appropriate in relation to our present day world. Competitions is the best teacher, motivating one to move forward, to learn and to overcome. […]

Leave a commentMySQLmysql, technology

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, 2015May 14, 2020 Namaste UI (Author)
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 […]

1 CommentMySQLdatabase, mysql

Posts navigation

1 2 … 7 Next

Browse by Category

AngularJS API Business Careers Classified Ads Corporate Creative blog Css Css3 E-commerce Feature Story Finance Google Adsense Health Hello World Html Html5 Interview questions Javascript jQuery Json KnockoutJS Miscellaneous Mobile Monetize MySQL Photoshop Php Programming SEO Social Media & Marketing Softwares Technology Travel Web Design & Development WordPress
Sourav Basak

Sourav BasakFounder, Blogger & Thinker

CopyCrafter

Go to CopyCrafter to buy an assignment from a professional.

The Latest

All About Brahmatal Trek

February 27, 2021

15 Best ways to learn Hadoop Technology

February 26, 2021

The Masai and Their Science-Defying Health

February 26, 2021

6 Best Tips To Get Hired In Amazon

February 25, 2021

Spinal Stenosis: Exercises to Avoid

February 25, 2021

Popular Searches

Guest posting sites, Submit guest post, Writing blogs, Free blog sites, Blog websites, Blog submission sites, Free directory submission sites, Guest blogging sites, Buy guest blog posts, Looking for guest bloggers, Online jobs, Best ways to get backlinks, Best guest posting service, Startup, Popular blogging websites, How to create a blog, Content marketing, Blog writing service, Link building, How to earn money from blogging, Online data entry jobs, Make money online, Small business ideas, Home based business, Online business ideas, Keyword research, Start blogging for money, Earn money with blog, How to start a blog, How social media works, How to become a blogger

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.
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
  • Feed
  • feedburner

Don’t Miss These Latest Articles

» How to Create Quality Content for Your Website
» Why December is the best time to visit Mussoorie
» 4 Apps To Help Your Kids Perform Better In School
» How to Market Your Business on Instagram: A Complete Guide
» How Long Does It Take to Start a Business? A Basic Guide

Namaste UI

2,620+
Articles
610+
Authors
1000+
Comments
Copyright © All rights reserved. Namaste UI.
  • About Us
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Write For Us
  • Contact Us
Magazine Plus by WEN Themes