Try to run either SELECT USER(); or SELECT CURRENT_USER(); It can sometimes be different, USER() will return by which login you attempted to authenticate and CURRENT_USER() will return how you were actually allowed to authenticate.
See the docs FAQ: “How can I see the raw SQL queries Django is running?” django.db.connection.queries contains a list of the SQL queries: from django.db import connection print(connection.queries) Querysets also have a query attribute containing the query to be executed: print(MyModel.objects.filter(name=”my name”).query) Note that the output of the query is not valid SQL, because: “Django … Read more
You can use this approach to get the data from all the columns except one:- Insert all the data into a temporary table Then drop the column which you dont want from the temporary table Fetch the data from the temporary table(This will not contain the data of the removed column) Drop the temporary table … Read more
From a sqlite prompt: sqlite> .read db.sql Or: cat db.sql | sqlite3 database.db Also, your SQL is invalid – you need ; on the end of your statements: create table server(name varchar(50),ipaddress varchar(15),id init); create table client(name varchar(50),ipaddress varchar(15),id init);
You’re not saying what you wish to do with the dumped file. To get a CSV file (which can be imported into almost everything) .mode csv — use ‘.separator SOME_STRING’ for something other than a comma. .headers on .out file.csv select * from MyTable; To get an SQL file (which can be reinserted into a … Read more
SQLite requires dates to be in YYYY-MM-DD format. Since the data in your database and the string in your query isn’t in that format, it is probably treating your “dates” as strings.
Here is my take on it. select * from ( SELECT id, ROW_NUMBER() OVER(PARTITION BY merchant_Id, url ORDER BY id asc) AS Row FROM Photos ) dups where dups.Row > 1 Feel free to play with the order by to tailor the records you want to delete to your specification. SQL Fiddle => http://sqlfiddle.com/#!15/d6941/1/0 SQL … Read more
Here, give this a shot (this is just a pseudocode) using System; using System.Data; using System.Data.SqlClient; public class PullDataTest { // your data table private DataTable dataTable = new DataTable(); // your method to pull data from database to datatable public void PullData() { string connString = @”your connection string here”; string query = “select … Read more
Use array_agg: http://www.sqlfiddle.com/#!1/5099e/1 SELECT s.name, array_agg(g.Mark) as marks FROM student s LEFT JOIN Grade g ON g.Student_id = s.Id GROUP BY s.Id By the way, if you are using Postgres 9.1, you don’t need to repeat the columns on SELECT to GROUP BY, e.g. you don’t need to repeat the student name on GROUP BY. … Read more