Programming
Casual
433

Warning: #1265 Data truncated for column 'deskripsi' at row 1






  05-Oct-2021 11:25:59



Gw dapat trouble di mysql database table artikel kolom deskripsi eror "Warning: #1265 Data truncated for column 'deskripsi' at row 1" gw input berdasarkan konten yg gwa buat pakek command mysql tapi eror,gwa coba input 3 huruf bisa masuk yg salah dimana bang?

table artikel

MariaDB [blogger]> describe artikel;
+----------------+--------------+------+-----+---------------------+-------------------------------+
| Field          | Type         | Null | Key | Default             | Extra                         |
+----------------+--------------+------+-----+---------------------+-------------------------------+
| id_blog        | int(11)      | NO   | PRI | NULL                | auto_increment                |
| judul          | varchar(255) | NO   |     | NULL                |                               |
| kategori       | varchar(255) | NO   |     | NULL                |                               |
| deskripsi      | varchar(255) | NO   |     | NULL                |                               |
| gambar         | varchar(255) | NO   |     | NULL                |                               |
+----------------+--------------+------+-----+---------------------+-------------------------------+
5 rows in set (0.020 sec)

DISCUSSION



05-Oct-2021 13:38:16

Gw kurang paham ama pertanyaan lo




Reply


10-Oct-2021 13:37:20



Udah solve ko


Reply

Itu kamu masukin inputan datanya banyak ga? Kalau banyak ya pantes eror. Jadi solusi nya kamu ganti data type di field deskripsi, yang awalanya tadi varchar(255) ganti menjadi longtext ini rekomen coba aja

MariaDB [blogger]> describe artikel;
+----------------+--------------+------+-----+---------------------+-------------------------------+
| Field          | Type         | Null | Key | Default             | Extra                         |
+----------------+--------------+------+-----+---------------------+-------------------------------+
| id_blog        | int(11)      | NO   | PRI | NULL                | auto_increment                |
| judul          | varchar(255) | NO   |     | NULL                |                               |
| kategori       | varchar(255) | NO   |     | NULL                |                               |
| deskripsi      | longtext     | NO   |     | NULL                |                               | //ubah ini
| gambar         | varchar(255) | NO   |     | NULL                |                               |
+----------------+--------------+------+-----+---------------------+-------------------------------+
5 rows in set (0.020 sec)



Reply


10-Oct-2021 13:36:54



Udah solve bang thank dah bantu


Reply

Login for comment and discussion.
Login Here
Sponsored

Oppss... No sponsors yet

Popular Posts
Complete Basic Course in Kali...
Djie sam soe Djie sam soe
Linux
12371
2
Top

Gps Tracker Seccodeid Free Too...
Djie sam soe Djie sam soe
General
7347
167
Top

Free Proxy List
Sandidi Sandidi
Networking
3160
3
Top

Mass Reverse IP Unlimited
ImamWawe ImamWawe
Tools Hacking
2541
12
Top

Report McAfee Antivirus Hurrri...
Indrasp Indrasp
Windows
1760
93
Top

Related Post

Youtube Video

Subscribe