Inserting TIMESTAMP data in MYSQL? Error "MYSQL version for the right syntax to use near etc"

Question

I want to add a Timestamp data in my table but got error how can I fix this?

enter image description here

Here is my Proc

    CREATE PROCEDURE `db`.`AddMerchantProcessor` (m_id INT, p_id INT, d TIMESTAMP)
BEGIN
    INSERT INTO `tbl_merchant_processor`(`merchant_id`, `processor_id`, `date`) VALUES(m_id, p_id, d);
END

John Woo · Accepted Answer · 2012-12-29 01:34:48Z

2

timestamp should be wrap with single quotes, eg

CALL AddMerchantProcessor(0, 1, '2012-01-01 00:00:00')

but it's not the proper way of using the Command object. The query should be parameterized.

Here's a little code snippet:

MySqlCommand comm = new MySqlCommand();
comm.Connection = cn;
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = "AddMerchantProcessor";
comm.Parameters.AddWithValue("m_id", m_id);
comm.Parameters.AddWithValue("p_id", p_id);
comm.Parameters.AddWithValue("d", d);
cn.Open();
comm.ExecuteNonQuery();

you need to:

use using statement for automatic object disposal
put some trycatch for proper exception handling

SOURCES

edited Dec 29, 2012 at 1:34

answered Dec 29, 2012 at 1:29

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

GrayFullBuster Over a year ago

I tried this already and still got error "Incorrect datetime value: '12/28/2012 17:36:19' for column 'd' at row 1"

GrayFullBuster Over a year ago

it's fix , I just added Convert.ToDateTime(d). Thanks

Collectives™ on Stack Overflow

Inserting TIMESTAMP data in MYSQL? Error "MYSQL version for the right syntax to use near etc"

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related