Skip to main content

My develop blog

Search This Blog

Sql - mysql get count

on September 17, 2020

Get link
Facebook
X
Pinterest
Email
Other Apps

    
    SELECT COUNT(*) AS 'count' FROM `post`;

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Popular Posts

Linux - Centos install 7zip

sudo yum install p7zip p7zip-plugins

Yii2 - migration foreign key

A FOREIGN KEY is a key used to link two tables together. Syntax $this->addForeignKey(name, table, column, referringTable, referringColumn, delete, update); // delete options: RESTRICT, CASCADE, NO ACTION, SET DEFAULT, SET NULL // update options: RESTRICT, CASCADE, NO ACTION, SET DEFAULT, SET NULL

Yii2 - andFilterWhere

filterWhere() - ignores search by empty values. When the search is executed by two fields, for example book and author, if the book value is empty then filterWhere() ignores the search by book and the search will be executed only by author filterWhere() $query->filterWhere([ 'author' => $author, 'book' => null, ]); // generated sql query // SELECT * FROM `library` WHERE (`author` = $author) andFilterWhere - Appends WHERE condition to the existing one. $query->where(['author' => $author]); $query->andFilterWhere(['book' => $book]); // generated sql query // SELECT * FROM `library` WHERE (`author` = $author) AND (`book` = $book)

Powered by Blogger