Dapper supports this directly. For example… string sql = “SELECT * FROM SomeTable WHERE id IN @ids” var results = conn.Query(sql, new { ids = new[] { 1, 2, 3, 4, 5 }}); unless you are using Postgres, in which case see this answer
The parentheses are misplaced: SELECT setval(‘payments_id_seq’, 21, true); — next value will be 22 Otherwise you’re calling setval with a single argument, while it requires two or three. This is the same as SELECT setval(‘payments_id_seq’, 21)
To turn it off: old_logger = ActiveRecord::Base.logger ActiveRecord::Base.logger = nil To turn it back on: ActiveRecord::Base.logger = old_logger
The basic idea will be using a nested query with count aggregation: select * from yourTable ou where (select count(*) from yourTable inr where inr.sid = ou.sid) > 1 You can adjust the where clause in the inner query to narrow the search. There is another good solution for that mentioned in the comments, (but … Read more
Documentation says: DISTINCT ON ( expression [, …] ) keeps only the first row of each set of rows where the given expressions evaluate to equal. […] Note that the “first row” of each set is unpredictable unless ORDER BY is used to ensure that the desired row appears first. […] The DISTINCT ON expression(s) … Read more
Just use a where clause that won’t select any rows: create table xyz_new as select * from xyz where 1=0; Limitations The following things will not be copied to the new table: sequences triggers indexes some constraints may not be copied materialized view logs This also does not handle partitions
Try this command: ALTER TABLE your_table ADD COLUMN key_column BIGSERIAL PRIMARY KEY; Try it with the same DB-user as the one you have created the table.
Go into Tools -> Options -> Designers-> Uncheck “Prevent saving changes that require table re-creation”. Voila. That happens because sometimes it is necessary to drop and recreate a table in order to change something. This can take a while, since all data must be copied to a temp table and then re-inserted in the new … Read more
The following SQL will get you the row count of all tables in a database: CREATE TABLE #counts ( table_name varchar(255), row_count int ) EXEC sp_MSForEachTable @command1=’INSERT #counts (table_name, row_count) SELECT ”?”, COUNT(*) FROM ?’ SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESC DROP TABLE #counts The output will be a list of … Read more
Run this SQL statement (in the MySQL client, phpMyAdmin, or wherever) to retrieve all the MyISAM tables in your database. Replace value of the name_of_your_db variable with your database name. SET @DATABASE_NAME = ‘name_of_your_db’; SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` ENGINE=InnoDB;’) AS sql_statements FROM information_schema.tables AS tb WHERE table_schema = @DATABASE_NAME AND `ENGINE` = ‘MyISAM’ … Read more