    ALTER TABLE emp MODIFY COLUMN name VARCHAR(100);

Or use CHANGE, but that means you have to give the column name twice (because CHANGE allows you to change the name of the column too).

    ALTER TABLE emp CHANGE COLUMN name name VARCHAR(100);

Don&#39;t put the column name in single-quotes. Single-quotes are for string literals or date literals.

The script below displays a shop cart using `ng-repeat`. For each element in the array, it shows the item name, its amount and the subtotal (`product.price * product.quantity`).

What is the simplest way for calculating the total price of repeated elements?

    &lt;table&gt;

		&lt;tr&gt;
			&lt;th&gt;Product&lt;/th&gt;
			&lt;th&gt;Quantity&lt;/th&gt;
			&lt;th&gt;Price&lt;/th&gt;
		&lt;/tr&gt;

		&lt;tr ng-repeat=&quot;product in cart.products&quot;&gt;
			&lt;td&gt;{{product.name}}&lt;/td&gt;
			&lt;td&gt;{{product.quantity}}&lt;/td&gt;
			&lt;td&gt;{{product.price * product.quantity}} €&lt;/td&gt;
		&lt;/tr&gt;

		&lt;tr&gt;
			&lt;td&gt;&lt;/td&gt;
			&lt;td&gt;Total :&lt;/td&gt;
			&lt;td&gt;&lt;/td&gt; &lt;!-- Here is the total value of my cart --&gt;
		&lt;/tr&gt;

    &lt;/table&gt;


Calculating sum of repeated elements in AngularJS ng-repeat

I am using Gradle to build my Android application. I am trying to use some flags based on the build type (release or debug).

My Gradle file looks like this:

    android {
        buildTypes {
            debug {
                buildConfigField &#39;boolean&#39;, &#39;PREPROD&#39;, &#39;true&#39;
                buildConfigField &#39;boolean&#39;, &#39;STAGING&#39;, &#39;false&#39;
            }

            release {
                buildConfigField &#39;boolean&#39;, &#39;PREPROD&#39;, &#39;false&#39;
                buildConfigField &#39;boolean&#39;, &#39;STAGING&#39;, &#39;false&#39;
            }
        }
    }

And if I try to call `BuildConfig.PREPROD` or `BuildConfig.STAGING` I get a &quot;Cannot resolve symbol&quot; error.
The Gradle sync was successful, so I don&#39;t know if I forgot some steps in order to be able to use this feature?

The generated `BuildConfig.java` file is the following (in `build/source/buildConfig/debug/com.example.myapp`):

    package com.example.myapp;

    public final class BuildConfig {
      public static final boolean DEBUG = Boolean.parseBoolean(&quot;true&quot;);
      public static final String PACKAGE_NAME = &quot;com.example.myapp&quot;;
      public static final String BUILD_TYPE = &quot;debug&quot;;
      public static final String FLAVOR = &quot;&quot;;
      public static final int VERSION_CODE = 400;
      public static final String VERSION_NAME = &quot;&quot;;
    }



Gradle buildConfigField BuildConfig cannot resolve symbol

I have the following table emp : 

    Field 	Type 	   Null 	Key 	Default 	Extra 	
    id 	    int(11)	    NO 	    PRI 	NULL	auto_increment
    name 	varchar(20)	YES 		    NULL	
    dept 	varchar(20)	YES 		    NULL	

Now I like to change the varchar size of name from 20 to 50. 

I have tried with the following SQL queries but the same error shows :

    ALTER TABLE emp
    CHANGE COLUMN &#39;name&#39; varchar(100);


    ALTER TABLE emp
    ALTER  COLUMN name varchar(100);


This is the ERROR :  

&gt;1064 - You have an error in your SQL syntax; check the manual that corresponds
     to your MySQL server version for the right syntax to use
     near &#39;varchar(100)&#39; at line 2

Any idea how to change the column size of varchar type in MYSQL ? 

How to change Column size of varchar type in mySQL?

