风吹八千里-CSDN博客

原创 2021-08-28

show variables like 'transaction_isolation'; -- set transaction isolation level serializable; -- set session transaction isolation level serializable; -- set global transaction isolation level serializable;

2021-09-09 21:53:24 107

原创 2021-08-28

delimiter $$ create trigger payment_after_insert after insert on payments for each row begin update invoices set payment_total = payment_total + new.amount where invoice_id = new.invoice_id; end $$ delimiter ; create trigger payment_after_de

2021-08-28 23:21:49 115

原创 2021-08-24

CREATE DEFINER=`root`@`localhost` PROCEDURE `get_clients_by_state`(state char(2)) BEGIN if state is null then set state = 'ca'; end if; select * from clients c where c.state = state; END CREATE DEFINER=`root`@`localhost` PROCEDURE `get_clients_by

2021-08-25 22:43:35 145

原创 2021-08-23练习

use sql_invoicing; create view sales_by_client as select i.client_id, c.name, sum(i.invoice_total) as invoice from invoices i join clients c using(client_id) group by i.client_id,c.name create view clients_balance as select c.client_id, c.

2021-08-24 21:40:21 94

原创 2021-08-22

USE Sql_store; SELECT * FROM orders where year(order_date) = year(now())-4 select date_add(now(),interval 1 year), date_sub(now(),interval -1 year) use sql_store; select order_id, -- ifnull(shipper_id,'NOT') coalesce(shipper_id,comments,'NOT') as

2021-08-23 22:11:04 96

原创 2021-08-21练习mysql

use sql_store; -- select distinct customer_id,first_name,last_name -- from order_items -- left join products using(product_id) -- left join orders using(order_id) -- left join customers using(customer_id) -- where product_id = 3; -- select customer_id,fi

2021-08-22 23:03:04 133

原创 html_css练习：网页标题栏

<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>documents</title> <style type="text/css"> *{ margin: 0px; padding: 0px; } body{ pa

2021-08-08 20:13:02 614

原创 html_css自动返回顶部小标签

<html> <style type="text/css"> *{ margin: 0; padding: 0; } a{ display: block; width: 60px; height: 60px; line-height: 30px; text-al.

2021-08-08 07:11:17 201

原创 css练习2.0选择框带颜色

<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>documents</title> <style type="text/css"> *{ margin: 0; padding: 0; } body{ backgr

2021-08-08 06:47:50 242

原创网页中小窗口的代码1.0此时学到这里。

<!DOCTYPE html> <html> <head>  <meta charset="utf-8"> <title>document</title> <style type="text/css"> body{ font-size: 12

2021-08-05 10:58:53 347

原创 2021-07-16员工管理系统

emps = ['孙悟空\t\t18\t\t男\t\t花果山','猪八戒\t\t28\t\t男\t\t高老庄'] while True: print("="*20,"欢迎使用员工管理系统","="*20) print() print("请选择你要做的操作：") print("\t1.查询员工") print("\t2.添加员工") print("\t3.删除员工") print("\t4.退出系统") print() user

2021-07-16 23:10:58 106