What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-01-26 10:21:13
which is better to read mongodb and mysql for c++ programmer
''' MySQL is a relational database management system (RDBMS) from the Oracle Corporation. Like other relational systems, MySQL stores data in tables and uses structured query language (SQL) for database access. When MySQL developers need to access data... Add solution -
SQL 2022-01-22 19:25:22
learnxinyminutes sql
-- Comments start with two hyphens. End each command with a semicolon. -- SQL is not case-sensitive about keywords. The sample commands here -- follow the convention of spelling them in upper-case because it makes -- it easier to distinguish them from da... Add solution -
SQL 2021-11-22 02:58:12
Update All tables COLLATE DATABASE_DEFAULT
DECLARE @collate nvarchar(100); DECLARE @table nvarchar(255); DECLARE @column_name nvarchar(255); DECLARE @column_id int; DECLARE @data_type nvarchar(255); DECLARE @max_length int; DECLARE @row_id int; DECLARE @sql nvarchar(max); DECLARE @sql_column nvarc... Add solution -
Other 2021-11-18 22:36:14
PDO::FETCH_OBJ
It should be mentioned that this method can set even non-public properties. It may sound strange but it can actually be very useful when creating an object based on mysql result. Consider a User class: <?php class User { // Private prope... Add solution -
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 -
TypeScript 2021-11-14 07:58:16
AND-OR-AND + brackets with Eloquent
//mysql query be like this // ... WHERE (gender = 'Male' and age >= 18) or (gender = 'Female' and age >= 65) //Eloquent query is // ... $q->where(function ($query) { $query->where('gender', 'Male') ->where('age', '>=', 18);... Add solution
Best helpers
Ranking is empty