Web Rewrite
Technology Blog Where You Find Programming Tips and Tricks
  Menu
Skip to content
  • Home
  • Java
  • Programming Questions
    • Array
    • Linked List
    • Stack
    • Queue
    • String
    • Search Algo
    • Interview Questions
  • Solid Principles
  • Multithreading
  • PHP
  • Database
    • mysql
    • MongoDB
  • Contact Us

Tag Archives: mysql

« Older posts
Newer posts »

How to Reset an Auto-Increment Value of a Column in MySql

By WebRewrite | November 17, 2016 - 4:15 pm |November 17, 2016 mysql
2 Comments

mysqlHow to reset auto-increment value of a column in MySql.

In MySQL, we can define a column as primary key with an auto-increment index. Every time a new row is inserted it increments the value by 1. By default, an auto-increment column is a primary key of a table.

→

Tagged mysql, Reset auto-increment

How to Convert Timestamp to Date and Time Format in MySql

By WebRewrite | January 26, 2022 - 12:37 am |January 26, 2022 mysql
Leave a comment

How to Convert Timestamp to Date and Time format in MySql. As Timestamp is not a human readable format, Many times we need to convert MySql timestamp to date format.

this tutorial, I am going to discuss how to convert a timestamp to human readable date and time format in MySql.

→

Tagged From_UnixTime, mysql

IF Condition in MySql with Select Statement

By WebRewrite | February 21, 2017 - 3:33 pm |February 21, 2017 mysql
Leave a comment

How to use IF condition in MySql with a select statement. In this tutorial, You are going to learn how to use IF condition in MySql to select column value conditionally.

If Condition in MySql

If Condition in MySql

→

Tagged if condition, mysql
12345
  • Support Me on PayPal

    Programming Video Tutorials


  • Related Posts (YARPP)

    1. How to Remove WWW From URL through htaccess
    2. How to Enable .htaccess File in Apache2
    3. How to Prevent Image Hotlinking through .htaccess
    4. htaccess Tutorial
  • Topics

    • Multithreading

    • Linked List

    • Binary Tree

    • Hash Map

    • Java

    • Queue

    • Stack

    • Binary Search

    • Programming

    • Sliding Window

    • Composer

    • Memcache

    • Javascript

    • Solid Principles

  • Copyright 2020 – 2021 – webrewrite.com – All Rights Reserved.

  • Home
  • Java
  • Programming Questions
  • Solid Principles
  • Multithreading
  • PHP
  • Database
  • Contact Us
Web Rewrite | Powered by Mantra & WordPress.