I have the following table emp :
<pre><code class="hljs language-sql">Field 	Type 	 Null 	Key 	Default 	Extra 	
id 	 int(11)	 NO 	 PRI 	NULL	auto_increment
name 	varchar(20)	YES 		 NULL	
dept 	varchar(20)	YES 		 NULL	
</code></pre>
Now I like to change the varchar size of name from 20 to 50.
I have tried with the following SQL queries but the same error shows :
<pre><code class="hljs language-sql">ALTER TABLE emp
CHANGE COLUMN 'name' varchar(100);


ALTER TABLE emp
ALTER COLUMN name varchar(100);
</code></pre>
This is the ERROR :
>1064 - You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use
near 'varchar(100)' at line 2
Any idea how to change the column size of varchar type in MYSQL ?

I&#39;m trying to find a way to combine two columns into one, but keep getting the value &#39;0&#39; in the column instead to the combination of the words.

These are what I&#39;ve tried as well as others:

    SELECT column1 + column2 AS column3
    FROM table;

    SELECT column1 || column2 AS column3
    FROM table;

    SELECT column1 + &#39; &#39; + column2 AS column3
    FROM table;

Could someone please let me know what I&#39;m doing wrong?


MySQL combine two columns into one column

I&#39;m trying to update the password for a database user using the command line, and it&#39;s not working for me. This is the code I&#39;m using:

    mysql&gt; UPDATE user SET password=PASSWORD($w0rdf1sh) WHERE user=&#39;tate256&#39;;

Could someone tell me what&#39;s wrong with this code.

Change mysql user password using command line

I am trying to import a large .sql data file using phpMyAdmin in XAMPP. However this is taking a lot of time and I keep getting:

   &gt;Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\dbi\DBIMysqli.class.php on line 285

And the file is about 1.2 million lines long.

The file is about 30MB big, so it is not that big. I don&#39;t really understand why it is taking so long.

    ;;;;;;;;;;;;;;;;;;;
    ; Resource Limits ;
    ;;;;;;;;;;;;;;;;;;;
    
    ; Maximum execution time of each script, in seconds
    ; http://php.net/max-execution-time
    ; Note: This directive is hardcoded to 0 for the CLI SAPI
    max_execution_time=30000
    
    ; Maximum amount of time each script may spend parsing request data. It&#39;s a good
    ; idea to limit this time on productions servers in order to eliminate unexpectedly
    ; long running scripts.
    ; Note: This directive is hardcoded to -1 for the CLI SAPI
    ; Default Value: -1 (Unlimited)
    ; Development Value: 60 (60 seconds)
    ; Production Value: 60 (60 seconds)
    ; http://php.net/max-input-time
    max_input_time=60
    
    ; Maximum input variable nesting level
    ; http://php.net/max-input-nesting-level
    ;max_input_nesting_level = 64
    
    ; How many GET/POST/COOKIE input variables may be accepted
    ; max_input_vars = 1000
    
    ; Maximum amount of memory a script may consume (128MB)
    ; http://php.net/memory-limit
    memory_limit=200M

The is the config file for php.ini in xampp, for some reason i still get 

&gt;Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\dbi\DBIMysqli.class.php on line 285.

PHP: maximum execution time when importing .SQL data file

I am adding a column to a table:

    ALTER TABLE t ADD c varchar(10) NOT NULL;

The column gets added, and each record has the empty string.

Is this expected to work this way under all conditions (strict mode, etc.) in MySQL 5.5+?

MySQL add a NOT NULL column

My existing table:

    +-----------------+---------------+------+-----+---------+-------------------+
    | Field           | Type          | Null | Key | Default | Extra             |
    +-----------------+---------------+------+-----+---------+-------------------+
    | creation_date   | timestamp     | YES  |     | NULL                        |

I wanted to alter table like this:

    ALTER TABLE enterprise MODIFY creation_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

But I got this error:

ERROR 1138 (22004) at line 7: Invalid use of NULL value

The problem looks like from changing the Nullable which was YES to NOT NULL. Do I need to drop the column and add afterwards?

MySQL Alter table causes Error: Invalid use of NULL value

