Skip to main content

My develop blog

Search This Blog

Sql - mysql get count

on September 17, 2020

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

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

Get link
Facebook
Twitter
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 - render view without layout

You have to use "renderPartial" to exclude layout from view. But "renderPartial" prevents loading asset files like css and js. Take a look at the example below. public function actionIndex() { $this->renderPartial('view', ['model' => $yourModel]); }

Powered by Blogger