Programming
Casual
290

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
Popular Posts
Gps Tracker Seccodeid Free Too...
Djie sam soe Djie sam soe
General
5060
156
Top

Complete Basic Course in Kali...
Djie sam soe Djie sam soe
Linux
4437
2
Top

Free Proxy List
Sandidi Sandidi
Networking
2793
3
Top

Mass Reverse IP Unlimited
ImamSy ImamSy
Hacking
2063
10
Top

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

Related Post

Subscribe

Subscribe free now for latest posts