Stack Overflow
Stack Overflow

Questions tagged [mysql-error-1264]

11 questions
10
votes
1 answer

Strange MySQL warning 1264 for valid DateTime value

I have manually (GASP!) entered a MySQL command at the command line, and I received a Warning which I cannot even begin to understand. (And before anyone says anything, yes, I KNOW: 1. Using the command line interface is not the best approach; 2.…
user1564318
  • 103
  • 1
  • 6
4
votes
3 answers

MySQL Error Code: 1264. Out of range value for column 'columnname' at row 1

I'm using MySQL to store a 20-digit ID number. When I query the database with the following query, I get the following error. Query: UPDATE tablename SET columnname = 59641217344615859740; Error: Error Code: 1264. Out of range value for column…
APixel Visuals
  • 89
  • 1
  • 1
  • 12
3
votes
4 answers

#1264 Out of range value fix?

When I try to insert the below into my MySQL INSERT INTO `rooms` (`id`, `ip`) VALUES ('131213', '-259857341'); I fails with the follow error: Warning: #1264 Out of range value for column 'ip' at row 1 I am looking around but haven't found how to…
Guapo
  • 3,446
  • 9
  • 36
  • 63
2
votes
2 answers

Strange 1264 Out of Range Error

When running a set of insert statements in MySQL I keep getting Error Code: 1264. Out of range value for column 'x' at row 1. The column type is set to float(10, 10) and the values in the column range from 23.912 to 26.458 which are well within the…
ThoseKind
  • 754
  • 2
  • 13
  • 22
2
votes
3 answers

specify what columns not to insert values into mysql table

I have a stored procedure that inserts a row into a table with an autoincremented column. It gives me a warning but succeeds if i simply put "" for the value of the autoincremented column. The way I get rid of the error currently is to specify which…
Matt Phillips
  • 11,249
  • 10
  • 46
  • 71
1
vote
1 answer

What is the impact of ignoring MySQL warning messages?

Below is the CREATE TABLE statement used to create my table: CREATE TABLE IF NOT EXISTS `data_received` ( `id` int(10) unsigned NOT NULL, `date_received` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `edit_time` datetime NOT NULL } Below is…
Shahriar N Khondokar
  • 578
  • 2
  • 7
  • 19
1
vote
2 answers

Strange return in MySQL queries

Got a little issue here. I'm periodically making an automated update of currencies in a MySQL table. Part of the generated query is : UPDATE ara_curr SET…
nnikolov06
  • 183
  • 3
  • 11
0
votes
0 answers

numeric out of range 1264 out of range value

I have table X with 2 columns Address ( varchar ) , Date ( int ). I want to drop column address so that I run this command: alter table x drop column address I get the error message: numeric out of range: 1264 out of range value for column date at…
Thang Nguyen
  • 3
  • 3
0
votes
1 answer

Error when inserting record into mysql table

I have created the following table: CREATE TABLE IF NOT EXISTS `prices_1d` ( `symbol` char(50) NOT NULL, `open_time` datetime DEFAULT NULL, `open` decimal(15,8) unsigned DEFAULT NULL, `high` decimal(15,8) unsigned DEFAULT NULL, `low`…
JejeBelfort
  • 1,593
  • 2
  • 18
  • 39
0
votes
0 answers

MySQL Error 1264 out of range value for Column 'Telnum' at row 1

I'm literally new to SQL, trying to do a little address book as a database, issue I ran into was as described in the title. My table: creation CREATE TABLE IF NOT EXISTS mydb.Addr ( idAddr INT(11) NOT NULL AUTO_INCREMENT, Zipcode…
Betval
  • 3
  • 2
0
votes
1 answer

MySQL Update command

I have a query in MySQL UPDATE `mylandho_foreclosure`.`property_commercial` SET `winningBid` = '14000000.00' WHERE `property_commercial`.`propertyId` =325 LIMIT 1 ; but it shows warning Warning: #1264 Out of range value adjusted for column…
Rajanikant
  • 1