AnalyzeCode

Page Index

DBMS Introduction

MySQL Database

MySQL Tables

MySQL Queries

MySQL Clauses

MySQL Conditions

MySQL Keys

MySQL AND Conditions

The MySQL AND condition is used with SELECT, INSERT, UPDATE or DELETE statements to test two or more conditions in an individual query.

Syntax:

    WHERE condition1  
    AND condition2  
    ...  
    AND condition_n;

Parameter explanation:

condition1, condition2, ... condition_n: Specifies all conditions that must be fulfilled for the records to be selected.

Let's move on to use of OR in MySQL

Previous

MySQL HAVING

Next :

MySQL OR

Share this page on :

© 2022 AnalyzeCode.com All rights reserved.