Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
mysql - having
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
DROP TABLE IF EXISTS tutorials_tbl; create table tutorials_tbl( tutorial_id INT NOT NULL AUTO_INCREMENT, tutorial_title VARCHAR(100) NOT NULL, tutorial_author VARCHAR(40) NOT NULL, submission_date DATE, datetime DATETIME, timestamp TIMESTAMP, year YEAR, PRIMARY KEY ( tutorial_id ) ); INSERT INTO tutorials_tbl (tutorial_title, tutorial_author, submission_date,datetime,year) VALUES ("Learn PHP", "John Poul", NOW(),NOW(),NOW()); INSERT INTO tutorials_tbl (tutorial_title, tutorial_author, submission_date,datetime,year) VALUES ('2'|1|'7', "John Poul", '1973-12-30''','1973-12-30''',1901-1||1901-0); SELECT COUNT(tutorial_id), tutorial_author FROM tutorials_tbl GROUP BY tutorial_author HAVING COUNT(tutorial_id) =2 and 1=1;
absolute service time: 0,36 sec
edit mode
|
history
|
discussion
tutorial_id
tutorial_title
tutorial_author
submission_date
datetime
timestamp
year
1
1
Learn PHP
John Poul
07.12.2018 00:00:00
07.12.2018 16:05:09
07.12.2018 16:05:09
2018
2
2
7
John Poul"
30.12.1973 00:00:00
30.12.1973 00:00:00
07.12.2018 16:05:09
2001