摘要:
num = int(input('Enter a number: ')) if num > 0: print('The number is positive') elif num < 0: print('The number is negative') else: print('The number 阅读全文
摘要:
1.序列解包 同时给多个变量赋值 >>> x, y, z = 1, 2, 3 >>> print(x, y, z) 1 2 3 用这种方式还可以交换两个变量的值 >>> x, y = y, x >>> print(x, y, z) 2 1 3 实际上这里的操作称为序列解包,将一个序列解包,并将得到的 阅读全文
摘要:
center >>> "The Middle by Jimmy Eat World".center(39) ' The Middle by Jimmy Eat World ' >>> "The Middle by Jimmy Eat World".center(39, "*") '*****The 阅读全文
摘要:
-- 1、查看缺失值CREATE TABLE dnull AS SELECT * FROM data; -- 复制数据SELECT * FROM dnull WHERE 房屋编码 IS NULL OR 小区 IS NULL OR 朝向 IS NULL OR 房屋单价 IS NULL OR 参考首付 阅读全文
摘要:
1、WITH语句原理:通用表表达式(Common Table Expressions)/CTEs,在大型查询中的辅助语句 WITH name_for_summary_data AS ( SELECT Statement) SELECT columns FROM name_for_summary_da 阅读全文