how to update column with null value?
Marc
As i update column with null value, it gives me an error like this:
SQLSTATE[42S22]: Column not found: 1054 Unknown column '00:00:00' in 'field list' (SQL: update
attendancesset00:00:00= 12:11:45 where (studentid= 4 anddate= 2018-07-09))
query
DB::table('attendances')
->where(['studentid' => $singleData['id'], 'date' => $date])
->update([$data['out_am'] => $time]);
my controller
![[Image]](https://i.stack.imgur.com/Nymj7.png)
DigitalDrifter
You are using a value as a field name. It should probably be something like this:
DB::table('attendances')
->where(['studentid' => $singleData['id'], 'date' => $date])
->update(['out_am' => $data['out_am']]);
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Deserialize nested json with different property names
- Next: Using Python's BeautifiulSoup Library to Parse info in a Span HTML tag
Related
TOP Ranking
- 1
Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background
- 2
pump.io port in URL
- 3
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 4
grouping by column variables and appending a new variable based on condition
- 5
Python Read Directory And Output to CSV
- 6
BigQuery - concatenate ignoring NULL
- 7
Angular 8. Unknown amount of http.get requests in array to call, must be sequential, what to use
- 8
Remove adjacent duplicates in linked list in C
- 9
Can a 32-bit antivirus program protect you from 64-bit threats
- 10
How to keep curl session alive between two php processes?
- 11
Limit number of characters in uitextview
- 12
Unable to use switch toggle for dark mode in material-ui
- 13
In C#, is there a way to create a List directly from an Array without copying?
- 14
Laravel getting value from another table using eloquent
- 15
Spring Boot JPA PostgreSQL Web App - Internal Authentication Error
- 16
MTKView Displaying Wide Gamut P3 Colorspace
- 17
Vector input in shiny R and then use it
- 18
Modify c# Windows Forms control library
- 19
SQL Server : are transaction locking table for other users?
- 20
When I click any button in my view page the form is submitted
- 21
Can you sort columns (horizontally) in Google Sheets?
Comments