What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-14 10:43:17
Mysql table variables
CREATE PROCEDURE my_proc () BEGIN CREATE TEMPORARY TABLE TempTable (myid int, myfield varchar(100)); INSERT INTO TempTable SELECT tblid, tblfield FROM Table1; ... -- Temporary tables in MySQL only exist for the duration of the connection -- and only ... Add solution -
SQL 2021-10-13 18:20:09
insert into mysql c++
#include <mysql.h> #include <iostream> #include <iomanip> #include <fstream> using namespace std; MYSQL *conn, mysql; MYSQL_RES *res; MYSQL_ROW row; int query_state; int main() { const char *server="students"; c... Add solution -
SQL 2021-09-29 08:56:05
get individual date elements in mysql
-- To get the year of a date in mysql SELECT YEAR(NOW()); -- To get the month of a date in mysql SELECT MONTH(NOW()); -- To get the day of a date in mysql SELECT DAY(NOW()); -- To get the hour of a date in mysql SELECT HOUR(NOW()); -- To get the minut... Add solution