As stated in the documentation of [MySQL][1], since 5.7.8 a native JSON data type is supported.

The JSON data type provides these advantages over storing JSON-format strings in a string column:

 - Automatic validation of JSON documents stored in JSON columns. Invalid documents produce an error.
 - Optimized storage format. JSON documents stored in JSON columns are converted to an internal format that permits quick read access to document elements. When the server later must read a JSON value stored in this binary format, the value need not be parsed from a text representation. The binary format is structured to enable the server to look up subobjects or nested values directly by key or array index without reading all values before or after them in the document.

So, as the MySQL documentation states, the JSON data type should be used and not the text.

  [1]: https://dev.mysql.com/doc/refman/5.7/en/json.html

`blob` is usually for things like images, binaries etc. `text` should be good enough for your case, or you can use `longtext` which has even bigger space capacity if that&#39;s really a concern.

Searching-wise, since you are storing `json_encode`&#39;d stuff, you&#39;ll still need to call `json_decode` on it anyway for it to be useful in your application, I don&#39;t think choice of datatype matters in this case.

A better way is to normalize your database design instead of storing related stuff in one big string of json.

Is it possible to do something like this in Java for Android (this is a pseudo code)

    IF (some_string.equals(&quot;john&quot; OR &quot;mary&quot; OR &quot;peter&quot; OR &quot;etc.&quot;){
       THEN do something
    }

?

At the moment this is done via multiple `String.equals()` condition with `||` among them. 

String.equals() with multiple conditions (and one action on result)

I am looking for a function that returns the first element in a sequence for which an fn evaluates to true. For example:

    (first-map (fn [x] (= x 1)) &#39;(3 4 1))

The above fake function should return 1 (the last element in the list). Is there something like this in Clojure?

Return first item in a map/list/sequence that satisfies a predicate

I am planning to store a `json_encoded` string on my database. I can&#39;t precisely tell the length its going to be, but I&#39;m pretty sure it will be long. My concern is which field type I am going to use for this, is it `blob` or `text`?

I prefer the one where I can save space as much as possible over fast searching, in any case I have other column where I should just index.

Should I use blob or text for JSON in MySQL?

<p>I am planning to store a <code>json_encoded</code> string on my database. I can't precisely tell the length its going to be, but I'm pretty sure it will be long. My concern is which field type I am going to use for this, is it <code>blob</code> or <code>text</code>?</p>
<p>I prefer the one where I can save space as much as possible over fast searching, in any case I have other column where I should just index.</p>


Which of the following options, if any, is considered best practice when designing a table used to store user settings? 

(OPTION 1)

    USER_SETTINGS
    -Id
    -Code (example &quot;Email_LimitMax&quot;)
    -Value (example &quot;5&quot;)
    -UserId

(OPTION 2) 

create a new table for each setting where, for example, notification settings would require you to create:

    &quot;USER_ALERT_SETTINGS&quot;
    -Id
    -UserId
    -EmailAdded (i.e true)
    -EmailRemoved 
    -PasswordChanged
    ...
    ...

    &quot;USER_EMAIL_SETTINGS&quot;
    -Id
    -UserId
    -EmailLimitMax
    ....

(OPTION 3)

    &quot;USER&quot;
    -Name
    ...
    -ConfigXML


Database design for user settings

I have a table with string values in the format of **Friday 20th April 2012** in a field called `Film_Release`

I am looping through and I want to convert them in `datetime` and roll them out into another table. My second table has a column called `Films_Date`, with a format of `DATE`. I am receiving this error

&gt; Object of class DateTime could not be converted to string

    $dateFromDB = $info[&#39;Film_Release&#39;];
    $newDate = DateTime::createFromFormat(&quot;l dS F Y&quot;,$dateFromDB); //( http:php.net/manual/en/datetime.createfromformat.php)

Then I insert `$newdate` into the table through an insert command.

Why am I be getting such an error?

Object of class DateTime could not be converted to string

I had been using SQL Server and am now using MySQL for a project. With SQL Server, our developers can connect to the remote database on their local machines if they know the host, username, password. With MySQL, though, to give a developer access from their local machines, I have been having to log in to MySQL and execute:

    GRANT ALL ON *.* to user@address IDENTIFIED BY &#39;password&#39;; 
    flush privileges;

Where `address` is the IP address of the developer&#39;s machine. Of course, if they change networks, I have to execute it again. Is there a way to allow all remote connections like I have experienced with SQL Server, or is this a bad idea for some reason? We have username and password still.. I&#39;m obviously a little confused.

Also: this is a development database and is only accessible from our internal network. I understand why it is a bad idea to give everyone access to a production database. 

Allow all remote connections, MySQL

I often see people are using Delimiters. I tried myself to find out what are delimiters and what is their purpose. After 20 minutes of googling, I was not able to find an answer which satisfies me. So, my question is now: What are delimiters and when should I use them?

Delimiters in MySQL

I have a **micro** instance server on EC2 based [this][1]

mysql server fails frequently and for the third time mysql server is gone. The logs only shows 

    120423 09:13:38 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
    120423 09:14:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    120423  9:14:27 [Note] Plugin &#39;FEDERATED&#39; is disabled.
    120423  9:14:27 InnoDB: The InnoDB memory heap is disabled
    120423  9:14:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    120423  9:14:27 InnoDB: Compressed tables use zlib 1.2.3
    120423  9:14:27 InnoDB: Using Linux native AIO
    120423  9:14:27 InnoDB: Initializing buffer pool, size = 512.0M
    InnoDB: mmap(549453824 bytes) failed; errno 12
    120423  9:14:27 InnoDB: Completed initialization of buffer pool
    120423  9:14:27 InnoDB: Fatal error: cannot allocate memory for the buffer pool
    120423  9:14:27 [ERROR] Plugin &#39;InnoDB&#39; init function returned error.
    120423  9:14:27 [ERROR] Plugin &#39;InnoDB&#39; registration as a STORAGE ENGINE failed.
    120423  9:14:27 [ERROR] Unknown/unsupported storage engine: InnoDB
    120423  9:14:27 [ERROR] Aborting

What is really `failed; errno 12`? And how could I give more space/memory or whatever needed to make this fixed. 

I fix this each time by rebooting the whole system and deleting all logs and restart the mysql server. But I know something is wrong with my configuration.

Also my `my.cnf&#39; is like below : 

    [mysqld]
    # Settings user and group are ignored when systemd is used.
    # If you need to run mysqld under different user or group,
    # customize your systemd unit file for mysqld according to the
    # instructions in http://fedoraproject.org/wiki/Systemd
    # max_allowed_packet=500M
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    
    
    innodb_buffer_pool_size         = 512M
    
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid


  [1]: http://bogomip.net/blog/build-an-amazon-ec2-lamp-server/

Amazon EC2, mysql aborting start because InnoDB: mmap (x bytes) failed; errno 12

When a user clicks a `Button` in my App (which is printed in a `SurfaceView`), I&#39;d like a text `Dialog` to appear and I would like to store the result in a `String`. I&#39;d like the text `Dialog` to overlay the current screen. How can I do this?

Input text dialog Android

I need to add some texts to an existing table image (png).
Which means that I need to &quot;write&quot; on the image and I need the option to select the text location.
How can I do it?

How to add text to an image in java?

I have a situation where I want a bash script to replace an entire line in a file.
The line number is always the same, so that can be a hard-coded variable.

I&#39;m not trying to replace some sub-string in that line, I just want to replace that line entirely with a new line.

Are there any bash methods for doing this (or something simple that can be thrown into a .sh script).

How to replace an entire line in a text file by line number

I am new to d3 and svg coding and am looking for a way to rotate text on the xAxis of a chart. My problem is that typically the xAxis titles are longer than the bars in the bar chart are wide. So I&#39;m looking to rotate the text to run vertically (rather than horizontally) beneath the xAxis. 

I&#39;ve tried adding the transform attribute: 
.attr(&quot;transform&quot;, &quot;rotate(180)&quot;)

But when I do that, the text disappears altogether. I&#39;ve tried increasing the height of the svg canvas, but still was unable to view the text. 

Any thoughts on what I&#39;m doing wrong would be great. Do I need to also adjust the x and y positions? And, if so, by how much (hard to troubleshoot when I can see it in Firebug).


rotate x axis text in d3

I have an Arabic file encoded in [ISO8859-15](https://en.wikipedia.org/wiki/ISO/IEC_8859-15). How can I convert it into UTF8?  
I used `iconv` but it doesn&#39;t work for me.

    iconv -f ISO-8859-15 -t UTF-8 Myfile.txt
I wanted to attach the file, but I don&#39;t know how.

How to convert ISO8859-15 to UTF8?

What is `blob` and what is `text`? What are the differences?

When do I need to use `blob` and when do I need `text` as data type?

Because for `blob` and `text`, there are `mediumblob` == `mediumtext`, `smallblob` == `small text`. Do they even have the same meaning?

And look at this `MEDIUMBLOB`, `MEDIUMTEXT L` + 3 bytes, where `L &lt; 224`.

What is `L`?

What are the differences between the BLOB and TEXT datatypes in MySQL?

My page generates a URL like this: `&quot;blob:http%3A//localhost%3A8383/568233a1-8b13-48b3-84d5-cca045ae384f&quot;` How can I convert it to a normal address?

I&#39;m using it as an `&lt;img&gt;`&#39;s `src` attribute.


Convert blob URL to normal URL

Does amazon s3 support batch uploads? 
I have a job that needs to upload each night ~100K of files that can be up to 1G but is strongly skewed towards small files (90% are less than 100 bytes and 99% are less than 1000 bytes long).

Does the s3 API support uploading multiple objects in a single HTTP call?

All the objects must be available in S3 as individual objects. I cannot host them anywhere else (FTP, etc) or in another format (Database, EC2 local drive, etc). That is an external requirement that I cannot change.

Is it possible to perform a batch upload to amazon s3?

I was studying Blobs, and I noticed that when you have an ArrayBuffer, you can easily convert this to a Blob as follows:

    var dataView = new DataView(arrayBuffer);
    var blob = new Blob([dataView], { type: mimeString });

The question I have now is, is it possible to go from a Blob to an ArrayBuffer?

How to go from Blob to ArrayBuffer

I need to add a UTF-8 byte-order-mark to generated text data on client side. How do I do that?

Using `new Blob([&#39;\xEF\xBB\xBF&#39; + content])` yields `&#39;&#239;&#187;&#191;&quot;my data&quot;&#39;`,  of course.

Neither did `&#39;\uBBEF\x22BF&#39;` work (with `&#39;\x22&#39; == &#39;&quot;&#39;` being the next character in `content`).

Is it possible to prepend the UTF-8 BOM in JavaScript to a generated text?

&lt;sup&gt;Yes, I really do need the UTF-8 BOM in this case.&lt;/sup&gt;

Adding UTF-8 BOM to string/Blob

I have inserted records in mysql DB, with `json encoded` data type, Now I have to make search within `json encoded` data, but i am not able to get proper data using following MySql query.
 
&lt;!-- language:lang-sql --&gt;

    SELECT  `id` ,  `attribs_json` 
    FROM  `products` 
    WHERE  `attribs_json` REGEXP  &#39;&quot;1&quot;:{&quot;value&quot;:[^&quot;3&quot;$]&#39;

Query results are key equal to &quot;1&quot; and value is anything except &quot;3&quot;

My data is:

    {&quot;feature&quot;:{&quot;1&quot;:{&quot;value&quot;:&quot;[&quot;2&quot;,&quot;3&quot;]&quot;},
                &quot;2&quot;:{&quot;value&quot;:[&quot;1&quot;]},
                &quot;5&quot;:{&quot;value&quot;:&quot;&quot;},
                &quot;3&quot;:{&quot;value&quot;:[&quot;1&quot;]},
                &quot;9&quot;:{&quot;value&quot;:&quot;&quot;},
                &quot;4&quot;:{&quot;value&quot;:&quot;\u0633\u0627\u062a\u0646&quot;},
                &quot;6&quot;:{&quot;value&quot;:&quot;&quot;},
                &quot;7&quot;:{&quot;value&quot;:&quot;&quot;},
                &quot;8&quot;:{&quot;value&quot;:&quot;&quot;}
               },
    &quot;show_counter&quot;:&quot;0&quot;,
    &quot;show_counter_discount&quot;:&quot;&quot;
    }}

How to search JSON data in MySQL?

I have started using MySQL 5.7.10 recently and I am liking the native JSON Data type a lot.

But I ran into a problem when it comes to updating a JSON type value.

**Questions:**

Below is the table format, here I want to add 1 more key in JSON `data` column for `t1` table. Right now I have to fetch the value modify it and Update the table. So it involves an extra `SELECT` statement.

I can insert like this 

    INSERT INTO t1 values (&#39;{&quot;key2&quot;:&quot;value2&quot;}&#39;, 1);

    mysql&gt; select * from t1;
    +--------------------+------+
    | data               | id   |
    +--------------------+------+
    | {&quot;key1&quot;: &quot;value1&quot;} |    1 |
    | {&quot;key2&quot;: &quot;value2&quot;} |    2 |
    | {&quot;key2&quot;: &quot;value2&quot;} |    1 |
    +--------------------+------+
    3 rows in set (0.00 sec)

    mysql&gt;Show create table t1;


    +-------+-------------------------------------------------------------

    -------------------------------------------------------+
    | Table | Create Table                                                                                                       |
    +-------+--------------------------------------------------------------------------------------------------------------------+
    | t1    | CREATE TABLE `t1` (
      `data` json DEFAULT NULL,
      `id` int(11) DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
    +-------+--------------------------------------------------------------------------------------------------------------------+
    1 row in set (0.00 sec)

Is there a work around for this?

How to update JSON data type column in MySQL 5.7.10?

Let&#39;s say I have a JSON column named **data** in some MySQL table, and this column is a single *array*. So, for example, data may contain:

&gt; [1,2,3,4,5]

Now I want to select all rows which have a data column where one of its array elements is greater than 2. Is this possible?

I tried the following, but seems it is always *true* regardless of the values in the array:

    SELECT * from my_table
    WHERE JSON_EXTRACT(data, &#39;$[*]&#39;) &gt; 2;

How to search JSON array in MySQL?

I exported my database with JSON columns in it. After I migrated to a new server, my import crashed every time with an error like:

&gt;cannot create a JSON value from a string with CHARACTER SET &#39;binary&#39;

On stackoverflow, I found this post but didn&#39;t work for me:
https://stackoverflow.com/questions/36178312/mysqlimport-issues-set-character-set-database-binary-which-prevents-loading

The file is 2GB and isn&#39;t possible to open the file.

Anyone has an idea to import my database file?

Content Type	Original Author	Original Content on Stackoverflow
Question	Leandro Garcia	View Question on Stackoverflow
Solution 1 - Mysql	cs04iz1	View Answer on Stackoverflow
Solution 2 - Mysql	Andreas Wong	View Answer on Stackoverflow

Should I use blob or text for JSON in MySQL?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Return first item in a map/list/sequence that satisfies a predicate

String.equals() with multiple conditions (and one action on result)

Attributions