What’s the difference between  SQL and mySQL?

Is there any difference between calling it a clause versus a statement in mysql that we should know of? 

Can we please go over in more depth about client-server architecture and the difference between the mySQL server and mySQL clients?

Can you clarify the client-server architecture of MySQL? Is MySQLd running separately on a server, which we then connect to as clients when we use MySQL?

What do you mean by "There can be multiple tables" in a Relational DBMS like MySQL?

I understand that a database is a collection of tables and that a DBMS manages many databases. Does each table in a database represent a specific set of data, such as the student list for Wellesley College?

Just a clarifying question- Is there a table for each separate database in a rdbms? And is there a big difference between accessing information across different databases in a rdbms vs a non-relational dbms?

Can I select information from more than one table at once to use in a query?

How do we search for rows that may include certain words / numbers? Can we use a wildcard like with Unix?

Can different rows have different input types for one specific column? E.g for the birthdate column can one row have it set to 10/15/1999 and another set theirs to December 25th, 2005? Or does it all have to be the same format/type?

I understand the different queries that you can use to look up certain rows in the tables but is there a way to actually edit the values in the tables via a batch file for example?

How would we construct the table which queries are getting the information out of?

For a batch file, can you use the "USE" command and the query commands twice to get information from two different databases in one file?

Are you able to store more than just numbers and strings into a cell?

Could you explain more about what a client-server Architecture is?

If we test for equality using a single equals sign, not two, how do we assign/what do we use to assign a value?

Also, how are batch files different from Python files? In other words, what aspect/feature of batch files makes them worthy of their own label? Can't we run multiple lines of commands in Python as well?

Is the date/time a special type of variable/sth different from a regular number?

Does the source method not exiting the MySQL Interpreter mark any differences at times during operation or is it just a personal preference?

What does it mean printed differently in ""It doesn't say that the database has changed. That's because things are printed differently.""

What are some of the best practices for optimizing the performance of mySQL queries while working with huge complex databases?