Hello,

Newbie alert etc.

I am importing test data into mysql. In the table that I am importing to
the keyfield is an auto incrementing field.

Now in my excel spreadsheet I have this data filled in and ready to import.

My question is....do I import into the key field or just the other fields?
If I leave the key filed out is mysql smart enough to fill in the key field?

Thanks,

td.

all you can find here:
http://www.plsgoogleit.com/

Great thanks! That helps alot! Not.

However. Your answer undermines usenet for what it is, an excellent place
where users can get answers to queries.

You have basically said that this newsgroup should not be used to ask on
topic questions.

Maybe if I had posted some p*orn links, that would have been better
received.

td.


"toedipper" <send_rubbish_here734 [at] hotmail.com> wrote in message
news:325t3nF3hrdrvU1 [at] individual.net...
> Hello,
>
> Newbie alert etc.
>
> I am importing test data into mysql. In the table that I am importing to
> the keyfield is an auto incrementing field.
>
> Now in my excel spreadsheet I have this data filled in and ready to
> import.
>
> My question is....do I import into the key field or just the other fields?
> If I leave the key filed out is mysql smart enough to fill in the key
> field?
>
> Thanks,
>
> td.
>
>
>

toedipper wrote:
> Hello,
>
> Newbie alert etc.
>
> I am importing test data into mysql. In the table that I am importing to
> the keyfield is an auto incrementing field.
>
> Now in my excel spreadsheet I have this data filled in and ready to import.
>
> My question is....do I import into the key field or just the other fields?
> If I leave the key filed out is mysql smart enough to fill in the key field?
>
> Thanks,
>
> td.
>
>
>

MySQL will generate the value for the column if the column has
auto_increment set.

My suggestion would be to just create a test database and.. test, you'll
learn quickly what is, and is not possible.

Anthony.

Thanks Anthony.

td.


"Anthony Plunkett" <doobeh [at] thefort.org> wrote in message
news:41bf3ebc$0$24884$afc38c87 [at] news.easynet.co.uk...
> toedipper wrote:
>> Hello,
>>
>> Newbie alert etc.
>>
>> I am importing test data into mysql. In the table that I am importing to
>> the keyfield is an auto incrementing field.
>>
>> Now in my excel spreadsheet I have this data filled in and ready to
>> import.
>>
>> My question is....do I import into the key field or just the other
>> fields? If I leave the key filed out is mysql smart enough to fill in the
>> key field?
>>
>> Thanks,
>>
>> td.
>>
>>
>>
>
> MySQL will generate the value for the column if the column has
> auto_increment set.
>
> My suggestion would be to just create a test database and.. test, you'll
> learn quickly what is, and is not possible.
>
> Anthony.

Download a program called navicat

That will automate the import

toedipper wrote:
> Thanks Anthony.
>
> td.
>
>
> "Anthony Plunkett" <doobeh [at] thefort.org> wrote in message
> news:41bf3ebc$0$24884$afc38c87 [at] news.easynet.co.uk...
>
>>toedipper wrote:
>>
>>>Hello,
>>>
>>>Newbie alert etc.
>>>
>>>I am importing test data into mysql. In the table that I am importing to
>>>the keyfield is an auto incrementing field.
>>>
>>>Now in my excel spreadsheet I have this data filled in and ready to
>>>import.
>>>
>>>My question is....do I import into the key field or just the other
>>>fields? If I leave the key filed out is mysql smart enough to fill in the
>>>key field?
>>>
>>>Thanks,
>>>
>>>td.
>>>
>>>
>>>
>>
>>MySQL will generate the value for the column if the column has
>>auto_increment set.
>>
>>My suggestion would be to just create a test database and.. test, you'll
>>learn quickly what is, and is not possible.
>>
>>Anthony.
>
>
>