What do you want to save?
Add Code snippet
New code examples
-
Python 2022-03-20 02:15:44
python create table postgresql
.wp-block-code { border: 0; padding: 0; } .wp-block-code > div { overflow: auto; } .shcb-language { border: 0; clip: rect(1px, 1px, 1px, 1px); -webkit-clip-path: inset(50%); clip-path: inset(50%); height: 1px; margin: -1px; overflow: hidden... Add solution -
Other 2022-03-20 00:10:03
función para generar slug directamente en MySQL
DROP FUNCTION IF EXISTS `slugify`; DELIMITER ;; CREATE FUNCTION slugify(str VARCHAR(255)) RETURNS VARCHAR(255) LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY INVOKER BEGIN DECLARE slug, allowed_chars VARCHAR(255); DECLARE current_char V... Add solution -
SQL 2022-03-19 07:00:17
sp in sql server
Stored procedure A sp is group of T-SQL statement. If you have any kind of situation, where you are writing the same query over and over again, you can save that specific query as a stored procedure and then just call by it's name. Basically wrapped thi... Add solution -
Other 2022-03-18 13:35:02
add mysql to path
For windows users only! I had a lot of trouble for this one, but I found the solution. Visit this page: https://overiq.com/installing-mysql-windows-linux-and-mac/ And then follow the steps, but instead of putting this (in step 5): C:\Program Files\MySQL\... Add solution -
SQL 2022-03-18 05:45:27
oracle sql trigger after insert
-- SQL Server (update my_table2 after insert on my_table1) CREATE TRIGGER trigger_name ON my_table1 FOR INSERT AS BEGIN UPDATE my_table2 SET my_col_date = getdate() FROM my_table1 END -- Oracle (insert into log table after update on my_table) CREATE ... Add solution -
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 15:40:29
mysql limit rows
-- MySql SELECT * FROM emp ORDER BY sal DESC LIMIT 5; -- SQL Server SELECT TOP 5 * FROM emp ORDER BY sal DESC; -- Oracle < 11g SELECT * FROM ( SELECT * FROM emp ORDER BY sal DESC ) WHERE ROWNUM <= 5; -- Oracle 12c + SELECT * FROM emp ORDER BY sa... Add solution -
Other 2022-03-12 01:55:09
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in field list is ambiguous
SQL supports qualifying a column by prefixing the reference with either the full table name: SELECT tbl_names.id, tbl_section.id, name, section FROM tbl_names JOIN tbl_section ON tbl_section.id = tbl_names.id ...or a table alias: SELECT n.id, s... Add solution
Best helpers
Ranking is empty