MySql alter table in c# error

Question

I am trying to perform

ALTER TABLE

command in my app, but when running, I am getting this error

 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR(10) NOT NULL' at line 1

Here is my code:

for (int k = 0; k < dlzkaTab; k++)
{
 string query1 = "ALTER TABLE reflextime ADD " + atributes[k] + " VARCHAR(10) NOT NULL";
 MySqlCommand cmd = new MySqlCommand(query1, conect);
 cmd.ExecuteScalar();
 }

Can anyone please help me?

EDIT:

Here is full code. In the firs for loop I am reading first row from xls file and I am putting it into array atributes. As you can see, I was trying to print out every loaded cell. It worked well (It was printing correct values). However after this for loop the array is printing nothing (empty messagebox).

  for (int j = 2; j < colCount; j++)
  {
   string atr = xlRange.Cells[1, j].Text;
   atributes[j]=atr;
   MessageBox.Show(atributes[j]);
  }

 MessageBox.Show("Súbor načítaný");

 int dlzkaTab = atributes.Length;

 MessageBox.Show(atributes[1]);  //empty messagebox

 for (int k = 0; k < dlzkaTab; k++)
 {
 string query1 = "ALTER TABLE reflextime ADD COLUMN " + atributes[k] + " VARCHAR(10) NOT NULL";
 MySqlCommand cmd = new MySqlCommand(query1, conect);
 cmd.ExecuteScalar();

 }

can u print all query1 and get the actual queries add in the question ? — Abhik Chakraborty
– Abhik Chakraborty, Commented Apr 10, 2014 at 11:03
can you check MessageBox.Show(atributes[3]); what value you get for this and say?? — Amarnath Balasubramanian
– Amarnath Balasubramanian, Commented Apr 10, 2014 at 11:25

Ravinder Reddy · Accepted Answer · 2014-04-10 11:08:53Z

2

I think you are trying to add a column to the table.

You missed COLUMN keyword in the statement before column name that is being added.

"ALTER TABLE reflextime ADD COLUMN " + atributes[k] + " VARCHAR(10) NOT NULL"

answered Apr 10, 2014 at 11:08

Ravinder Reddy

24.1k6 gold badges54 silver badges86 bronze badges

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

1 Comment

Vignesh Kumar A Over a year ago

No need COLUMN keyword in ADD

Vignesh Kumar A · Accepted Answer · 2014-04-10 11:34:55Z

2

You need to use ExecuteNonQuery instead of ExecuteScalar

And also check your each atributes[k] fro value exist or not

Try this

 for (int k = 0; k < dlzkaTab; k++)
 {
 string query1 = "ALTER TABLE reflextime ADD " + atributes[k] + " VARCHAR(10) NOT NULL";
 MySqlCommand cmd = new MySqlCommand(query1, conect);
 cmd.ExecuteNonQuery();
 }

edited Apr 10, 2014 at 11:34

answered Apr 10, 2014 at 11:08

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Collectives™ on Stack Overflow

MySql alter table in c# error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related