insert into `s_admin`(`id`,`username`,`password`,`status`) values (1,'admin','123456',1);
时间: 2024-03-27 21:32:56 浏览: 5
这是一条SQL语句,用于向名为`s_admin`的表中插入一条记录。该记录包含了`id`、`username`、`password`和`status`四个字段的值。具体的字段值如下:
- `id`字段的值为1
- `username`字段的值为'admin'
- `password`字段的值为'123456'
- `status`字段的值为1
这条语句的作用是将这些字段值插入到`s_admin`表中的一行记录中。
相关问题
那我要插入数据,写了这个语句,也按f9了 要在哪看我的表格内容,我点击那个表格一直是空的INSERT INTO `x_user` (`id`, `username`, `password`, `email`, `phone`, `status`, `avatar`, `deleted`) VALUES('1','admin','123456','super@aliyun.com','18677778888','1','https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif','0'); INSERT INTO `x_user` (`id`, `username`, `password`, `email`, `phone`, `status`, `avatar`, `deleted`) VALUES('2','zhangsan','123456','zhangsan@gmail.com','13966667777','1','https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif','0'); INSERT INTO `x_user` (`id`, `username`, `password`, `email`, `phone`, `status`, `avatar`, `deleted`) VALUES('3','lisi','123456','lisi@gmail.com','13966667778','1','https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif','0'); INSERT INTO `x_user` (`id`, `username`, `password`, `email`, `phone`, `status`, `avatar`, `deleted`) VALUES('4','wangwu','123456','wangwu@gmail.com','13966667772','1','https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif','0'); INSERT INTO `x_user` (`id`, `username`, `password`, `email`, `phone`, `status`, `avatar`, `deleted`) VALUES('5','zhaoer','123456','zhaoer@gmail.com','13966667776','1','https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif','0'); INSERT INTO `x_user` (`id`, `username`, `password`, `email`, `phone`, `status`, `avatar`, `deleted`) VALUES('6','songliu','123456','songliu@gmail.com','13966667771','1','https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif','0');
如果你已经执行了插入数据的语句,并且没有收到错误提示,那么数据应该已经成功插入到表格中了。
要查看表格的内容,你可以在SQLYog软件中选择你所在的数据库,并在左侧面板中找到 'x_user' 表格。点击表格名称,右侧窗口将显示表格的内容,包括插入的数据。
如果你点击 'x_user' 表格一直是空的,可能有以下几个原因:
1. 确保你选择的是正确的数据库和表格。
2. 确保你执行了插入数据的语句,并且没有收到错误提示。
3. 可以尝试刷新表格,在SQLYog软件上方的工具栏中找到刷新按钮,点击它可以刷新表格内容。
如果问题仍然存在,请检查插入数据的语句是否正确,并确保没有遗漏任何关键信息。
办公考勤系统Python案例
以下是一个简单的办公考勤系统Python案例:
1. 创建MySQL数据库,包含两张表:用户表和考勤记录表。
```sql
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) UNIQUE NOT NULL,
password VARCHAR(50) NOT NULL,
role VARCHAR(10) NOT NULL
);
CREATE TABLE attendance (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
date DATE NOT NULL,
check_in DATETIME,
check_out DATETIME,
status VARCHAR(10)
);
```
2. 创建Python程序,包含登录、打卡、请假和查询考勤记录等功能。
```python
import mysql.connector
import datetime
# 连接数据库
db = mysql.connector.connect(
host="localhost",
user="root",
password="password",
database="attendance"
)
# 登录功能
def login():
username = input("请输入用户名:")
password = input("请输入密码:")
cursor = db.cursor()
sql = "SELECT * FROM users WHERE username = %s AND password = %s"
values = (username, password)
cursor.execute(sql, values)
result = cursor.fetchone()
if result:
print("登录成功!")
if result[3] == 'admin':
admin_menu()
else:
user_menu(result[0])
else:
print("用户名或密码错误!")
# 管理员菜单
def admin_menu():
while True:
print("请选择操作:")
print("1. 查看考勤记录")
print("2. 导出考勤报表")
print("3. 返回登录界面")
choice = input()
if choice == '1':
view_attendance()
elif choice == '2':
export_report()
elif choice == '3':
return
else:
print("无效操作!")
# 用户菜单
def user_menu(user_id):
while True:
print("请选择操作:")
print("1. 上班打卡")
print("2. 下班打卡")
print("3. 请假申请")
print("4. 返回登录界面")
choice = input()
if choice == '1':
check_in(user_id)
elif choice == '2':
check_out(user_id)
elif choice == '3':
apply_leave(user_id)
elif choice == '4':
return
else:
print("无效操作!")
# 上班打卡
def check_in(user_id):
today = datetime.date.today()
cursor = db.cursor()
sql = "SELECT * FROM attendance WHERE user_id = %s AND date = %s"
values = (user_id, today)
cursor.execute(sql, values)
result = cursor.fetchone()
if result:
print("您已经打过卡了!")
else:
now = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
sql = "INSERT INTO attendance (user_id, date, check_in, status) VALUES (%s, %s, %s, %s)"
values = (user_id, today, now, "正常")
cursor.execute(sql, values)
db.commit()
print("打卡成功!")
# 下班打卡
def check_out(user_id):
today = datetime.date.today()
cursor = db.cursor()
sql = "SELECT * FROM attendance WHERE user_id = %s AND date = %s"
values = (user_id, today)
cursor.execute(sql, values)
result = cursor.fetchone()
if result:
if result[3]:
print("您已经打过卡了!")
else:
now = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
sql = "UPDATE attendance SET check_out = %s, status = %s WHERE id = %s"
if now > today.strftime("%Y-%m-%d 18:00:00"):
status = "加班"
else:
status = "正常"
values = (now, status, result[0])
cursor.execute(sql, values)
db.commit()
print("打卡成功!")
else:
print("您还没有上班打卡!")
# 请假申请
def apply_leave(user_id):
reason = input("请输入请假原因:")
start_date = input("请输入开始日期(格式:YYYY-MM-DD):")
end_date = input("请输入结束日期(格式:YYYY-MM-DD):")
cursor = db.cursor()
sql = "INSERT INTO attendance (user_id, date, status) VALUES (%s, %s, %s)"
values = (user_id, start_date, "请假")
cursor.execute(sql, values)
db.commit()
print("申请已提交,请等待审核!")
# 查看考勤记录
def view_attendance():
cursor = db.cursor()
sql = "SELECT users.username, attendance.date, attendance.check_in, attendance.check_out, attendance.status FROM attendance JOIN users ON attendance.user_id = users.id ORDER BY attendance.date DESC"
cursor.execute(sql)
results = cursor.fetchall()
for result in results:
print(result)
# 导出考勤报表
def export_report():
cursor = db.cursor()
sql = "SELECT users.username, attendance.date, attendance.check_in, attendance.check_out, attendance.status FROM attendance JOIN users ON attendance.user_id = users.id ORDER BY attendance.date DESC"
cursor.execute(sql)
results = cursor.fetchall()
with open("report.csv", "w") as f:
f.write("用户名,日期,上班打卡时间,下班打卡时间,考勤状态\n")
for result in results:
f.write(",".join([str(x) for x in result]) + "\n")
print("考勤报表已导出!")
# 创建管理员账号和普通用户账号
cursor = db.cursor()
sql = "INSERT INTO users (username, password, role) VALUES (%s, %s, %s)"
values = [("admin", "admin", "admin"), ("user1", "user1", "user"), ("user2", "user2", "user")]
cursor.executemany(sql, values)
db.commit()
# 运行程序
while True:
print("欢迎使用考勤系统!")
print("请选择操作:")
print("1. 登录")
print("2. 退出")
choice = input()
if choice == '1':
login()
elif choice == '2':
break
else:
print("无效操作!")
# 关闭数据库连接
db.close()
```
以上程序仅提供参考,具体实现可根据需求进行调整。
相关推荐
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)