Member Avatar for ROTC89

ok so i created a database and made a table that i inserted data into it. i would like to know how would i be able to put the extension .sql at the end of my table?

  • 3 Contributors
  • 2 Replies
  • 108 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Kailash12

Dani AI

Generated

If by "put the extension .sql at the end of my table" you mean the literal table name should include ".sql", that is possible but unusual. raised the idea of changing the name — rather than recreating the table you can rename it. The key point is that a plain dot is normally the database/table separator in SQL, so to embed a dot you must quote the identifier.

Examples (use backticks in MySQL):

RENAME TABLE `old_table` TO `table.sql`;

or

ALTER TABLE `old_table` RENAME TO `table.sql`;

You can also create a table whose name contains a dot:

CREATE TABLE `table.sql` (
  id INT PRIMARY KEY
);

Notes and cautions:

  • Unquoted identifiers treat the dot as a qualifier (database.table). Quoting with backticks makes the dot part of the name. If you use ANSI_QUOTES mode, double quotes behave differently, so backticks are the safe choice in MySQL.
  • Using punctuation in object names forces quoting everywhere in SQL and can break tools, ORMs, admin UIs, or scripts that expect simple names. It reduces portability to other RDBMS and can make maintenance harder.
  • Consider whether the semantic meaning of ".sql" belongs in a filename (export/dump) rather than in an object name. Changing a table name is straightforward, but embedding file-like extensions in schema names is generally discouraged.

For MySQL identifier rules and the RENAME TABLE statement, see the MySQL reference on identifiers and renaming:
Identifiers (MySQL manual)
RENAME TABLE (MySQL manual)

Recommended Answers

All 2 Replies

Member Avatar for Menster

Hi there,
Do you mean you want to append ".sql" to the table name? If thats the case I have no idea short of recreating the table with the adjusted name. But why would you want this?

Member Avatar for Kailash12

.sql file is created whenever you create MySQL dump (MySQL database backup) for your database.

Kailash

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.