tk50486yui

// ==UserScript==
// @name         google-translate-save
// @version      1.0
// @description  save data to your database
// @author       Yue
// @match        https://translate.google.com.tw/*
// @grant        none
// @require      https://unpkg.com/axios/dist/axios.min.js
// @downloadURL  https://gist.github.com/tk50486yui/54cabdf110fbb4d3589a0fa9a8834bbe/raw/7cedc2d2e3484754822d39ee3cb767ba6ecf4d7b/google-translate-saving.user.js
// @updateURL    https://gist.github.com/tk50486yui/54cabdf110fbb4d3589a0fa9a8834bbe/raw/7cedc2d2e3484754822d39ee3cb767ba6ecf4d7b/google-translate-saving.user.js

tk50486yui

CREATE TABLE users(
	u_no NUMBER(10) NOT NULL,
	u_account varchar2(30) NOT NULL UNIQUE,
	u_password varchar2(100) NOT NULL,	
	u_name varchar2(30) NOT NULL,
	u_address varchar2(200),
	CONSTRAINT users_pk PRIMARY KEY (u_no)
)

tk50486yui

CREATE TABLE users(
	u_no int IDENTITY(1,1) PRIMARY KEY,
	u_account varchar(30) NOT NULL UNIQUE,
	u_password varchar(100) NOT NULL,	
	u_name varchar(30) NOT NULL,
	u_address varchar(200)
)

tk50486yui

INSERT INTO books (b_no, b_bookname, b_author, b_price, b_publisher) VALUES (1, '辭海', '李四', 799, '甲骨文出版社');
INSERT INTO books (b_no, b_bookname, b_author, b_price, b_publisher) VALUES (2, '童話故事書', '張三', 200, '童話出版社');
INSERT INTO books (b_no, b_bookname, b_author, b_price, b_publisher) VALUES (3, '成語字典', 'Jack', 1000, '甲骨文出版社');
INSERT INTO books (b_no, b_bookname, b_author, b_price, b_publisher) VALUES (4, '彩繪本', '小華', 100, '彩繪出版社');
INSERT INTO books (b_no, b_bookname, b_author, b_price, b_publisher) VALUES (5, '東遊記', '王五', 300, '石頭出版社');
commit;

tk50486yui

CREATE TABLE books (
    	b_no  NUMBER(10) NOT NULL,
   	b_bookname VARCHAR2(50),
    	b_author VARCHAR2(50),
	b_price NUMBER(10),
	b_publisher VARCHAR2(50),
	CONSTRAINT books_pk PRIMARY KEY (b_no)
);

CREATE TABLE messages(

tk50486yui

INSERT INTO books (b_bookname, b_author, b_price, b_publisher) VALUES ('辭海', '李四', '699', '集集出版社')
INSERT INTO books (b_bookname, b_author, b_price, b_publisher) VALUES ('童話故事書', '張三', '200', '童話出版社')
INSERT INTO books (b_bookname, b_author, b_price, b_publisher) VALUES ('英文字典', 'Jack', '1000', '集集出版社')
INSERT INTO books (b_bookname, b_author, b_price, b_publisher) VALUES ('彩繪本', '小華', '100', '彩繪出版社')
INSERT INTO books (b_bookname, b_author, b_price, b_publisher) VALUES ('東遊記', '王五', '300', '石頭出版社')

tk50486yui

CREATE TABLE books(
	b_no int IDENTITY(1,1) PRIMARY KEY,
	b_bookname varchar(50),
	b_author varchar(50),
	b_price int,
	b_publisher varchar(50)
)

CREATE TABLE messages(
	m_no int IDENTITY(1,1) PRIMARY KEY,

tk50486yui

cd
mkdir
pwd
clear
rm test.txt
rm -rf testDir
ls
ls -la
touch test.txt
cat test.txt             // more