mysql> describe main;
++--+--+-+-+---+
-+
| Field | Type | Null | Key | Default | Extra |
Privileges |
++--+--+-+---
I accidentally crashed 1 of my tables. So I deleted everything in the table
and tried to reload the data into the table and now I get this error:
Query OK, 1 row affected (0.02 sec)
Records: 1 Deleted: 0 Skipped: 0 Warnings: 5
I have a total of 1901 records in this txt file. I puts the first reco
I had a column that was set to varchar(50) which ended up not being enough
space. So I went in and did a:
alter table main change description description varchar(255) not null;
It said everything went ok, I reimported the text file, but the words stop
after 50 characters still did I miss something
I am trying to insert this into my table but mysql doesn't like my syntax.
alter table categoryminor solvalveyn enum('True','False');
When I press enter it does nothing it just goes to a greater than prompt.
What I want is for 1 to be true and 0 to be false.
What is the syntax that I am needin
I want to have like in Access a column that is yes or no or true or false,
something on that line. I looked at www.mysql.com but could not find
anything. I don't know what exactly I am looking for. Could someone give me
a hand it will be greatly appreciated.
-
