According to MySQL Manual http://dev.mysql.com/doc/refman/5.0/en/charset-mysql.html you should be able to set collation to `_cs` for case sensitivity. You can get a list of `_cs` collations by executing `SHOW COLLATION WHERE COLLATION LIKE  &quot;%_cs&quot;` query

---
After a little research:

Apparently there are no `utf8_*_cs` in MySQL (yet). If you need case sensitive collation for utf8 fields, you should use `utf8_bin`. This will mess up `ORDER BY`, but this can be fixed by `ORDER BY column COLLATE utf8_general_ci`

Source: http://forums.mysql.com/read.php?103,19380,200971#msg-200971 and http://forums.mysql.com/read.php?103,156527,198794#msg-198794

Try a collation ending in `_bin`, such as `latin1_bin` or `utf8_bin`, depending on your character set.

The new version of MySQL (8.0.1 and higher) comes (finally) with a set of `utf8mb4_*_0900_as_cs` collations.

More about it [here](http://mysqlserverteam.com/mysql-8-0-1-accent-and-case-sensitive-collations-for-utf8mb4/)

How would I sort this data by `count` and `year` values in ascending order prioritizing on the `count` value? 

    //sort this
    var data = [
    	{ count: &#39;12&#39;, year: &#39;1956&#39; },
    	{ count: &#39;1&#39;, year: &#39;1971&#39; },
    	{ count: &#39;33&#39;, year: &#39;1989&#39; },
    	{ count: &#39;33&#39;, year: &#39;1988&#39; }
    ];
    //to get this
    var data = [
    	{ count: &#39;1&#39;, year: &#39;1971&#39; },
    	{ count: &#39;12&#39;, year: &#39;1956&#39; },
    	{ count: &#39;33&#39;, year: &#39;1988&#39; },
    	{ count: &#39;33&#39;, year: &#39;1989&#39; },
    ];

Sort by two values prioritizing on one of them

If we are using IIS 7 and .Net Framework 4, what will be the maximum value of `maxRequestLength`?

Maximum value of maxRequestLength?

Is there any Collation type in MySQL which supports Case Sensitive.
I had all type of collation in MySQL they all have _ci at the end of their name so they are case Insensitive collation.

Case Sensitive collation in MySQL

<p>Is there any Collation type in MySQL which supports Case Sensitive.
I had all type of collation in MySQL they all have _ci at the end of their name so they are case Insensitive collation.</p>


##The setup...
Trying to set up a clean Mac os X 10.6 install to develop python/django and I didn&#39;t remember running into this on 10.5.

After installing MySQL from the installer on `mysql-5.5.8-osx10.6-x86_64.dmg` I ran

    $ sudo pip install MySQL-python

and it seemed to go smoothly (output below)

    Downloading/unpacking MySQL-python
      Downloading MySQL-python-1.2.3.tar.gz (70Kb): 70Kb downloaded
      Running setup.py egg_info for package MySQL-python
        warning: no files found matching &#39;MANIFEST&#39;
        warning: no files found matching &#39;ChangeLog&#39;
        warning: no files found matching &#39;GPL&#39;
    Installing collected packages: MySQL-python
      Running setup.py install for MySQL-python
        building &#39;_mysql&#39; extension
        gcc-4.2 -fno-strict-aliasing -fno-common -dynamic -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -pipe -Dversion_info=(1,2,3,&#39;final&#39;,0) -D__version__=1.2.3 -I/usr/local/mysql/include -I/System/Library/Frameworks/Python.framework/Versions/2.6/include/python2.6 -c _mysql.c -o build/temp.macosx-10.6-universal-2.6/_mysql.o -Os -g -fno-common -fno-strict-aliasing -arch x86_64
        In file included from _mysql.c:36:
        /usr/local/mysql/include/my_config.h:325:1: warning: &quot;SIZEOF_SIZE_T&quot; redefined
        In file included from /System/Library/Frameworks/Python.framework/Versions/2.6/include/python2.6/Python.h:9,
                         from pymemcompat.h:10,
                         from _mysql.c:29:
        /System/Library/Frameworks/Python.framework/Versions/2.6/include/python2.6/pymacconfig.h:33:1: warning: this is the location of the previous definition
        In file included from _mysql.c:36:
        /usr/local/mysql/include/my_config.h:419:1: warning: &quot;HAVE_WCSCOLL&quot; redefined
        In file included from /System/Library/Frameworks/Python.framework/Versions/2.6/include/python2.6/Python.h:8,
                         from pymemcompat.h:10,
                         from _mysql.c:29:
        /System/Library/Frameworks/Python.framework/Versions/2.6/include/python2.6/pyconfig.h:803:1: warning: this is the location of the previous definition
        gcc-4.2 -Wl,-F. -bundle -undefined dynamic_lookup build/temp.macosx-10.6-universal-2.6/_mysql.o -L/usr/local/mysql/lib -lmysqlclient_r -lpthread -o build/lib.macosx-10.6-universal-2.6/_mysql.so -arch x86_64
        warning: no files found matching &#39;MANIFEST&#39;
        warning: no files found matching &#39;ChangeLog&#39;
        warning: no files found matching &#39;GPL&#39;
    Successfully installed MySQL-python
    Cleaning up...

after this I tried:

    $ python -c &quot;import MySQLdb&quot;

and it crapped out on me with:

    Traceback (most recent call last):
      File &quot;&lt;string&gt;&quot;, line 1, in &lt;module&gt;
      File &quot;/Library/Python/2.6/site-packages/MySQLdb/__init__.py&quot;, line 19, in &lt;module&gt;
        import _mysql
    ImportError: dlopen(/Library/Python/2.6/site-packages/_mysql.so, 2): Library not loaded: libmysqlclient.16.dylib
      Referenced from: /Library/Python/2.6/site-packages/_mysql.so
      Reason: image not found

##So on to my question...

What did I do wrong?/What else do I need to do?

Googling (and searching here) for this returns a lot of results getting this error message with Ruby not too many with Python tho.


Python: MySQLdb and &quot;Library not loaded: libmysqlclient.16.dylib&quot;

mysql GROUP_CONCAT duplicates

This code doesn&#39;t work for MySQL 5.0, how to re-write it to make it work

    DELETE FROM posts where id=(SELECT id FROM posts GROUP BY id  HAVING ( COUNT(id) &gt; 1 ))

I want to delete columns that dont have unique id. I will add that most of the time its only one id(I tried the in syntax and it doesnt work as well).

How to delete from select in MySQL?

I&#39;m having a problem executing some SQL from within Python, despite similar SQL working fine from the `mysql` command-line.

The table looks like this:

    mysql&gt; SELECT * FROM foo;
    +-------+-----+
    | fooid | bar |
    +-------+-----+
    |     1 | A   | 
    |     2 | B   | 
    |     3 | C   | 
    |     4 | D   | 
    +-------+-----+
    4 rows in set (0.00 sec)

I can execute the following SQL query from the mysql command-line, without a problem:

    mysql&gt; SELECT fooid FROM foo WHERE bar IN (&#39;A&#39;,&#39;C&#39;);
    SELECT fooid FROM foo WHERE bar IN (&#39;A&#39;,&#39;C&#39;);
    +-------+
    | fooid |
    +-------+
    |     1 | 
    |     3 | 
    +-------+
    2 rows in set (0.00 sec)

However, when I try to do the same from within Python, I get no rows, while I expected 2 rows:

    import MySQLdb
    import config
    connection=MySQLdb.connect(
        host=config.HOST,user=config.USER,passwd=config.PASS,db=&#39;test&#39;)
    cursor=connection.cursor()
    
    sql=&#39;SELECT fooid FROM foo WHERE bar IN %s&#39;
    args=[[&#39;A&#39;,&#39;C&#39;]]
    cursor.execute(sql,args)
    data=cursor.fetchall()
    print(data)
    # ()

So the question is: how should the python code be modified to select those `fooid`s where `bar` is in `(&#39;A&#39;,&#39;C&#39;)`?

By the way, I noticed that if I switch the roles of `bar` and `fooid`, I can get the code to select those `bar`s where `fooid` is in `(1,3)` successfully. I don&#39;t understand why one such query (below) works, while the other one (above) doesn&#39;t.

    sql=&#39;SELECT bar FROM foo WHERE fooid IN %s&#39;
    args=[[1,3]]
    cursor.execute(sql,args)
    data=cursor.fetchall()
    print(data)
    # ((&#39;A&#39;,), (&#39;C&#39;,))

And just to be absolutely clear, this is how the `foo` table was created:

    mysql&gt; DROP TABLE IF EXISTS foo;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql&gt; CREATE TABLE `foo` (
              `fooid` int(11) NOT NULL AUTO_INCREMENT,
              `bar` varchar(10) NOT NULL,
              PRIMARY KEY (`fooid`));
    Query OK, 0 rows affected (0.01 sec)
    
    mysql&gt; INSERT into foo (bar) values (&#39;A&#39;),(&#39;B&#39;),(&#39;C&#39;),(&#39;D&#39;);
    Query OK, 4 rows affected (0.00 sec)
    Records: 4  Duplicates: 0  Warnings: 0
    


----------


**Edit**: When I enable the general query log with `mysqld -l /tmp/myquery.log` 
I see

    mysqld, Version: 5.1.37-1ubuntu5.5-log ((Ubuntu)). started with:
    Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
    Time                 Id Command    Argument
    110101 11:45:41	    1 Connect	unutbu@localhost on test
    		    1 Query	set autocommit=0
    		    1 Query	SELECT fooid FROM foo WHERE bar IN (&quot;&#39;A&#39;&quot;, &quot;&#39;C&#39;&quot;)
    		    1 Query	SELECT bar FROM foo WHERE fooid IN (&#39;1&#39;, &#39;3&#39;)
    		    1 Quit

Indeed, it looks like too many quotes are being placed around `A` and `C`.

Thanks to @Amber&#39;s comment, I understand better what is going wrong. MySQLdb converts the parametrized argument `[&#39;A&#39;,&#39;C&#39;]` to `(&quot;&#39;A&#39;&quot;,&quot;&#39;C&#39;&quot;)`. 

Is there a way to make a parametrized query using the `IN` SQL syntax? Or must one manually construct the SQL string?

Executing &quot;SELECT ... WHERE ... IN ...&quot; using MySQLdb

There are a lot of questions that ask about &#39;UNIX timestamp to MySQL time&#39;. I needed the reversed way, yea... Any idea?

How to convert MySQL time to UNIX timestamp using PHP?

Does anybody know what this means?

    12-31 20:55:45.861: ERROR/AndroidRuntime(12478): Caused by: java.lang.IllegalArgumentException: the bind value at index 1 is null
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at android.database.sqlite.SQLiteProgram.bindString(SQLiteProgram.java:234)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at android.database.sqlite.SQLiteQuery.bindString(SQLiteQuery.java:182)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:48)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1345)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:330)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:280)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at net.lp.collectionista.providers.ProductContentProvider.query(ProductContentProvider.java:350)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at android.content.ContentProvider$Transport.query(ContentProvider.java:163)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at android.content.ContentResolver.query(ContentResolver.java:245)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at net.lp.collectionista.providers.FacadeContentProvider.query(FacadeContentProvider.java:563)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at android.content.ContentProvider$Transport.query(ContentProvider.java:163)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at android.content.ContentResolver.query(ContentResolver.java:245)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at net.lp.collectionista.util.ScanAddTask.existsProduct(ScanAddTask.java:164)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at net.lp.collectionista.util.ScanAddTask.&lt;init&gt;(ScanAddTask.java:71)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at net.lp.collectionista.util.ItemScanAddTask.&lt;init&gt;(ItemScanAddTask.java:34)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at net.lp.collectionista.ui.activities.collections.cd.CDCollectionViewWindow$MusicCDItemScanAddTask.&lt;init&gt;(CDCollectionViewWindow.java:147)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at net.lp.collectionista.ui.activities.collections.cd.CDCollectionViewWindow.restoreLocalState(CDCollectionViewWindow.java:1044)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at net.lp.collectionista.ui.activities.collections.cd.CDCollectionViewWindow.onRestoreInstanceState(CDCollectionViewWindow.java:966)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at android.app.Activity.performRestoreInstanceState(Activity.java:815)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at android.app.Instrumentation.callActivityOnRestoreInstanceState(Instrumentation.java:1096)
    12-31 20:55:45.861: ERROR/AndroidRuntime(12478):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2641)



IllegalArgumentException: the bind value at index 1 is null

I&#39;ve been doing development using SQLITE database with production in POSTGRESQL.  I just updated my local database with a huge amount of data and need to transfer a specific table to the production database.

Based on running `sqlite database .dump &gt; /the/path/to/sqlite-dumpfile.sql`, SQLITE outputs a table dump in the following format:

    BEGIN TRANSACTION;
    CREATE TABLE &quot;courses_school&quot; (&quot;id&quot; integer PRIMARY KEY, &quot;department_count&quot; integer NOT NULL DEFAULT 0, &quot;the_id&quot; integer UNIQUE, &quot;school_name&quot; varchar(150), &quot;slug&quot; varchar(50));
    INSERT INTO &quot;courses_school&quot; VALUES(1,168,213,&#39;TEST Name A&#39;,NULL);
    INSERT INTO &quot;courses_school&quot; VALUES(2,0,656,&#39;TEST Name B&#39;,NULL);
    ....
    COMMIT;

How do I convert the above into a POSTGRESQL compatible dump file that I can import into my production server?

Convert SQLITE SQL dump file to POSTGRESQL

I have two tables `TableA` and `TableB` which have the same format of columns, which means both tables have the columns

    A B C D E F 

where `A` and `B` are the primary keys.

How do I write an SQL query to check if `TableA` and `TableB` (which have identical primary keys) contain exactly the same values in every column? 

It means that these two tables have exactly the same data.

SQL how to compare two tables for same data content?

Is it possible for the same exact Mongo ObjectId to be generated for a document in two different collections?  I realize that it&#39;s definitely very unlikely, but is it possible?  

Without getting too specific, the reason I ask is that with an application that I&#39;m working on we show public profiles of elected officials who we hope to convert into full fledged users of our site.  We have separate collections for users and the elected officials who aren&#39;t currently members of our site.  There are various other documents containing various pieces of data about the elected officials that all map back to the person using their elected official ObjectId.

After creating the account we still highlight the data that&#39;s associated to the elected official but they now also are a part of the users collection with a corresponding users ObjectId to map their profile to interactions with our application.

We had begun converting our application from MySql to Mongo a few months ago and while we&#39;re in transition we store the legacy MySql id for both of these data types and we&#39;re also starting to now store the elected official Mongo ObjectId in the users document to map back to the elected official data.

I was pondering just specifying the new user ObjectId as the previous elected official ObjectId to make things simpler but wanted to make sure that it wasn&#39;t possible to have a collision with any existing user ObjectId.

Thanks for your insight.

Edit:  Shortly after posting this question, I realized that my proposed solution wasn&#39;t a very good idea.  It would be better to just keep the current schema that we have in place and just link to the elected official &#39;_id&#39; in the users document.

Possibility of duplicate Mongo ObjectId&#39;s being generated in two different collections?

Trying to import a CSV with contact information:

    Name,Address,City,State,ZIP  
    Jane Doe,123 Main St,Whereverville,CA,90210  
    John Doe,555 Broadway Ave,New York,NY,10010 

Running this doesn&#39;t seem to add any documents to the database:

    $ mongoimport -d mydb -c things --type csv --file locations.csv --headerline

Trace says `imported 1 objects`, but firing up the Mongo shell and running `db.things.find()` doesn&#39;t show any new documents. 

What am I missing?

Content Type	Original Author	Original Content on Stackoverflow
Question	Keyur Padalia	View Question on Stackoverflow
Solution 1 - Mysql	German Rumm	View Answer on Stackoverflow
Solution 2 - Mysql	Neil E. Pearson	View Answer on Stackoverflow
Solution 3 - Mysql	Jagger	View Answer on Stackoverflow

Case Sensitive collation in MySQL

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Maximum value of maxRequestLength?

Sort by two values prioritizing on one of them

Attributions