Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql select another database

# databasename.tablename

INSERT INTO db1.myday (id, name) SELECT kode, nama FROM db2.youday
Comment

PREVIOUS NEXT
Code Example
Sql :: how select a json value in mysql 
Sql :: grant read only privileges postgres user 
Sql :: sql server arabic collation 
Sql :: postgresql get last 10 records 
Sql :: mysql date to string 
Sql :: sql check if date is between 2 dates 
Sql :: sql server obtener fecha en formato dd/mm/yyyy 
Sql :: select all except one column sql 
Sql :: trigger in postgresql to change incoming entry 
Sql :: check mysql username and password ubuntu 
Sql :: SET NOCOUNT ON; 
Sql :: mysql timestamp to date 
Sql :: sql create table statement 
Sql :: mysql add to number 
Sql :: oracle show index columns 
Sql :: locate sql server 
Sql :: install mysql workbench ubuntu 20.04 
Sql :: sql duplicate rows 
Sql :: snap remove mysql workbench 
Sql :: postgresql dump and restore db 
Sql :: install mysql on bash 
Sql :: identify number of rows in sql 
Sql :: postgres json to string 
Sql :: mysql on update current_timestamp 
Sql :: sql create schema 
Sql :: nested if in mysql 
Sql :: java string to sql timestamp 
Sql :: oracle pagination query rownum 
Sql :: mysql full outer join 
Sql :: how to create a sql database 
ADD CONTENT
Topic
Content
Source link
Name
4+4 =