Thread: Basics of Mysql.

Hey,I have just confiscated an admittance in Java die education where I penury they group incline to use My SQL database along with the island programs. Now I don't make any strain about how My Sql entirety and how to straighten tables and etc in it. I associate to say I am totally new to My Sql target. Can you guys guide me finished the principle of My Sql?

MySQL is an SQL based relational database direction scheme that runs under a large raiment of operative systems. MySQL is ofttimes utilised by PHP and Perl scripts. The SQL commands discussed in this tutorial hold to MySQL operating under all operating systems. Only the installment manual are Windows particularized. The focussing is on Windows XP Jock and Windows 2000 Professional machines. If you're using Windows 95, 98 or Me Do not run mysqld --install . These operative systems do not person the power to host a "bringing." So, you status to run MySQL as a standalone utilization by executing the code mysqld --standalone .

The MySQL command line interface permits you to put a statement on one road or locomote it crosswise sevenfold lines. There's no number in syntax between the two. Using double lines Allows you to gap mastered the SQL statement into steps you may more easily comprehend. In sixfold line style, the representative appends apiece connexion out the SQL statement. Erstwhile the semi-colon is typed in and you hit enter, the evidence is executed.

Thanks Friends..