What do you want to save?
Add Code snippet
New code examples
-
PHP 2022-02-02 18:30:50
showing database table in php
$connection = mysql_connect('localhost', 'root', ''); //The Blank string is the password mysql_select_db('hrmwaitrose'); $query = "SELECT * FROM employee"; //You don't need a ; like you do in SQL $result = mysql_query($query); echo "<t... Add solution -
Other 2022-02-02 11:46:39
dapper
string sqlOrderDetails = "SELECT TOP 5 * FROM OrderDetails;"; string sqlOrderDetail = "SELECT * FROM OrderDetails WHERE OrderDetailID = @OrderDetailID;"; string sqlCustomerInsert = "INSERT INTO Customers (CustomerName) Values (@Cu... Add solution -
SQL 2022-01-31 03:06:55
sql syntax
select [all/distinct] <COL1>, <COL2>, <COL3> from <TABLE_NAME> [join <JOIN_CONDITION>] [where <CONDITION>] [group by <COLUMN_NAME>] [having <SEARCH_CONDITION>] [order by <SORT_SPECIFICATION>] /* Spec... Add solution -
SQL 2022-01-29 08:20:11
update multiple columns in sql
-- Oracle UPDATE table2 t2 SET (VALUE1, VALUE2) = (SELECT COL1 AS VALUE1, COL1 AS VALUE2 FROM table1 t1 WHERE t1.ID = t2.ID); -- SQL Server UPDATE table2 t2 SET t2.VALUE1 = t1.COL1, t2.VALUE2 = t1.COL2 FROM table1 t1 INNER JOIN t2 ON t1.ID = ... Add solution -
PHP 2022-01-27 04:46:23
php prepared statement select
// Multiple rows: $sql = "SELECT * FROM users WHERE id=?"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $id); $stmt->execute(); $result = $stmt->get_result(); while ($row = $result->fetch_assoc()) { echo $ro... Add solution -
VBA 2022-01-26 03:32:10
Restoring database file from backup file vb.net
Disable the emails in tblUsers by changing @ to # update tblUsers set Email = replace(Email, '%@%', '%#%') where Email like '%@%' update tblusers set email = replace(email,'@','#') Connection error: USE MASTER GO SELECT name as SQLServerLogIn,SID as... Add solution -
Other 2022-01-22 17:05:10
SELECT FROM
select [all/distinct] <COL1>, <COL2>, <COL3> from <TABLE_NAME> [join <JOIN_CONDITION>] [where <CONDITION>] [group by <COLUMN_NAME>] [having <SEARCH_CONDITION>] [order by <SORT_SPECIFICATION>] /* Spec... Add solution