| View previous topic :: View next topic |
| Author |
Message |
bytenirvana
Apprentice
Joined: 10 Jun 2006
Posts: 218
Location: Volksstaat Hessen
|
 Posted: Sun Jul 16, 2006 7:28 pm Post subject: [solved] MySql-Administrator - Error 1064 |
 |
|
Hi,
I get an error while adding a column to a database: the "confirm table changes"-dialog appears with | Code: | | ALTER TABLE `my_db`.`my_table` ADD COLUMN `time` VARCHAR NOT NULL DEFAULT '' AFTER `date_available`; |
If I want to run the changes I get the error 1064 - syntax error
1) Can I post this as an bug, cause the program itself generated the wrong syntax for me?
2) What is wrong? http://dev.mysql.com/doc/refman/4.0/de/alter-table.html explains the "alter table" command, but I'm not able to take off advantage from this.
Last edited by bytenirvana on Mon Jul 17, 2006 2:53 pm; edited 1 time in total |
|
| Back to top |
|
 |
smiffy
Apprentice
Joined: 28 Jun 2006
Posts: 259
Location: SA.AU.AP.EARTH
|
| Posted: Mon Jul 17, 2006 1:22 am Post subject: |
|
|
| You didn't say how big your VARCHAR should be. Try VARCHAR(64), or whatever size you want. |
|
| Back to top |
|
|
bytenirvana
Apprentice
Joined: 10 Jun 2006
Posts: 218
Location: Volksstaat Hessen
|
| Posted: Mon Jul 17, 2006 2:54 pm Post subject: |
|
|
yes thanks, you were right.
However: I can't see an input field for the varchar length in the gui, so can I consider the missing of this field as an "bug"? |
|
| Back to top |
|
|
smiffy
Apprentice
Joined: 28 Jun 2006
Posts: 259
Location: SA.AU.AP.EARTH
|
| Posted: Mon Jul 17, 2006 9:13 pm Post subject: |
|
|
I am not familiar with your GUI, but would say that there may be an issue because:
* If you are selecting the field type from a drop-down list, provision should be made for any extra parameters required.
* There may be a usability issue in that if you are typing the field type into a text box, ideally, the GUI should do some validation to check that mandatory parameters have been passed, before it fires the query off to MySQL.
Have you checked the documentation for your GUI?
_________________
Matthew Smith |
|
| Back to top |
|
|
bytenirvana
Apprentice
Joined: 10 Jun 2006
Posts: 218
Location: Volksstaat Hessen
|
| Posted: Tue Jul 18, 2006 1:44 pm Post subject: |
|
|
I'm using Mysql-Administrator
| smiffy wrote: | | Have you checked the documentation for your GUI? |
No. you mean man mysql-administrator with documentation? |
|
| Back to top |
|
|
|
Other Things Gentoo
