What are correlated and non correlated subquery

what are correlated and non correlated subquery Noncorrelated Subqueries A noncorrelated subquery executes independently of the outer query. The subquery executes first, and then passes its results to the outer query, For example: => SELECT name, street, city, state FROM addresses WHERE state IN (SELECT state FROM states); Correlated Subqueries A correlated subquery typically obtains […]

What are correlated and non correlated subquery Read More

Weka mysql does not recognize int datatype

weka mysql does not recognize int datatype #See if the following are added, especially the int type TINYINT=3 SMALLINT=4 SHORT=5 INTEGER=5 INT=5 INT_UNSIGNED=6 BIGINT=6 LONG=6 REAL=7 NUMERIC=2 DECIMAL=2 FLOAT=2 DOUBLE=2 CHAR=0 TEXT=0 VARCHAR=0 LONGVARCHAR=9 BINARY=0 VARBINARY=0 LONGVARBINARY=9 BIT=1 BLOB=8 DATE=8 TIME=8 DATETIME=8 TIMESTAMP=8 weka mysql does not recognize int datatype # Specific data types, the […]

Weka mysql does not recognize int datatype Read More

Weekday snowflake in number

weekday snowflake in number YEAR( <date_or_timestamp_expr> ) YEAROFWEEK( <date_or_timestamp_expr> ) YEAROFWEEKISO( <date_or_timestamp_expr> ) DAY( <date_or_timestamp_expr> ) DAYOFMONTH( <date_or_timestamp_expr> ) DAYOFWEEK( <date_or_timestamp_expr> ) DAYOFWEEKISO( <date_or_timestamp_expr> ) DAYOFYEAR( <date_or_timestamp_expr> ) WEEK( <date_or_timestamp_expr> ) WEEKOFYEAR( <date_or_timestamp_expr> ) WEEKISO( <date_or_timestamp_expr> ) MONTH( <date_or_timestamp_expr> ) QUARTER( <date_or_timestamp_expr> ) </date_or_timestamp_expr></date_or_timestamp_expr></date_or_timestamp_expr></date_or_timestamp_expr></date_or_timestamp_expr></date_or_timestamp_expr></date_or_timestamp_expr></date_or_timestamp_expr></date_or_timestamp_expr></date_or_timestamp_expr></date_or_timestamp_expr></date_or_timestamp_expr></date_or_timestamp_expr>

Weekday snowflake in number Read More

W3schools sql foreign key

w3schools sql foreign key Named foreign key: ALTER TABLE Orders ADD CONSTRAINT FK_PersonOrder FOREIGN KEY (PersonID) REFERENCES Persons(PersonID); alter table foriegn key sql ALTER TABLE Orders ADD FOREIGN KEY (PersonID) REFERENCES Persons(PersonID); sql foreign key # A foreign key is essentially a reference to a primary # key in another table. # A Simple table […]

W3schools sql foreign key Read More

Views in sql

create view CREATE VIEW view_name AS SELECT id,category,MAX(created_at),content,title FROM table WHERE condition GROUP BY category views in sql CREATE VIEW view_name AS SELECT column1, column2, … FROM table_name WHERE condition; what is a view in sql In SQL, a view is a virtual table based on the result-set of an SQL statement. A view contains […]

Views in sql Read More