Error 1364

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers

Error 1364 Mysql Insert

or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x erro 1364 mysql Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only error 1364 mysql authentication string takes a minute: Sign up ERROR 1364 (HY000): Field 'MY_DATE' doesn't have a default value up vote 0 down vote favorite 1 create table MYTABLE { MY_DATE int NOT NULL AUTO_INCREMENT, NAME varchar(255) NOT NULL UNIQUE }; INSERT INTO MYTABLE(NAME)values(jessica);

General Error 1364 Field

Why do I get this error? ERROR 1364 (HY000): Field 'MY_DATE' doesn't have a default value sql mysql mysql-error-1364 share|improve this question edited Jan 2 '14 at 17:57 JYelton 19.9k1376152 asked Feb 15 '11 at 6:30 garima 2,30152963 2 (1) Don't call it my_date if it's an int, that's just asking for trouble. (2) Don't you need quotes around jessica? –paxdiablo Feb 15 '11 at 6:34 (3) autoincrement column should also declared as a key –Shakti Singh

General Error 1364 Field Doesn't Have A Default Value

Feb 15 '11 at 6:36 @Ciaran Keating: Look at below answer –Shakti Singh Feb 15 '11 at 6:47 @Shakti: Yes, I wrote that comment too hastily. Sorry. –Ciaran Keating Feb 15 '11 at 6:53 add a comment| 3 Answers 3 active oldest votes up vote 3 down vote accepted From the docs: There can be only one AUTO_INCREMENT column per table, it must be indexed, and it cannot have a DEFAULT value. I think you'll find that, because you're not indexing MY_DATE, it may be silently ignoring the AUTO_INCREMENT option (I can't guarantee that, it's just supposition, but the note in the documentation is still relevant). All the samples I can see on the AUTO_INCREMENT stuff have (the equivalent of): PRIMARY KEY (MY_DATE) Alternatively, you may be running in strict SQL mode. All the docs I've seen seem to indicate that, in the absence of a specific default, unlisted columns in an insert will get NULL if they're nullable, or the type default if the not nullable: If you are not running in strict SQL mode, any column not explicitly given a value is set to its default (explicit or implicit) value. For example, if you specify a column list that does not name all the columns in the table, unnamed columns are set to their default values. Default value assignment is described in Section 10.1.4, “Data Type Default Values”. For an integral type, that def

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business error code 1364 Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation

Field Doesn't Have A Default Value Hibernate

Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like mysql strict_trans_tables you, helping each other. Join them; it only takes a minute: Sign up MySql Error: 1364 Field 'display_name' doesnt have default value up vote 19 down vote favorite 8 I have just switched from a MAMP installation http://stackoverflow.com/questions/5000547/error-1364-hy000-field-my-date-doesnt-have-a-default-value to a native Apache, MySql and PHP installation. I have got everything working, but I hve started using my web app in the new environment and suddenly any INSERT commands are resulting in the following error: SQLSTATE[HY000]: General error: 1364 Field 'display_name' doesn't have a default value It seems the I am unable to leave a field blank now where I was able to before. I am using MySql version 5.6.13 Is there a way to http://stackoverflow.com/questions/18751291/mysql-error-1364-field-display-name-doesnt-have-default-value change this setting in MySql? php mysql share|improve this question edited Jan 2 '14 at 18:06 JYelton 19.9k1376152 asked Sep 11 '13 at 21:06 Ben Thompson 1,27652138 possible duplicate of How do I alter a mysql table column defaults? –JimL Sep 11 '13 at 21:08 2 Is display_name a field with NOT NULL constraint and no default value? Is your insert statement not providing a value for display_name? Knowing your table structure and the insert statement would be helpful. –zedfoxus Sep 11 '13 at 21:09 Remove the strict settings or set the default values to NULL –Robot Boy Jul 2 '15 at 12:39 add a comment| 2 Answers 2 active oldest votes up vote 64 down vote accepted MySQL is most likely in STRICT mode. Try running SET GLOBAL sql_mode='' or edit your my.cnf to make sure you aren't setting STRICT_ALL_TABLES or the like. share|improve this answer answered Sep 11 '13 at 21:12 Tim B 97267 2 +1 for pointing out the STRICT mode :D –Sorin Apr 17 '14 at 14:26 2 Is it a bad practice to use strict mode in MySQL? –Artemis Nov 12 '15 at 11:43 Before you do it, you can see current value by this: SELECT @@GLOBAL.sql_mode –Kamil Kiełczewski Jun 21 at 16:31 add a comment| up vote 7 d

a default value" does not take into account triggers Summary: "Field doesn't have a default value" does not take into account triggers Status: RESOLVED WONTFIX Product: db Classification: Unclassified https://netbeans.org/bugzilla/show_bug.cgi?id=190731 Component: MySQL Version: 6.x Hardware: PC Linux Priority: P3 (vote) TargetMilestone: 7.0 Assigned To: Jiri Rechtacek QA Contact: issues@db URL: Whiteboard: Keywords: Depends on: Blocks: Show dependency tree /graph Reported: 2010-10-03 19:55 UTC by hubbitus Modified: 2010-12-13 18:40 UTC (History) CC List: 0 users See Also: Issue Type: DEFECT Exception Report : Attachments Add an attachment (proposed patch, testcase, etc.) Note You need to log in before you can comment error 1364 on or make changes to this bug. Description hubbitus 2010-10-03 19:55:56 UTC I try debug my SQL for MySQL, but got error similar: "Error code 1364, SQL state HY000: Field '_lft' doesn't have a default value" Yes, '_lft' doesn't have a default value, but it is not problem - it is computed in triggers (automatic Nested Sets implementation). Console native mysql client does not complain about it and execute query perfectly. Comment 1 Jiri error 1364 mysql Rechtacek 2010-11-26 08:45:17 UTC Could you describe your use-case? DDL of the table (incl. trigger declaration) and SQL command for inserting values (or screen shot of Insert values dialog). It'll help to evaluate this problem. Thanks Comment 2 hubbitus 2010-11-26 10:19:59 UTC Use case is very simple as INSERT INTO tablename set field1 = 'fieldvalue'; Statement was rejected from Netbeans IDE with error what listed not all fields which have not default values. But it is not always problem if such fields will populated in trigger (in any case). Console MySQL client already inserted such lines. Comment 3 Jiri Rechtacek 2010-11-26 10:31:52 UTC Bug description is not enough for me. Describe in detail by me previous comment (DDL table, SQL statemnt, trigger declaration). Comment 4 hubbitus 2010-12-13 09:35:56 UTC Ok, full reproduce: DDL: DROP TABLE IF EXISTS `nb`; CREATE TABLE `nb` ( `id` int(11) NOT NULL, `field` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; delimiter ;; DROP TRIGGER IF EXISTS `test_nb_before_insert`;; CREATE TRIGGER `test_nb_before_insert` BEFORE INSERT ON `nb` FOR EACH ROW BEGIN set NEW.field := NEW.id + 7; END;; Then in NetBeans try execute statement: INSERT INTO nb (id) VALUES(1) you got error: Error code 1364, SQL state HY000: Field 'field' doesn't have a default value Line 1, column 1 Execution finished after 0 s, 1 error(s