ນຳເຂົ້າຂໍ້ມູນຜູ້ໃຊ້ຕົວຢ່າງ
ໂຄງສ້າງຕາຕະລາງຜູ້ໃຊ້:
- id
- username
- password
- full_name
- email
- role
- status
- created_at
- updated_at
ຂໍ້ຜິດພາດໃນການລຶບຂໍ້ມູນຜູ້ໃຊ້: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`sulixay_db`.`quotations`, CONSTRAINT `quotations_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`))
SQL ທີ່ໃຊ້: INSERT INTO users (`username`, `password`, `full_name`, `role`, `email`, `status`) VALUES (?, ?, ?, ?, ?, ?)
ຂໍ້ຜິດພາດໃນການເພີ່ມຂໍ້ມູນຜູ້ໃຊ້: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'admin' for key 'username'
ລະຫັດຜ່ານສຳລັບທຸກບັນຊີແມ່ນ: password123
ກັບໄປຫນ້າເຂົ້າສູ່ລະບົບ