What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-09-01 05:39:03
how to change server name in sql server
-- If you find any mismatch, then you need to follow below steps: -- 1. Execute below to drop the current server name EXEC sp_DROPSERVER 'oldservername' -- 2. Execute below to add a new server name. Make sure local is specified. EXEC sp_ADDSERVE... Add solution -
-
PHP 2021-08-31 13:16:01
display image from mysqli database
// database connection $conn = mysqli_connect("localhost", "root", "", "student"); // Fetch image from database $img = mysqli_query($conn, "SELECT * FROM student_table"); while ($row = mysqli_fetch... Add solution -
PHP 2021-08-31 12:56:02
pdo search query
$search_keyword = ''; if(!empty($_POST['search']['keyword'])) { $search_keyword = $_POST['search']['keyword']; } $sql = 'SELECT * FROM posts WHERE post_title LIKE :keyword OR description LIKE :keyword OR post_at LIKE :keyword ORDER BY id DESC '; ... ... ... Add solution -
SQL 2021-08-31 11:32:02
oracle list columns schema
-- Depending on connected user grants: SELECT * FROM USER_TAB_COLS WHERE TABLE_NAME = 'my_table'; -- User tables SELECT * FROM ALL_TAB_COLS WHERE TABLE_NAME = 'my_table'; -- Available to user SELECT * FROM DBA_TAB_COLS WHERE TABLE_NAME = 'my_table'; -- Al... Add solution -
SQL 2021-08-31 07:33:03
comparison in sql
(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