You could do:

    create table bookmark1 as select * from bookmark;

You can try this query:

    insert into bookmark1 select * from bookmark

I assume that bookmark1 is a new table that you have created which is same as the bookmark table. In that case you can use the following format.

    CREATE TABLE bookmark1 AS SELECT * FROM bookmark;

Or you can also use the insert statement with subquery. For different insert statement options refer: [SQL As Understood By SQLite][1]


  [1]: http://www.sqlite.org/lang_insert.html


    create table NewTable as
    select * from OldTable where 1 &lt;&gt; 1

This will copy data structure for you.

BUT be carefull: &quot;create table&quot; from the other in such a way is not saving Data Types of new table&#39;s fields as so as they were in the source table, therefore I would prefer to &quot;create table&quot; with a separate statement &amp; &quot;insert into&quot; statement also to do separately - as was mentioned above: 

    insert into bookmark_backup select * from bookmark;&quot;

I have django code that interacts with request objects or user objects. For instance something like:

    foo_model_instance = models.get_or_create_foo_from_user(request.user)

If you were going to test with the django python shell or in a unittest, what would you pass in there? Here simply a User object will do, but the need for a mock request object also comes up frequently.

For the shell or for unittests:

 - How do you mock users?
 - How do you mock requests?


How to mock users and requests in django

Is there any recommended coding style how to write PowerShell scripts?

It&#39;s **not** about how to structure the code (how many functions, if to use module, ...). It&#39;s about &#39;**how to write the code so that it is readable**&#39;.

In programming languages there are some **recommended coding styles** (what to *indent*, how to indent - spaces/tabs, where to make *new line*, where to put *braces*,...), but I haven&#39;t seen any suggestion for PowerShell.

I&#39;m interested particularly in:

----------

