what is the difference between a MySQL, SQL, and Access database?
339559
MySQL is a web based SQL database\n\nSQL (Pronounced Sequel) is a Microsoft Product Also a database\n\nAccess is a Microsoft Product that is a database program\n\nSQL refers to the SQL Query Language and is also used to refer to Microsoft SQL\nOracle (Another Product) is also a SQL based database \n\nMySQL is for web databases\n\nMSAccess is generally meant for creating database applications and reporting but is meant for smaller amounts of data.\n\nMSSQL is designed for storing, querying, and manipulating large amounts of data. \n\nOracle is also designed for storing, querying, and manipulating large amounts of data. It's just a different brand.\n\nMany programs utilize different databases (back-ends) for different functionality.
725368
Both SQL Server and Oracle are Relational Database Management Systems. Microsoft Access is not; it is run by a jet engine instead.\n\nMicrosoft created Access in an attempt to compete with FoxPro (a product similar to Access). When Access failed to do compete with FoxPro, Microsoft bought the FoxPro company.\n\nNow for the Oracle and SQL Server, both are Relational Database Management Systems. A Relational Database Management System is capable of supporting concurrency (concurrent access to data), transactions (ablity to excute queries as an atomic block with rollback capability) so it can handle more concurrent users and it is for sure more reliable in a multiuser environment.\n\nIt is very hard to say which (Oracle or SQL Server) is better because there are so many factors that have to be taken into consideration, however SQL Server enjoyes a remarkable growth rate because it is easier to use and more cost-effective than the competing enterprise Database systems like Oracle and IBM DB2. Of course oracle and IBM DB2 have been entrenched in the enterprise for some time now , unlike SQL Server.\n\nOne last point. You can use any of the above products to handle 1000 records, However since you are still learning about Database programming, I suggest you learn either SQL Server or Oracle so that you learn some Database programming concepts like the use of Database objects such as stored procedures, triggers, transactions and so on.
793099
Works Database ? never heard it. its somekind like Microsoft Access?\n\nBut try to learn SQL. http://dev.mysql.com/doc/\nit's a powerfull language for database
114358
bigbubba is right. SQL is far more stable when multi-user access is needed.\n\nif you cannot afford a SQL server, you can use MSDE from Microsoft which is free.
227104
Microsoft Access might be a nice choice to start.  If you decide to go to something else, the database file itself can be easily converted to another database program, and it is compatible with SQL and ODBC
959154
Standard Query Language is a datbase. Database is used for storing data. This data is inturn accessed by a front-end tool.
432743
Standard SQL tends to fall under DB Programming.  When you get into store procedures you are starting to get into DBA work.  That also include database integrity, index integrity, index definitions and rebuild of the index.  DBA's are the ones who actually define the table structure and the internals of the database.\n\nDB Programming is involved with actually adding, modifying and querying the data that is stored in the database.
70564
http://dev.mysql.com/doc/refman/5.0/en/sql-syntax.html\nYour best bet is to Start with MySQL, which is an Open Source Implementation, then learn SQL and then Database Design, and shortly after you will be a full fledged DBA
228576
SQL : Structured Query Language, is the most popular computer language used to create, modify and retrieve data from relational database management systems. The language has evolved beyond its original purpose to support object-relational database management systems. It is an ANSI/ISO standard.\n \nT-SQL : Short for Transaction-SQL an extended form of SQL that adds declared variables, transaction control, error and exception handling and row processing to SQL’s existing functions. \n\nMS SQL : Microsoft SQL and its Programing Software from Microsoft
924500
Um, it's a database. You put data in it. You query data and get reports. You stick them on the net and have dynamic websites. Databases do that. However, this is Access we're talking about which is an unmitigated pile of crap. The only thing Access helps is the sale of painkillers when users repeatedly punch themselves in frustration.
1032537
Learn to use Microsoft Access and build it yourself.  You're not likely to get someone to write you a database for free.\n\nAccess has pre-built databases and wizards that spoon feed you through development.  Try it, you may enjoy it.
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.
896456
mySQL should be part of your solution.\n///
592810
SQL is sort of a standard language for querying relational databases. Visual Basic is a programming language. You can query database with it, but that is not its main function.
923309
Queries can be a very complex things, involving one or more tables of the data-base.\n\nBut any example is specific to the DataBase structure you have. You can read a lot about SQL queries in the "mysql" (http://www.mysql.com/) documentation.
1031966
Oracle\nDb2\nSQL Server \nSybase\nNCR Tera data/ PostGres\n\n\nand then you have MySQL too
546029
You must install the MySql only in the server since your php program is running only on server.\n\nbefore firing any querry start your MySql sever if it is not by default.\n\nThe accss denied problem is due to the rights may be you are not been specified in the groups to connect to MySql.\n\ndatabase server is the application software which runs only on the server like Linux, Win 2000 server.these kinds of server only listen database protocol and handle the task of data related querry eg MS-Access, Postgres etc.