mysql vs sql questions?

Question

if i want to make a website with a database, why would i need to know sql and not just knowing how to use mysql?

Answer 1

SQL is a (semi) standardized language for performing CRUD (Create, Read, Update Delete) operations on a database regardless of the database engine. If you know standard SQL, you would be able to perform CRUD operations on MySQL, Oracle, SQL Server, PostgreSQL, SQLite, etc. database servers. In other words, "SELECT * FROM customers WHERE id = 31" would yield the same result on MySQL, Oracle, SQL Server, etc. However, each database server has its own ways of doing some things, so performing a special query on MySQL might not work on SQL Server.



Ideally, you would be better off knowing both SQL and MySQL. But, if you want your website to use a database and perform basic CRUD operations, then knowing standard SQL is enough to get you going. Good luck!

Answer 2

To use MySQL you will

1. Need a host before you can use it

Or

2. If you use downloadable MySQL you still need to learn SQL

If you already have a host chances are you will have MySQL so Get a host for easiest experience.

Here are good free hosts:

000webhost.com

Byethost.com



Good luck

Answer 3

if you using php or other open source code, you can using mysql to simple and light weight, if you need to develop a big system with .net platform you must using sql

Answer 4

You aren't right. When you seem at your instance, you might have CHAR(4) and VARCHAR(4) truly the equal dimension. VARCHAR adds a number of bites for overhead. When you retailer 'hey in VARCHAR(ten thousand) it will block out 10001 bytes sometimes called a crap load of wasted house.