I am running PostgreSQL 9.3.1. I have `test` database and `backup` user which is used to backup the database. I have no problems with granting privileges to all current tables, but I have to grant privileges each time the new table is added to schema.

    createdb test

    psql test
    test=# create table foo();
    CREATE TABLE
    test=# grant all on all tables in schema public to backup;
    GRANT
    test=# create table bar();
    CREATE TABLE

    psql -U backup test
    test=&gt; select * from foo;
    test=&gt; select * from bar;
    ERROR:  permission denied for relation bar

Is it possible to grant access to tables which will be created in future without making user owner of the table?

Grant privileges on future tables in PostgreSQL?

Is there a query I can run to show currently assigned privileges on a particular schema?

i.e. privileges that were assigned like so:

    GRANT USAGE ON SCHEMA dbo TO MyUser

I have tried

    SELECT *
    FROM information_schema.usage_privileges;

but this only returns grants to the built-in PUBLIC role. Instead, I want to see which users have been granted privileges on the various schema.

Note: I&#39;m actually using Amazon Redshift rather than pure PostgreSQL, although I will accept a pure PostgreSQL answer if this is not possible in Amazon Redshift. (Though I suspect it is)

postgresql - view schema privileges

I&#39;m trying to test out the `json` type in PostgreSQL 9.3.  
I have a `json` column called `data` in a table called `reports`. The JSON looks something like this:

    {
      &quot;objects&quot;: [
        {&quot;src&quot;:&quot;foo.png&quot;},
        {&quot;src&quot;:&quot;bar.png&quot;}
      ],
      &quot;background&quot;:&quot;background.png&quot;
    }

I would like to query the table for all reports that match the &#39;src&#39; value in the &#39;objects&#39; array. For example, is it possible to query the DB for all reports that match `&#39;src&#39; = &#39;foo.png&#39;`? I successfully wrote a query that can match the `&quot;background&quot;`:
    
    SELECT data AS data FROM reports where data-&gt;&gt;&#39;background&#39; = &#39;background.png&#39;

But since `&quot;objects&quot;` has an array of values, I can&#39;t seem to write something that works. Is it possible to query the DB for all reports that match `&#39;src&#39; = &#39;foo.png&#39;`? I&#39;ve looked through these sources but still can&#39;t get it:

* http://www.postgresql.org/docs/9.3/static/functions-json.html
* https://stackoverflow.com/questions/10560394/how-do-i-query-using-fields-inside-the-new-postgresql-json-datatype
* http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-json-operators/

I&#39;ve also tried things like this but to no avail:
    
    SELECT json_array_elements(data-&gt;&#39;objects&#39;) AS data from reports
    WHERE  data-&gt;&gt;&#39;src&#39; = &#39;foo.png&#39;;

I&#39;m not an SQL expert, so I don&#39;t know what I am doing wrong.

Query for array elements inside JSON type

I&#39;m trying to manually execute SQL commands so I can access procedures in NuoDB.

I&#39;m using Ruby on Rails and I&#39;m using the following command:

    ActiveRecord::Base.connection.execute(&quot;SQL query&quot;)

The &quot;SQL query&quot; could be any SQL command.

Like for example I have a table called &quot;Feedback&quot; and when I execute the command:

    ActiveRecord::Base.connection.execute(&quot;SELECT `feedbacks`.* FROM `feedbacks`&quot;)

This would only return a &quot;true&quot; response instead of sending me all the data requested. 

This is the output on the Rails Console is:

    SQL (0.4ms)  SELECT `feedbacks`.* FROM `feedbacks`
     =&gt; true

I would like to use this to call stored procedures in NuoDB but upon calling the procedures, this would also return a &quot;true&quot; response.

Is there anyway I can execute SQL commands and get the data requested instead of getting a &quot;true&quot; response?


Content Type	Original Author	Original Content on Stackoverflow
Question	Zahid Rouf	View Question on Stackoverflow
Solution 1 - Mysql	Bill Karwin	View Answer on Stackoverflow

How to change Column size of varchar type in mySQL?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Gradle buildConfigField BuildConfig cannot resolve symbol

Calculating sum of repeated elements in AngularJS ng-repeat

Attributions