What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-03-18 03:30:17
search all database tables for a value sqlserver
DECLARE @SearchStr nvarchar(100) SET @SearchStr = '## YOUR STRING HERE ##' -- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved. -- Purpose: To search all columns of all tables for a given search string -- Written by: Naraya... Add solution -
SQL 2022-03-17 01:45:08
SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
I finally found the solutions a days ago and I remembered this post. In the "config/database.php" file in mysql tag, the sql modes should be added in order to skip this error. https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sql-mode-fu... Add solution -
SQL 2022-03-11 18:30:06
SQLSTATE[HY000] [1040] Too many connections
On a shared hosting, "unlimited" means other users are unrestricted with their resource using. Means they can eat up whole pool, while your consumption remains modest This is a limit of database's configuration. If you have permission to edit ... Add solution -
SQL 2022-03-08 19:05:13
mysql vs postgresql
/*Postgres is an object-relational database, while MySQL is a purely relational database. This means that Postgres includes features like table inheritance and function overloading, which can be important to certain applications. Postgres also adheres mo... Add solution -
SQL 2022-02-19 01:00:03
sql comparison operators
(Between) operator same as ">= <=" For example: Select * From Employees Where salary Between 4000 AND 6000; (NOT) operator excluding given For example: Select last_name, job_id From Employees Where "Not" job_id = 'ABC'; (IN)... Add solution
Best helpers
Ranking is empty