Programming
Casual
846

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)

*Beware click the link!


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 report, comment and join discussion
Login Here
Sponsored

Popular Posts
Gps Tracker Seccodeid Free Too...
General
21378
204
Top


Djie sam soe Djie sam soe
Complete Basic Course in Kali...
Linux
14397
4
Top


Djie sam soe Djie sam soe
Komintod (Ministry of Communic...
Data Leak
6527
98
Top


Murtad methamphetamine Murtad methamphetamine
Free Proxy List
Networking
3627
3
Top


Sandidi Sandidi
Mass Reverse IP Unlimited
Tools Hacking
3407
15
Top


ImamWawe ImamWawe

Related Post

Youtube Video

Subscribe