differences between sql and mysql?
823091
SQL stands for Structured Query Language.... it is the language used to create, modify and report relational databases. It is not specific to an implementation of the language.... MySQL is a relational database manager that uses SQL to manage and use the databases. Just as Microsoft SQL Server does the same on a Windows NT Server. However, MySQL lacks the GUI tools that shield you from the complexities of having to type out all the SQL commands.
834471
you can download from \nhttp://dev.mysql.com/downloads/mysql/5.0.html\n\nPlzz rate it.....
520840
It would be helpful to know what version of SQL you want.\n\nFor Transact-SQL (Microsoft): http://msdn.microsoft.com\n\nFor MySQL: http://forums.mysql.com/\n\nFor PL/SQL (Oracle): http://education.oracle.com/
1011783
Select {columns}\nfrom {tables}\nwhere {conditions}\n\nIt is the structure of a language meant to grapple with tables and columns instead of files and fields.
570376
approach to what?  some more clarification would help.\n\nif you're creating a small site or program, a file-based approach may be easier, especially if the data doesn't move/change a lot.  a database makes manipulation of the data a lot easier.  if you're using mysql or psql or somesuch, you don't have to recreate the wheel in parsing data files to get to the data you want.  if you only have a few lines of data to store, then a file might do, but once you start getting into thousands of records a database makes more sense.  mysql is very fast at finding exactly what you want, whereas parsing through a large text file to find the lines you want can become very labor intensive, especially when you need to write or delete records.
25643
I've included some helpful links listing SQL commands.  Note that some may depend on what specific database you're using (Access, MySQL, PostgreSQL), so you should check the reference for that product.
1090651
Sure, it's easy to use.\n\nSee http://www.connectionstrings.com/ for an example of a MySQL connection string.\n\nGo to http://dev.mysql.com/downloads/connector/net/1.0.html to download a .NET MySQL connector.
831632
I am actualy making my own as i type this. It's taken me 3 weeks so far, but im using PHP to do my coding. MySQL as the database software,a nd PHP for the coding. It's coming along nicely. \n\nif you need some ideas, go to..\n\nwww.vbulletin.com\nwww.phpbb.com\nwww.punbb.org\nwww.simplemachines.org\n\nhope those ehlkp
1068469
download MySQL query browser and MySQL administrator from the mysql.org site. They're free and easy to use.
55523
You will have to use some scripting language, \nI advise you to use PHP with MySQL. \nBut also there are a LOT of created sollutions. Just look out for login script or even you can try with some CMS like Joomla, Mambo, PHPnuke, XOOPS ........ witch already have implemented loging feature.
254673
The best way to learn SQL is by using it. The four basic things you need to know are Select, Insert, Update, and Delete. \n\nSELECT [columns to select] FROM [table] [where] [order]\n\nINSERT INTO [table] ([names of fields to insert]) VALUES ([values to insert into respective fields])\n\nUPDATE [table] SET [field name 1]=[value 1], [field name 1]=[value 1] [where]\n\nDELETE FROM [table] [where]\n\n\n[table]-> the table you want to modify\n[field or column name]-> the column in the table you want to modify\n[where]-> tell which rows of the table to modify. Usually looks like "WHERE ID=1" or "WHERE ID like '%1%'" or "WHERE ID IN (1,2,3,4,5)"\n[order]-> the order by clause tells how the values should be ordered. "ORDER BY Create_Date" or "ORDER BY Create_Date DESC"\n\nThat should get you started. Then look at Joins, nesting, etc. Good luck!!
542676
SQL is used to look at and update data. The primary commands are SELECT, UPDATE, INSERT, DELETE. As programming topics go, basic SQL is as easy to master as anything.
573982
MySQL is a good, free, open source database.  If you're going to go that route, you'll want to use one of these two free programs to configure and use mysql more easily.\n\nhttp://cocoamysql.sourceforge.net/\n\nhttp://yoursql.ludit.it/
1060571
Do you get an exception error?\n \nI would need to see the SQL statement to see what is wrong with it. If it is executing the query, but you dont see the changes, then there is something wrong with the SQL statement.
890064
xml & mysql were built with the same idea... simple tables with rows and fields.... \n\nI wrote one this program long ago... and I can't find it anymore but...\n\nI googled for "mysql xml import" and found thousands of examples and simple programs!\n\nenjoy!
206160
My guess is MySQL from looking at the front page of mysql.com.  I doubt they have only 1 solution for their entire company though.
504894
Somehow u're right, MySQL is a multithreaded, multi-user, SQL Database Management System (DBMS). MySQL is popular for web applications such as MediaWiki or PHP-Nuke and acts as the database component of the LAMP and WAMP platforms (Linux/Windows-Apache-MySQL-PHP/Perl/Python). Its popularity as a web application is closely tied to the popularity of PHP, which is often combined with MySQL and nicknamed the Dynamic Duo. It is easy to find many references that combine the two in websites and books (PHP and MySQL for Dummies, PHP and MySQL Bible, Beginning PHP and MySQL, etc.) The claim made in many books is that MySQL is easier to learn and use than many other database applications. An example from the Dummies book is that you can quit MySQL with an obvious command of either exit or quit, although this is true for many other database applications.