What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-01-26 10:21:13
which is better to read mongodb and mysql for c++ programmer
''' MySQL is a relational database management system (RDBMS) from the Oracle Corporation. Like other relational systems, MySQL stores data in tables and uses structured query language (SQL) for database access. When MySQL developers need to access data... Add solution -
SQL 2022-01-26 04:01:04
trigger on update of a particular column
-- SQL Server (update my_table after update on my_table) CREATE TRIGGER trigger_name ON my_table AFTER UPDATE AS IF UPDATE (col_name) -- Optional, for particular column BEGIN UPDATE my_table SET my_col_date = getdate() FROM my_table END; -- Oracle (i... Add solution -
SQL 2022-01-22 22:40:24
connecting to a new database using postgresql sql shell
For Windows users using the SQL shell \c DB_NAME USER_NAME HOST PORT // to get the connection details such as your username, host and port simply use the "\conninfo" command eg : \c test1 john_doe localhost 5432 Add solution -
PHP 2022-01-22 21:00:29
php get result sql server
//on sql server public function get_data_from($id){ $request = "SELECT * FROM yourTable WHERE id = ?"; //preparing the request $stmt = $this->dbh->prepare($request); //executing the request $stmt->execute( array($id) ); ... Add solution -
SQL 2022-01-22 14:16:10
sql date format yyyy-mm-dd
-- Oracle:TO_DATE(string, format) SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual; SELECT TO_DATE('05/06/2012 13:25:12', 'DD/MM/YYYY HH24:MI:SS') FROM dual; -- SQL Server: CONVERT(data_type, string, style). Cf source link for style codes. SELECT CONV... Add solution
Best helpers
Ranking is empty