See [http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_lower][1]

    UPDATE table_name SET tag = LOWER(tag)


  [1]: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_lower


[**LOWER()**][1]

    update table set tag = LOWER(tag)


  [1]: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_lower

Version for case-insensitive matching and including a &quot;WHERE&quot; clause if you don&#39;t want to update the entire column:
  
    UPDATE table 
    SET tag = LOWER(tag)
    WHERE LOWER(tag) != tag
    COLLATE Latin1_General_CS_AS

The COLLATE line will make it work if your database uses case insensitive matching, as mine does.

Try this:

    update `table` set `column_name` = LOWER(column_name without quotation)

It is possible to create a primary key or unique index within a SQL Server CREATE TABLE statement. Is it possible to create a **non-unique** index within a CREATE TABLE statement?

    CREATE TABLE MyTable(
        a int NOT NULL
        ,b smallint NOT NULL
        ,c smallint NOT NULL
        ,d smallint NOT NULL
        ,e smallint NOT NULL
    
        -- This creates a primary key
        ,CONSTRAINT PK_MyTable PRIMARY KEY CLUSTERED (a)
    
        -- This creates a unique nonclustered index on columns b and c
        ,CONSTRAINT IX_MyTable1 UNIQUE (b, c)
    
        -- Is it possible to create a non-unique index on columns d and e here?
        -- Note: these variations would not work if attempted:
        -- ,CONSTRAINT IX_MyTable2 INDEX (d, e)
        -- ,CONSTRAINT IX_MyTable3 NONCLUSTERED INDEX (d, e)
    );
    GO

    -- The proposed non-unique index should behave identically to
    -- an index created after the CREATE TABLE statement. Example:
    CREATE NONCLUSTERED INDEX IX_MyTable4 ON MY_TABLE (d, e);
    GO


Again, the goal is to create the non-unique index within the CREATE TABLE statement, not after it.

For what it&#39;s worth, I did not find the [[SQL Server Books Online entry for CREATE TABLE]][1] to be helpful.

Also, [[This Question]][2] is nearly identical, but the accepted answer does not apply.

  [1]: http://msdn.microsoft.com/en-us/library/ms174979.aspx
  [2]: https://stackoverflow.com/questions/2689930/how-to-create-nonclustered-index-in-create-table
  

Create a nonclustered non-unique index within the CREATE TABLE statement with SQL Server

Hi I have a table with a date field and some other information.
I want to select all entries from the past week, (week start from Sunday).

table values:

    id  date
    2   2011-05-14 09:17:25
    5   2011-05-16 09:17:25
    6   2011-05-17 09:17:25
    8   2011-05-20 09:17:25
    15  2011-05-22 09:17:25


I want to select all ids from last week, expected output is 5, 6, 8.
*(id 2 not in last week, and id 15 is in current week.)*

How to write and SQL Query for the same.



MySQL Query to select data from last week?

Lets say I have something like this

    uid    tag
    1      HeLLo
    2      heLLO
    3      HELLO
    4      hello

How can I update all values in the &quot;tag&quot; column to:

    uid    tag
    1      hello 
    2      hello 
    3      hello 
    4      hello 

using MySQL?

Update all values of a column to lowercase

Lets say I have something like this
<pre><code class="hljs">uid tag
1 HeLLo
2 heLLO
3 HELLO
4 hello
</code></pre>
How can I update all values in the "tag" column to:
<pre><code class="hljs">uid tag
1 hello 
2 hello 
3 hello 
4 hello 
</code></pre>
using MySQL?

I have a large (~150mb) sql file that I am trying to import.  It is too large to do it through PHPMyAdmin even splitting it into many pieces and it is too large to import through a php script as it times out after 30 seconds of processing the script. So I&#39;m looking for how to directly import the file from MySQL command line. 

Searching online shows that I want to either use `database_name &lt; file_name.sql` or `source file_name.sql` but I can&#39;t get either of these to work.

Using `&lt;` gives the generic MySQL syntax error while using `source` give a slightly more promising `failed to open file &#39;file_name.sql&#39;, error: 2` so I am inclined to think that the source command is on the right track.

