今天记两个注意点

print('he said "Today\'s weather is good."')

注意：如果不加‘\’会报错，因为print会按顺序执行前两个单引号的内容

print("{:.3f}".format(3.1415926))

注意：输出3.142（四舍五入）

操作远程数据库 3/14

import mysql.connector

mydb = mysql.connector.connect( #连接数据库
    host = " ",       # 数据库主机地址
    user = " ",    # 数据库用户名
    passwd = " ",   # 数据库密码
    database = " "
)

def liketel(tel1,tel2):
    try:
          mycursor = mydb.cursor() //游标
      mycursor.execute("select * from table where volumn like '"+tel1+"%' and Tel like '%"+tel2+"';") //执行
      myresult = mycursor.fetchall() //返回
      if len(myresult) == 0:
        print('没有找到')
      for element in myresult:
        print(element)
    except:
          print('Error.')

liketel( , )