|
Replies:
0
-
Pages:
1
|
|
|
Posts:
1
Registered:
4/2/07
|
|
|
|
problem with alter table
Posted:
Aug 1, 2012 2:21 AM
|
|
|
Hello,
I found an issue in alter table generated by toad
ALTER TABLE table_name
CHANGE test test BIT DEFAULT '1';
there is a message
MySQL Database Error: Invalid default value for 'test'
You have to manually change it to
ALTER TABLE tabela
CHANGE test test BIT DEFAULT b'1';
is this known issue?
|
nn
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
