What do you want to save?
Add Code snippet
New code examples
-
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 -
Shell/Bash 2022-03-17 08:30:02
install magento 2.4.2
composer create-project --repository-url=https://repo.magento.com/ magento/project-community-edition ./ php bin/magento setup:install \ --admin-firstname=John \ --admin-lastname=Doe \ [email protected] \ --admin-user=admin \ --admin-pa... Add solution -
PHP 2022-03-17 04:55:13
retrieve data from database in php
$sql = "SELECT id, firstname, lastname FROM MyGuests"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo "id: " . $row["i... Add solution -
Shell/Bash 2022-03-17 04:35:08
microstack connect to mysql server
# First you need to have the mysql client: sudo apt install mysql-client-core-8.0 # Then you need to get your microstack mysql password, # so type the below to see it: sudo snap get microstack config.credentials.mysql-root-password # Remember the above p... Add solution -
Java 2022-03-17 03:45:03
jsp search query
<%@page import="java.sql.DriverManager"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.Connection"%> <% String id = request.ge... Add solution
Best helpers
Ranking is empty