Just add in the &#39;0&#39; in your select.

    INSERT INTO table_name (a,b,c,d)
        SELECT
           other_table.a AS a,
           other_table.b AS b,
           other_table.c AS c,
           &#39;0&#39; AS d
        FROM other_table


Put 0 as default in SQL or add 0 into your area of table

just select &#39;0&#39; as the value for the desired column

I recently coded an Android app. It&#39;s just a simple app that allows you to keep score of a basketball game with a few simple counter intervals. I&#39;m getting demand to add a save feature, so you can save your scores and then load them back up.  Currently, when you stop the app, your data is lost.  So what I was wondering is what I would have to add to have the app save a label (score) and then load it back up.  Thanks guys sorry I don&#39;t know much about this stuff.

How to save data in an android app

It is possible to run an external command by three PHP functions of

    system();
    exec();
    shell_exec();

but what are their differences? In spite of their specific applications, in most cases, the can be equally used. I am curious to know which is preferred one when they can be equally used. For example, for unzipping a file or compressing a folder (with tar command), which one is preferred (probably from performance point of view)?

**UPDATE:** In another question, I found a very useful **[link][1]** describing different aspects for these functions. I share the link here, as other may use to better understand security issues and other aspects.


  [1]: http://web.archive.org/web/20130809032648/http://chipmunkninja.com/Program-Execution-in-PHP%3A-exec-m@

What are the differences of system(), exec() and shell_exec() in PHP?

I want to insert to a table from a select statement, however, there are 3 columns returned from the select statement and the table has 4 columns, I would like to add 0 for all rows in the extra column. Can anyone give me a sample SQL query for that?

Thank you!

Oracle insert from select into table with more columns

<p>I want to insert to a table from a select statement, however, there are 3 columns returned from the select statement and the table has 4 columns, I would like to add 0 for all rows in the extra column. Can anyone give me a sample SQL query for that?</p>
<p>Thank you!</p>


I am using a query to alter the charset of a column


    ALTER TABLE `media_value_report` 
        CHANGE `index_page_body` `index_page_body` TEXT CHARACTER  
        SET utf8 NULL DEFAULT NULL

i want to do this for other columns  main_title, landing_page_body as well. But am getting a #1064 error while executing. Can i alter-change multiple columns in  a single query?

I tried but i found in goog search that is not possible to alter in a single query. 



Alter multiple columns in a single statement

I&#39;m getting error:


&gt;Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation &#39;=&#39;&quot;

I tried changing both tables manually to `utf8_general_ci,IMPLICIT` but I&#39;m still getting the error.

Is there a way to convert all tables to `utf8_general_ci,IMPLICIT` and be done with it?

How to convert all tables in database to one collation?

I have a .`sql` file. I am trying to pass connection string details through a Powershell script and invoke an `.sql` file.

I was searching and came up with a cmdlet related to `Invoke-sqlcmd`. While I was trying to find a module corresponding to SQL, I did not find any one in my machine.

Should I install anything in my machine (the machine already has SQL Server Management Studio 2008 R2) to get the modules or is there any easy way to execute `.sql` files using Powershell?

How to execute .sql file using powershell?

I have statements like this that are timing out:

    DELETE FROM [table] WHERE [COL] IN ( &#39;1&#39;, &#39;2&#39;, &#39;6&#39;, &#39;12&#39;, &#39;24&#39;, &#39;7&#39;, &#39;3&#39;, &#39;5&#39;)

I tried doing one at a time like this:

    DELETE FROM [table] WHERE [COL] IN ( &#39;1&#39; )

and so far it&#39;s at 22 minutes and still going. 

The table has 260,000 rows in it and is four columns.

Does anyone have any ideas why this would be so slow and how to speed it up?
I do have a non-unique, non-clustered index on the [COL] that i&#39;m doing the WHERE on.
I&#39;m using SQL Server 2008 R2


update: I have no triggers on the table.


Delete statement in SQL is very slow

I have a SQL Server 2008 R2 column containing a string which I need to split by a comma. I have seen many answers on StackOverflow but none of them works in R2. I have made sure I have select permissions on any split function examples. Any help greatly appreciated.

T-SQL split string

Can anyone tell me how I can generate the DDL for all tables, views, indexes, packages, procedures, functions, triggers, types, sequences, synonyms, grants, etc. inside an Oracle schema? Ideally, I would like to copy the rows too but that is less important.

I want to do this on a scheduled job of some kind and not manually each time, so that rules out using the wizard in SQL Developer.

Ideally, since I will be running this on several schemas that have grants and synonyms to one another, I would like to have a way to do a find/replace in the output so the schema names match whatever the names of my new schemas are going to be.

Thanks!

How to generate entire DDL of an Oracle schema (scriptable)?

What is the difference between non-repeatable read and phantom read?

I have read the [Isolation (database systems) article from Wikipedia](http://en.wikipedia.org/wiki/Isolation_(database_systems)), but I have a few doubts. In the below example, what will happen: the **non-repeatable read** and **phantom read**?

####**Transaction A**

    SELECT ID, USERNAME, accountno, amount FROM USERS WHERE ID=1

####**OUTPUT:**

    1----MIKE------29019892---------5000

####**Transaction B**

    UPDATE USERS SET amount=amount+5000 where ID=1 AND accountno=29019892;
    COMMIT;

####**Transaction A**

    SELECT ID, USERNAME, accountno, amount FROM USERS WHERE ID=1

Another doubt is, in the above example, which isolation level should be used? And why?

What is the difference between Non-Repeatable Read and Phantom Read?

What&#39;s the difference between `RANK()` and `DENSE_RANK()` functions? How to find out nth salary in the following `emptbl` table?

    DEPTNO	EMPNAME	   SAL
    ------------------------------
    10	     rrr	10000.00
    11	     nnn	20000.00
    11	     mmm	5000.00
    12	     kkk	30000.00
    10	     fff	40000.00
    10	     ddd	40000.00
    10	     bbb	50000.00
    10	     ccc	50000.00



If in the table data having `nulls`, what will happen if I want to find out `nth` salary?







What&#39;s the difference between RANK() and DENSE_RANK() functions in oracle?

It appears that there is no concept of AUTO_INCREMENT in Oracle, up until and including version 11g.

How can I create a column that behaves like auto increment in Oracle 11g?


How to create id with AUTO_INCREMENT on Oracle?

I am using Oracle 11g for my web application. I want to add a column and a comment to an existing table. I can do that easily with the below commands

    ALTER TABLE product ADD product_description VARCHAR2(20)
and 

    COMMENT ON COLUMN product.product_description 
         IS &#39;This is comment for the column&#39;;

But I want to do above task in single command. I searched on internet for a command to add a column and comment in a single command but I couldn&#39;t find. I wonder if this is possible. Any suggestions would be highly appreciated.

Content Type	Original Author	Original Content on Stackoverflow
Question	Alan Han	View Question on Stackoverflow
Solution 1 - Sql	Matt Dodge	View Answer on Stackoverflow
Solution 2 - Sql	Andrew	View Answer on Stackoverflow
Solution 3 - Sql	Otávio Décio	View Answer on Stackoverflow

Oracle insert from select into table with more columns

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

What are the differences of system(), exec() and shell_exec() in PHP?

How to save data in an android app

Attributions