I am in windows and am using xampp as a localhost server (note I&#39;m only trying to import this file on the localhost so that I can execute the sql).  I&#39;ve tried placing the file in  `xampp\mysql\bin` and `xampp\mysql\data\database_name`.

Any suggestions of how to import this .sql file into MySQL either from the MySQL command line or by any other means would be greatly appreciated.

How do you use MySQL&#39;s source command to import large files in windows

I&#39;m using a MySql database with a Java program, now I want to give the program to somebody else.

How to export the MySql database structure without the data in it, just the structure?

MySql export schema without data

I have a model `Coupon`, and a model `Photo` with a `ForeignKey` to it:

    class Photo(models.Model):
        coupon = models.ForeignKey(Coupon,
                                   related_name=&#39;description_photos&#39;)
        title = models.CharField(max_length=100)
        image = models.ImageField(upload_to=&#39;images&#39;)

I set up inlines in the admin so now I&#39;m able to add photos to a coupon from the admin.

I attempt to add one, and upload is successful, but then I get Django&#39;s debug page with this error:

    IntegrityError at /admin/coupon/coupon/321/
    (1452, &#39;Cannot add or update a child row: a foreign key constraint fails (`my_project`.`coupon_photo`, CONSTRAINT `coupon_id_refs_id_90d7f06` FOREIGN KEY (`coupon_id`) REFERENCES `coupon_coupon` (`id`))&#39;)

What is this and how can I solve this problem?

(If it matters, this is a MySQL database.)

**EDIT:** I tried it on an Sqlite3 database that has a slightly different dataset, and it worked, so perhaps there&#39;s loose data in my current DB? How can I find it and delete it?

Django &quot;Cannot add or update a child row: a foreign key constraint fails&quot;

&gt; This is to create a **community learning resource**. The goal is to have examples of good code that do not repeat the awful mistakes that can so often be found in copy/pasted PHP code. I have requested it be made Community Wiki. 
&gt;
&gt; This is **not meant as a coding contest.** It&#39;s not about finding the fastest or most compact way to do a query - it&#39;s to provide a good, readable reference especially for newbies. 

Every day, there is a huge influx of questions with *really bad* code snippets using the `mysql_*` family of functions on Stack Overflow. While it is usually best to direct those people towards PDO, it sometimes is neither possible (e.g. inherited legacy software) nor a realistic expectation (users are already using it in their project).

Common problems with code using the `mysql_*` library include:

* SQL injection in values
* SQL injection in LIMIT clauses and dynamic table names
* No error reporting (&quot;Why does this query not work?&quot;)
* Broken error reporting (that is, errors always occur even when the code is put into production)
* Cross-site scripting (XSS) injection in value output

Let&#39;s write a PHP code sample that does the following using the [mySQL_* family of functions][1]:

* Accept two POST values, `id` (numeric) and `name` (a string)
* Do an UPDATE query on a table `tablename`, changing the `name` column in the row with the ID `id`
* On failure, exit graciously, but show the detailed error only in production mode. `trigger_error()` will suffice; alternatively use a method of your choosing 
* Output the message &quot;`$name` updated.&quot;

And does **not** show any of the weaknesses listed above.

It should be **as simple as possible**. It ideally doesn&#39;t contain any functions or classes. The goal is not to create a copy/pasteable library, but to **show the minimum of what needs to be done to make database querying safe.**

Bonus points for good comments.

The goal is to make this question a resource that a user can link to when encountering a question asker who has bad code (even though it isn&#39;t the focus of the question at all) or is confronted with a failing query and doesn&#39;t know how to fix it. 

 **To pre-empt PDO discussion:**

Yes, it will often be preferable to direct the individuals writing those questions to PDO. When it is an option, we should do so. It is, however, not always possible - sometimes, the question asker is working on legacy code, or has already come a long way with this library, and is unlikely to change it now. Also, the `mysql_*` family of functions is perfectly safe if used properly. So no &quot;use PDO&quot; answers here please.

  [1]: http://php.net/manual/en/book.mysql.php

Reference: What is a perfect code sample using the MySQL extension?

I am using debian linux.
I have a linux machine on which mysql is install.
I can log in to my linux machine using root user as well as other user.
I can connect to mysql database on linux machine from windows machine using sqlyog.
Now I want to execute queries on linux machine only using linux terminal

I tried some following things on terminal

I went to root directory then I went to /var/lib directory

I run following commands on terminal

    mysqladmin -u root -p
    mysqladmin -u root -ppassword

everytime I have get following error message

&gt; ERROR 1045 (28000) Access denied for
&gt; user &#39;root&#39;@&#39;localhost&#39; (Using
&gt; password NO)


please guide me for following

1. How do I get mysql prompt in linux terminal?
2. How I stop the mysql server from linux terminal?
3. How I start the mysql server from linux terminal?
4. How do I get mysql prompt in linux terminal?
5. How do I login to mysql server from linux terminal?
6. How do I solve following error?

&gt; ERROR 1045 (28000) Access denied for
&gt; user &#39;root&#39;@&#39;localhost&#39; (Using
&gt; password NO)

Please give me solutions for above question.
Thank You





Content Type	Original Author	Original Content on Stackoverflow
Question	Adam Ramadhan	View Question on Stackoverflow
Solution 1 - Mysql	Rippo	View Answer on Stackoverflow
Solution 2 - Mysql	Shakti Singh	View Answer on Stackoverflow
Solution 3 - Mysql	Susie	View Answer on Stackoverflow
Solution 4 - Mysql	Anjani Barnwal	View Answer on Stackoverflow

Update all values of a column to lowercase

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

MySQL Query to select data from last week?

Create a nonclustered non-unique index within the CREATE TABLE statement with SQL Server

Attributions