• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

mysql

MySQL Auto Increment and reset

May 1, 2022 by techgoeasy Leave a Comment

Auto Increment Column is a quite common requirement in the coding. Here are some of the ways to get that in MySQL . we will also check about MySQL Auto Increment reset Auto Increment Column MySQL database The AUTO_INCREMENT attribute can be used to generate a unique identity for new rows Example use techdb; CREATE […]

Filed Under: mysql, Web development

MySQL COALESCE and NULLIF Function

May 1, 2022 by techgoeasy Leave a Comment

We will be discussing MySQL COALESCE and NULLIF Function in this post. We will also be showing  MySQL COALESCE  examples and NULLIF MySQL Function example MySQL COALESCE Function COALESCE  in MySQL is a very useful function to select first not null values from the list of values Syntax COALESCE(val1, val2,val3,…valn) The above syntax is equivalent […]

Filed Under: mysql Tagged With: MySQL COALESCE, NULLIF Function

MySQL queries examples with answers

April 30, 2022 by techgoeasy Leave a Comment

Useful and common MySQL queries examples with answers for the developer and DBA’s  How to create a MySQL database mysql> create database techdb;mysql> use techdb; How to create table in mysql database? Here is the example for table creation in the MySQL database(1) We need to first get into the database use techdb; (2) Create […]

Filed Under: mysql

How to reset MySQL root password on your Linux server

December 19, 2021 by techgoeasy Leave a Comment

We may sometimes need to reset the MySQL root password on your Linux server. Here are the steps to do that We need the root user privilege to do this Step1 Login as root user and Stop the MySQL server /etc/init.d/mysql stoporservice mysql stop Step 2 Start MySQL in safe mode and skip the use […]

Filed Under: mysql, Web development

Top 51 Frequently Asked MySQL Interview Questions And Answers

August 6, 2017 by techgoeasy Leave a Comment

Here is the compilation of Top 51 Frequently Asked MySQL Interview Questions And Answers,I hope you will like that and it will be useful in the interviews 1) What is the difference between sql and Mysql? Answer SQL or Structured Query Language is a programming language designed for managing data held in a Relational Database Management […]

Filed Under: General, Interviews questions, mysql, Web development Tagged With: Mysql Interview Questions

Step by step guide to build local Apache PHP MySQL development environment on windows

September 19, 2016 by techgoeasy Leave a Comment

A php developer would offcourse like to test the php file before deploying on the webserver.A local Apache PHP MySQL development environment on windows allows you to test your code as you develop your web application before publishing it to the web. This article will guide you through setting up a local Apache PHP MySQL development environment […]

Filed Under: mysql, PHP, Web development Tagged With: Step by step guide to build local Apache PHP MySQL development environment on windows

  • Page 1
  • Page 2
  • Next Page »

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to check Stale statistics
  • Java web start(JWS) in R12
  • How to delete the archive logs in Oracle
  • How to generate sql monitor report in Oracle
  • How to find the long running (longops session) in Oracle

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us