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. FIND_IN_SET() Function in MySql
    2. How to Install MySql Workbench on Ubuntu
    3. How to Select NULL Values in MySql
    4. Find Second Highest Salary in MySql
  • 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.