Maximum length of INSERT... string in .sql file

[ChrisRChamberlain]

Hi all

If you use code in the style of

INSERT INTO 'tablename' ('TOWN','COUNTY','POSTCODE') VALUES
[tab]('Arundel',West Sussex','AR'),
[tab]('Stroud','Glos','GL'),
[tab]...
[tab]...
[tab]('Wells','Somerset','WE');

in a .sql file to populate a table, what limits are there, if any, on the length of the string and therefore the number of records that can be inserted?

TIA

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[TonyGroves]

There's no limit. That's exactly the format used by mysqldump to dump whole databases.

 

[ChrisRChamberlain]

TonyGroves

Thanks for the confirmation.

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[TonyGroves]

Correction, it's not "exactly the format ...". Those quotes around table and field names should be replaced with `backticks`.

 

[ChrisRChamberlain]

TonyGroves

What's the significance of the `backticks` as opposed to ' ' ?

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[Bastien]

Backticks allow the use of not quite acceptable table/field names. ie the use of reserved words like DATE.

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[ChrisRChamberlain]

If I understand it correctly now backticks would only be used to surround table and field names?

INSERT INTO `tablename` (`TOWN`,`COUNTY`,`POSTCODE`) VALUES
    ('Arundel',West Sussex','AR'),
    ('Stroud','Glos','GL'),
    ...
    ...
    ('Wells','Somerset','WE');

TIA

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[TonyGroves]

Correct, and they're only needed if the name would be illegal otherwise. In the example given, they're not needed at all.

 

[ChrisRChamberlain]

TonyGroves, Bastien

Thanks - as a 'catchall', the backticks will be included in the application that creates the .sql file.

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com