Skip to content
23 May, 2025
You May Like
Why Crypto Needs Community-Driven Development
A Guide To Picking The Purrfect Cat Enclosure
3 Things Your Restaurant Businesses Needs
  • Write For Us
  • Advertise
  • Contact Us
namasteui

DO YOU NEED A CONTENT WRITER FOR YOUR BUSINESS?

Your One-Stop Solution for All Content Needs! Click here for more!
  • Home
  • Editor’s Choice
  • Curriculum Vitae
  • Business
  • Technology
  • Social Media Marketing
  • Apps
  • Creative Blog
  • Multifarious
  • Home
  • database

Tag: database

Reset auto increment values in MySQL

November 1, 2024November 25, 2024 Namaste UI (Author)
MySQL CASE

When you assign one field as a primary key you can use auto-increment attribute to that field. It generates unique identity for the row inserting a unique auto increment value. You can also reset auto […]

Leave a commentMySQLdatabase, mysql

MySQL Transaction

November 1, 2024November 25, 2024 Namaste UI (Author)
MySQL SELECT

Using MySQL you can COMMIT a statement and ROLLBACK to manage transaction. While adding a data into two or more tables where one primary key for one table is the foreign key of another table […]

Leave a commentMySQLdatabase, mysql

MySQL – Find and Replace text in a table

November 1, 2024November 25, 2024 Namaste UI (Author)
MySQL Best Practices

Using ‘replace’ you can find and replace text of a column in a table. Example of Replace text: UPDATE `tbl` SET `field_name` = replace(field_name, ‘old_text’, ‘new_text’); Namaste UI (Author)Namaste UI collaborates closely with clients to […]

Leave a commentMySQLdatabase, mysql

MySQL INSERT statement

November 1, 2024November 25, 2024 Namaste UI (Author)
MySQL Best Practices

To insert data into tables you can use MySQL INSERT statement. Simple syntax of MySQL INSERT: INSERT INTO table(column1,column2..) VALUES (value1,value2,..), (value1,value2,..); You can also insert from another table also i.e. clone: INSERT INTO tbl_1 […]

Leave a commentMySQLdatabase, mysql

MySQL LIKE Operator

November 1, 2024November 25, 2024 Namaste UI (Author)
MySQL Best Practices

Using MySQL LIKE operator you can search based on patterns. It is used in the WHERE clause in SELECT statement. This basically use two characters for using the MySQL LIKE operator: ‘%’ – allows you […]

Leave a commentMySQLdatabase, mysql

MySQL DELETE Statement

November 1, 2024November 25, 2024 Namaste UI (Author)
MySQL CASE

Using MySQL delete state you can delete table data. With a single delete statement you can delete one or more tables data at a time. Example of MySQL DELETE: DELETE FROM users WHERE status = […]

Leave a commentMySQLdatabase, mysql

Mysql Query tips & tricks

November 1, 2024November 25, 2024 Namaste UI (Author)
mysql

Few Mysql queries that will help you develop websites and resolve complex codes. Here are few Mysql Query tips: Finding 2nd highest salary in employee table SELECT MAX(`salary`) from tbl where `salary` < (select MAX(`salary`) […]

Leave a commentMySQLdatabase, mysql

Subquery in MySQL

November 1, 2024November 25, 2024 Namaste UI (Author)
MySQL CASE

Subquery in MySQL means Query inside another query on SELECT, INSERT, UPDATE or DELETE. A subquery must be enclosed with parentheses and can be used anywhere in an expression. The main advantages of subqueries is […]

Leave a commentMySQLdatabase, mysql

Maintaining MySQL Database Tables

November 1, 2024November 25, 2024 Namaste UI (Author)
MySQL SELECT

To maintain MySQL Database tables efficiently you need to analysis, optimize, check and repair database tables frequently. Tips for Maintaining MySQL Database Tables: Analyze table: analyze the table for optimize. ANALYZE TABLE table_name; Optimize table: […]

1 CommentMySQLdatabase, mysql

MySQL Table Locking

November 1, 2024November 25, 2024 Namaste UI (Author)
MySQL CASE

Using MySQL Table Locking you can lock a table explicitly for preventing other sessions for a interval. Releasing a table lock can be granted for a client session only but not for other sessions. Here is […]

Leave a commentMySQLdatabase, mysql

Posts navigation

1 2 … 7 Next
DHGate
Online Homeschool at Northgate Academy.
Adult Online High School from Excel.

Browse by Category

AngularJS Business Ideas Jobs and Careers Classified Ads Corporate Buzz Blogging Ideas CSS Tips CSS3 Tricks E-Commerce Business Finance Tips Google Adsense Health & Fitness Interview Tips JavaScript Tips jQuery Tips Knockout.js Miscellaneous Blogs Mobile Review Money Making Ideas MySQL Tips PHP Tips Programming Tips Search Engine Optimization Social Media Marketing Softwares & Tools Ideas & Technology Travel Ideas Web Design & Development WordPress Tips
Sourav Basak

Sourav BasakFounder, Blogger & Thinker

The Latest

Why Crypto Needs Community-Driven Development

May 23, 2025

A Guide To Picking The Purrfect Cat Enclosure

May 22, 2025

3 Things Your Restaurant Businesses Needs

May 22, 2025

Why Do Healthcare Providers Need Custom Android Apps for Patient Care?

May 22, 2025

Can You Really Fix a Cracked Laptop Screen Yourself?

May 21, 2025

Recent Comments

  • Jeremmy on Well Health Organic Fitness Tips: A Grounded Approach to Strength and Energy
  • Shabita on The Return Of Traditional Marketing
  • Bluebird Solar on Solar Power for Home Use – How Efficient is It?
  • kris25schr on How Digital Transformation Consulting Services Accelerate Business Success
  • Ideahits on How to Use Social Media to Advance Your Career?

ABOUT NAMASTE UI

Welcome to Namaste UI. Established in 2015, this technology blog covering topics on blogging, business, digital marketing, social media, e-commerce, SEO, finance, web design and development, health, lifestyle, travel etc. We offer guest blogging services, link building services and content writing services. Write for us.

#DIGITALMARKETING

» Benefits of SEO: Search Engine Optimization
» Guide to Content Writing for Affiliate Marketing
» Social Media Marketing is vital for Small Business
» Email Marketing and Digital Marketing Strategies
» Link Building – Its Importance In SEO
» Best Social Bookmarking Site
» Submit Your Guest Post on Reblogit.com
» Entrepreneur How – Grow your business

WE HAVE REACHED

5,500+
Articles
750+
Authors
1,600+
Comments
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
  • Feed
  • Feedburner
  • My Business
Copyright © All rights reserved. Namaste UI.
  • About Us
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Write For Us
  • Contact Us
  • Sitemap
Magazine Plus by WEN Themes