- 博客(11)
- 收藏
- 关注
RSS订阅原创 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
64
原创 2021-08-28
delimiter $$create trigger payment_after_insert after insert on payments for each rowbegin 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
74
原创 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 cwhere c.state = state;ENDCREATE DEFINER=`root`@`localhost` PROCEDURE `get_clients_by
2021-08-25 22:43:35
84
原创 2021-08-23练习
use sql_invoicing;create view sales_by_client asselect i.client_id, c.name, sum(i.invoice_total) as invoicefrom invoices ijoin clients c using(client_id)group by i.client_id,c.namecreate view clients_balance asselect c.client_id, c.
2021-08-24 21:40:21
53
原创 2021-08-22
USE Sql_store;SELECT *FROM orderswhere year(order_date) = year(now())-4select 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
58
原创 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
98
原创 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
511
原创 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
152
原创 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
190
原创 网页中小窗口的代码1.0此时学到这里。
<!DOCTYPE html><html><head> <!--网页中小窗口的代码1.0今天学到这里。每个标签都设置了自己的hight和line-height--> <meta charset="utf-8"> <title>document</title> <style type="text/css"> body{ font-size: 12
2021-08-05 10:58:53
300
原创 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
75
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人