If both tables are truly the same schema: INSERT INTO newTable SELECT * FROM oldTable Otherwise, you’ll have to specify the column names (the column list for newTable is optional if you are specifying a value for all columns and selecting columns in the same order as newTable‘s schema): INSERT INTO newTable (col1, col2, col3) … Read more
From the mysql console: mysql> use DATABASE_NAME; mysql> source path/to/file.sql; make sure there is no slash before path if you are referring to a relative path… it took me a while to realize that! lol
SQL Server does simple counting of cascade paths and, rather than trying to work out whether any cycles actually exist, it assumes the worst and refuses to create the referential actions (CASCADE): you can and should still create the constraints without the referential actions. If you can’t alter your design (or doing so would compromise … Read more
To alias the table you’d have to say: DELETE f FROM dbo.foods AS f WHERE f.name IN (…); I fail to see the point of aliasing for this specific DELETE statement, especially since (at least IIRC) this no longer conforms to strict ANSI. But yes, as comments suggest, it may be necessary for other query … Read more
With string type columns like character(2) (as you mentioned later), the displayed concatenation just works because, quoting the manual: […] the string concatenation operator (||) accepts non-string input, so long as at least one input is of a string type, as shown in Table 9.8. For other cases, insert an explicit coercion to text […] … Read more
This is significantly faster than the EXISTS way: SELECT [EmailAddress], [CustomerName] FROM [Customers] WHERE [EmailAddress] IN (SELECT [EmailAddress] FROM [Customers] GROUP BY [EmailAddress] HAVING COUNT(*) > 1)
change database collation: ALTER DATABASE <database_name> CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; change table collation: ALTER TABLE <table_name> CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; change column collation: ALTER TABLE <table_name> MODIFY <column_name> VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; What do the parts of utf8mb4_0900_ai_ci mean? 3 bytes — utf8 4 bytes — utf8mb4 (new) v4.0 … Read more
SET XACT_ABORT ON instructs SQL Server to rollback the entire transaction and abort the batch when a run-time error occurs. It covers you in cases like a command timeout occurring on the client application rather than within SQL Server itself (which isn’t covered by the default XACT_ABORT OFF setting.) Since a query timeout will leave … Read more
You could try setting the database to single user mode. https://stackoverflow.com/a/11624/2408095 use master ALTER DATABASE BOSEVIKRAM SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE BOSEVIKRAM MODIFY NAME = [BOSEVIKRAM_Deleted] ALTER DATABASE BOSEVIKRAM_Deleted SET MULTI_USER
Rows per a table won’t be an issue on it’s own. So roughly speaking 1 million rows a day for 90 days is 90 million rows. I see no reason Postgres can’t deal with that, without knowing all the details of what you are doing. Depending on your data distribution you can use a mixture … Read more