Re: oops!!! Here's the output

[Scott Dunn]

mysql> describe main;
++--+--+-+-+---+
-+
| Field  | Type | Null | Key | Default | Extra |
Privileges  |
++--+--+-+-+---+
-+
| commondata | varchar(30)  | YES  | | NULL|   |
select,insert,update,references |
| id | int(10) unsigned |  | PRI | 0   |   |
select,insert,update,references |
| fpipart| varchar(100) | YES  | | NULL|   |
select,insert,update,references |
| description| varchar(100) | YES  | | NULL|   |
select,insert,update,references |
| documentfile   | varchar(200) | YES  | | NULL|   |
select,insert,update,references |
| pumps  | varchar(200) | YES  | | NULL|   |
select,insert,update,references |
| pumptype   | int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| maxflow| int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| flowtype   | varchar(200) |  | | |   |
select,insert,update,references |
| maxpressure| int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| maxhead| int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| field1 | int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| mzxsyspressure | int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| maxtemp| int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| speed  | int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| applicationservice | int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| valves | int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| pipesize   | int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| orificesize| int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| minimum| int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| opacinertgas   | int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| opacinertwater | int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| opaclightoil   | int(10) unsigned | YES  | | NULL|   |
select,insert,update,references |
| opdcinertgas   | int(10) unsigned |  | | 0   |   |
select,insert,update,references |
| opdcinertwater | int(10) unsigned |  | | 0   |   |
select,insert,update,references |
| opdclightoil   | int(10) unsigned |  | | 0   |   |
select,insert,update,references |
| maxfluidtempac | int(10) unsigned |  | | 0   |   |
select,insert,update,references |
| maxfluidtempdc | int(10) unsigned |  | | 0   |   |
select,insert,update,references |
| bodymatl   | varchar(100) |  | | |   |
select,insert,update,references |
| seatingmatl| varchar(100) |  | | |   |
select,insert,update,references |
| qtyorder   | int(10) unsigned |  | | 0   |   |
select,insert,update,references |
| docexists  | varchar(100) |  | | |   |
select,insert,update,references |
| price  | varchar(50)  |  | | |   |
select,insert,update,references |
| userprice  | varchar(50)  |  | | |   |
select,insert,update,references |
| pricetext  | varchar(50)  |  | | |   |
select,insert,update,references |
| ordernotes | varchar(100) |  | | |   |
select,insert,update,references |
| websiteinfo| varchar(100) |  | | |   |
select,insert,update,references |
| rfe1   | varchar(100) |  | | |   |
select,insert,update,references |
| rfe2   | varchar(100) |  | | |   |
select,insert,update,references |
| rfeval1| varchar(100) |  | | |   |
select,insert,update,references |
| rfeval2| varchar(100) |  | | |   |
select,insert,update,references |
| weight | int(10) unsigned |  | | 0   |   |
select,insert,update,references |
| oemtext| varchar(100) |  | | |   |
select,insert,update,references |
++--+--+

Oops!!

[Scott Dunn]

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 record in
and forgets the rest. What are some things that I can look for to see what
is wrong. Could it be that I made all fields not null and there are some
empty? If you need more info just ask!!!

Thanks,
Scott


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

changed column type

[Scott Dunn]

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 or do I have to totally
delete the column and readd it

Thanks,
Scott


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

yes/no

[Scott Dunn]

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 needing?

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

yes/no

[Scott Dunn]

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.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php