SQLSTATE[01000]: Warning: 1265 Data truncated for column 'visibility' at row 1
I have found this error SQLSTATE[01000]: Warning: 1265 Data truncated for column 'visibility' at row 1 while submitting form data to the table in column (enum type). I have passed the incorrect value to the form input while submitting the data.
Answers 1
-
Pass accurate data to form input while submitting data to column with enum type
<select class="form-control" name="visibility" id="eventVisibility"> <option selected value="public"> Public </option> <option value="private"> Private </option> </select>0There is a column with an enum type that has a predefined value in the table. So if pass the incorrect data or data which is already not defined in it then we can get SQLSTATE[01000]: Warning: 1265 Data truncated for column 'visibility' at row 1 error while submitting the form data to the server.
Random Code Snippet Queries: Sql
- 1553 Cannot drop index 'posts_user_id_foreign': needed in a foreign key constraint
- How to create a new table from existing table in SQL
- Insert multiple rows in a single MySQL query
- SQL query to delete all rows older than 30 days
- How to check the MySQL version
- Get comma separated ids from table using MySQL
- Cannot drop index 'fk_role_id': needed in a foreign key constraint
- Change existing MySQL table column id to autoincrement
- How to retrieve data from two tables with one SQL statement
- Create column after a column in existing table using query in MySQL
- Drop foreign id column (user_id) in MySQL
- How to show database tables in mysql using command line
- Database connection using mySQLi with object-oriented
- Get create table Query from existing table in phpMyAdmin
- Get data in random order with limit from table using mysql
- SQL query to delete records older than 6 months
- How to check column exists or not in table using MySQL