can someone explain me about different between mysql and nosql?

Question

anonymous · Answer

SQL databases are like automatic transmission and NoSQL databases are like manual transmission. Once you switch to NoSQL, you become responsible for a lot of work that the system takes care of automatically in a relational database system. Similar to what happens when you pick manual over automatic transmission. Secondly, NoSQL allows you to eke more performance out of the system by eliminating a lot of integrity checks done by relational databases from the database tier. Again, this is similar to how you can get more performance out of your car by driving a manual transmission versus an automatic transmission vehicle.

However the most notable similarity is that just like most of us can’t really take advantage of the benefits of a manual transmission vehicle because the majority of our driving is sitting in traffic on the way to and from work, there is a similar harsh reality in that most sites aren’t at Google or Facebook’s scale and thus have no need for a Bigtable or Cassandra.

anonymous · Answer

MySQL, where you have at least some experience, to CouchDB, where you have no experience, means you will have to deal with a whole new set of problems and learn different concepts and best practices. While by itself this is wonderful (I am playing at home with MongoDB and like it a lot), it will be a cost that you need to calculate when estimating the work for that project, and brings unknown risks while promising unknown benefits. It will be very hard to judge if you can do the project on time and with the quality you want/need to be successful, if it's based on a technology you don't know.

anonymous · Answer

$$\LaTeX $$

anonymous · Answer

On the surface level, the main difference is that with MySQL, you use a relatively complex language, whereas with NoSQL, you have no language, and you store simple data structures instead. Also, with MySQL it is hard to change the structure of the data, should that need arise. NoSQ limits the things you can query for, but is often easier to get up to speed with. If you want something in between, which easier to learn than SQL, has the flexibility of NoSQL but not yet the speed of either, I suggest looking into SPARQL.

anonymous · Answer

So do you mean noSQL its suitable for large scale like a facebook or google 
and mysql for medium and small scale, don't you?