How do I run an update and select statements on the same queryset rather than having to do two queries: – one to select the object – and one to update the object The equivalent in SQL would be something like: update my_table set field_1 = ‘some value’ where pk_field = some_value 7 Answers 7
I have a user-defined table type. I want to check it’s existence before editing in a patch using OBJECT_ID(name, type) function. What type from the enumeration should be passed for user-defined table types? N’U’ like for user defined table doesn’t work, i.e. IF OBJECT_ID(N’MyType’, N’U’) IS NOT NULL 5 Answers 5
I’m trying to restore my dump file, but it caused an error: psql:psit.sql:27485: invalid command \N Is there a solution? I searched, but I didn’t get a clear answer. 16 Answers 16
I have two string columns a and b in a table foo. select a, b from foo returns values a and b. However, concatenation of a and b does not work. I tried : select a || b from foo and select a||’, ‘||b from foo Update from comments: both columns are type character(2). 8 … Read more
I am trying to get some data from WordPress database tables in a plugin. For that, I am using the below code… global $wpdb; $findID = $wpdb->get_var(“SELECT ID FROM wp_posts WHERE post_name=”hello-world””); echo $findID; But it not giving me the post ID in echo? Is there anything wrong…??? 2 Answers 2 Just to clarify the … Read more
In PostgreSQL, I can do something like this: ALTER SEQUENCE serial RESTART WITH 0; Is there an Oracle equivalent? 18 Answers 18
What is the simplest SQL query to find the second largest integer value in a specific column? There are maybe duplicate values in the column. 46 Answers 46 SELECT MAX( col ) FROM table WHERE col < ( SELECT MAX( col ) FROM table )
I’m converting a db from postgres to mysql. Since i cannot find a tool that does the trick itself, i’m going to convert all postgres sequences to autoincrement ids in mysql with autoincrement value. So, how can i list all sequences in a Postgres DB (8.1 version) with information about the table in which it’s … Read more
I have a constraint called users.SYS_C00381400. How do I find what that constraint is? Is there a way to query all constraints? 3 Answers 3
I’m looking to be able to run a single query on a remote server in a scripted task. For example, intuitively, I would imagine it would go something like: mysql -uroot -p -hslavedb.mydomain.com mydb_production “select * from users;” 7 Answers 7