**How to write parameters**

    function New-XYZItem
      ( [string] $ItemName
      , [scriptblock] $definition
      ) { ...

(I see that it&#39;s more like &#39;V1&#39; syntax)

or

    function New-PSClass  {
      param([string] $ClassName
           ,[scriptblock] $definition
      )...

or (why to add empty attribute?)

    function New-PSClass  {
      param([Parameter()][string] $ClassName
           ,[Parameter()][scriptblock] $definition
      )...

or (other formatting I saw maybe in Jaykul&#39;s code)

    function New-PSClass {
      param(
            [Parameter()]
            [string]
            $ClassName
            ,
            [Parameter()]
            [scriptblock]
            $definition
      )...

or ...?

----------

**How to write a complex pipeline**

    Get-SomeData -param1 abc -param2 xyz | % {
        $temp1 = $_
        1..100 | % {
          Process-somehow $temp1 $_
        }
      } | % {
        Process-Again $_
      } |
      Sort-Object -desc

or (name of cmdlet on new line)

    Get-SomeData -param1 abc -param2 xyz |
      % {
        $temp1 = $_
        1..100 |
          % {
            Process-somehow $temp1 $_
          }
      } |
      % {
        Process-Again $_
      } |
      Sort-Object -desc |

And what if there are `-begin`, `-process`, and `-end` parameters? How do I make it the most readable?

    Get-SomeData -param1 abc -param2 xyz |
      % -begin {
         init
      } -process {
         Process-somehow2 ...
      } -end {
         Process-somehow3 ...
      } |
      % -begin {
      } ....

or

    Get-SomeData -param1 abc -param2 xyz |
      %  `
        -begin {
          init
        } `
        -process {
          Process-somehow2 ...
        } `
        -end {
          Process-somehow3 ...
        } |
      % -begin {
      } ....

The indentation is important here and what element is put on new line as well.

----------

I have covered only questions that come on my mind very frequently. There are some others, but I&#39;d like to keep this Stack&amp;nbsp;Overflow question &#39;short&#39;.

**Any other suggestions are welcome.**


What is the recommended coding style for PowerShell?

I&#39;m not sure if I can use select into to import data from another table like this:

    select * into
      bookmark1 
    from bookmark;    

Is it true that SQlite doesn&#39;t support this syntax? are there any other alternatives?

SQlite: select into?

I'm not sure if I can use select into to import data from another table like this:
<pre><code class="hljs language-csharp">select * into
 bookmark1 
from bookmark; 
</code></pre>
Is it true that SQlite doesn't support this syntax? are there any other alternatives?

Is there a command in Microsoft SQL Server T-SQL to tell the script to stop processing?
I have a script that I want to keep for archival purposes, but I don&#39;t want anyone to run it.


T-SQL STOP or ABORT command in SQL Server

Can anyone explain what is the exact difference between stored procedures and user defined functions, and in which context each is useful?

Difference between stored procedures and user defined functions

I&#39;ll use a concrete, but hypothetical, example.

Each **Order** normally has only one **line item**:

**Orders:**

&lt;!-- language: lang-none --&gt;

    OrderGUID   OrderNumber
    =========   ============
    {FFB2...}   STL-7442-1      
    {3EC6...}   MPT-9931-8A

**LineItems:**

&lt;!-- language: lang-none --&gt;

    LineItemGUID   Order ID Quantity   Description
    ============   ======== ========   =================================
    {098FBE3...}   1        7          prefabulated amulite
    {1609B09...}   2        32         spurving bearing

But occasionally there will be an order with two line items:

&lt;!-- language: lang-none --&gt;

    LineItemID   Order ID    Quantity   Description
    ==========   ========    ========   =================================
    {A58A1...}   6,784,329   5          pentametric fan
    {0E9BC...}   6,784,329   5          differential girdlespring 

Normally when showing the orders to the user:

&lt;!-- language: lang-sql--&gt;

    SELECT Orders.OrderNumber, LineItems.Quantity, LineItems.Description
    FROM Orders
        INNER JOIN LineItems 
        ON Orders.OrderID = LineItems.OrderID

I want to show the single item on the order. But with this occasional order containing two (or more) items, the orders would *appear* be **duplicated**:

&lt;!-- language: lang-none --&gt;

    OrderNumber   Quantity   Description
    ===========   ========   ====================
    STL-7442-1    7          prefabulated amulite
    MPT-9931-8A   32         spurving bearing
    KSG-0619-81   5          panametric fan
    KSG-0619-81   5          differential girdlespring

What I really want is to have SQL Server *just pick one*, as it will be *good enough*:

&lt;!-- language: lang-none --&gt;

    OrderNumber   Quantity   Description
    ===========   ========   ====================
    STL-7442-1    7          prefabulated amulite
    MPT-9931-8A   32         differential girdlespring
    KSG-0619-81   5          panametric fan

If I get adventurous, I might show the user, an ellipsis to indicate that there&#39;s more than one:

&lt;!-- language: lang-none --&gt;

    OrderNumber   Quantity   Description
    ===========   ========   ====================
    STL-7442-1    7          prefabulated amulite
    MPT-9931-8A   32         differential girdlespring
    KSG-0619-81   5          panametric fan, ...

So the question is how to either
 
 - eliminate &quot;duplicate&quot; rows
 - only join to one of the rows, to avoid duplication


## First attempt ##
My first naive attempt was to only join to the &quot;**TOP 1**&quot; line items:

&lt;!-- language: lang-sql --&gt;

    SELECT Orders.OrderNumber, LineItems.Quantity, LineItems.Description
    FROM Orders
        INNER JOIN (
           SELECT TOP 1 LineItems.Quantity, LineItems.Description
           FROM LineItems
           WHERE LineItems.OrderID = Orders.OrderID) LineItems2
        ON 1=1

But that gives the error:

&gt; The column or prefix &#39;Orders&#39; does not  
&gt; match with a table name or alias name  
&gt; used in the query.  

Presumably because the inner select doesn&#39;t see the outer table.


How to Join to first row

I want to update two tables in one go. How do I do that in SQL Server 2005?

    UPDATE 
      Table1, 
      Table2
    SET 
      Table1.LastName=&#39;DR. XXXXXX&#39;, 
      Table2.WAprrs=&#39;start,stop&#39;
    FROM 
      Table1 T1, 
      Table2 T2
    WHERE 
      T1.id = T2.id
    AND 
      T1.id = &#39;010008&#39;

How to update two tables in one statement in SQL Server 2005?

I am attempting to merge something like this in my SQL Server database:

&lt;pre&gt;[TicketID], [Person]
 T0001       Alice
 T0001       Bob
 T0002       Catherine
 T0002       Doug
 T0003       Elaine&lt;/pre&gt;

Into this:

&lt;pre&gt;[TicketID], [People]
 T0001       Alice, Bob
 T0002       Catherine, Doug
 T0003       Elaine&lt;/pre&gt;

I need to do this in both SQL Server and Oracle.

I have found the function `GROUP_CONCAT` for MySQL that does exactly what I need here, but MySQL is not an option here.

**EDIT:** Test bench:

    DECLARE @Tickets TABLE (
        [TicketID] char(5) NOT NULL,
        [Person] nvarchar(15) NOT NULL
    )
    
    INSERT INTO @Tickets VALUES
        (&#39;T0001&#39;, &#39;Alice&#39;),
        (&#39;T0001&#39;, &#39;Bob&#39;),
        (&#39;T0002&#39;, &#39;Catherine&#39;),
        (&#39;T0002&#39;, &#39;Doug&#39;),
        (&#39;T0003&#39;, &#39;Elaine&#39;)
    
    SELECT * FROM @Tickets

Can I Comma Delimit Multiple Rows Into One Column?

I have .sql files which have the following content:

    #cat db.sql
    create table server(name varchar(50),ipaddress varchar(15),id init)
    create table client(name varchar(50),ipaddress varchar(15),id init)

How do I import this file into SQLite so that these are created automatically?



How do I import .sql files into SQLite 3?

I&#39;m pretty new to SQLite 3 and just now I had to add a column to an existing table I had. I went about doing that by doing: `ALTER TABLE thetable ADD COLUMN category;`.

Of course, I forgot to specify that column&#39;s type. The first thing I was thinking about doing was dropping that column and then re-adding it. However, it seems that SQLite does not have a simple way of doing this, and I would have had to backup the table and re-create it without the column.

This seems messy, and I was wondering if there were just a way of modifying/adding a column&#39;s type. I would imagine so, but my searching around yielded no results, being new to SQLite, I imagine it was due to my wording being off in the query.

Modify a Column&#39;s Type in sqlite3

I have a list that has 3 rows each representing a table row:

    &gt;&gt;&gt; print list
    [laks,444,M]
    [kam,445,M]
    [kam,445,M]

How to insert this list into a table?

My table structure is:

&lt;pre&gt;
tablename(name varchar[100], age int, sex char[1])
&lt;/pre&gt;

Or should I use something other than list?

Here is the actual code part:


        for record in self.server:
            print &quot;---&gt;&quot;,record
            t=record
            self.cursor.execute(&quot;insert into server(server) values (?)&quot;,(t[0],));
            self.cursor.execute(&quot;insert into server(id) values (?)&quot;,(t[1],))
            self.cursor.execute(&quot;insert into server(status) values (?)&quot;,(t[2],));

Inserting the three fields separately works, but using a single line like

`self.cursor.execute(&quot;insert into server(server,c_id,status) values (?,?,?)&quot;,(t[0],),(t[1],),(t[2],))`

or

`self.cursor.execute(&quot;insert into server(server,c_id,status) values (?,?,?)&quot;,(t),)`

does not.


Python and SQLite: insert into table

Using Linux, I want to compare two SQLite databases that have the same schema.
There will be just a few differences.

Is there a tool that would output these differences?
Preferably output them to the command line, so that I can grep/sed them.

SQLite uses SQL, so a general SQL tool might also do.

How to compare two SQLite databases on Linux

Can you create functions in SQLite like you can in MSSQL?

If so, how? What is the syntax?

Thanks

Content Type	Original Author	Original Content on Stackoverflow
Question	Glaucon	View Question on Stackoverflow
Solution 1 - Sql	vit	View Answer on Stackoverflow
Solution 2 - Sql	Nick Dandoulakis	View Answer on Stackoverflow
Solution 3 - Sql	neo	View Answer on Stackoverflow
Solution 4 - Sql	Wadood Chaudhary	View Answer on Stackoverflow
Solution 5 - Sql	JeeyCi	View Answer on Stackoverflow

SQlite: select into?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Solution 4 - Sql

Solution 5 - Sql

What is the recommended coding style for PowerShell?

How to mock users and requests in django

Attributions