0
MySQL
MySQL is a Relational Database Management System. It was first released in 1995 and is most commonly used with the PHP programming language. MySQL is open source and 100% free to use.
526 Questions
What is the easiest way to learn Espanol?
Go to Mexican speaking restaurants as often as possible. Watch as many shows and movies in Spanish as you can, also the children show Dora The Explorer is a great way for some people to learn the language. Some teachers believe that the best way to learn any language is to give a spelling test of some sort every other day, but that is actually the worst way to learn. Te best way is to learn the language is by taking a test at the end of every week.
What are the diffeneces between a files processing system and a Data base management system?
- A database coordinates the physical and logical access to the data; a file-processing system only coordinates physical access to the data
- A DBMS reduces the amount of data duplication
- A DBMS is designed to allow flexibility in what queries give access to the data, where a file-processing system only allows pre-determined access to data (by specific compiled programs)
- A DBMS is designed to coordinate and permit multiple users to access data at the same time. A file processing system is much more restrictive in simultaneous data access
What is database server and how they works?
A database is a collection of tables in which large quantities of data (information) can be stored. The question and answer you are looking at right now are both stored in a database, for example.
Databases are used by applications (like websites) to store and retrieve data.
How does Apache MySQL and PHP work together?
Let me answer from less 'technicall' point of view.
Apache is the HTTP server. It gets the HTTP requests and answers with the HTML code. PHP is used to generate this HTML dynamically on server side. MySQL is used by PHP for getting the data.
Once the Apache HTTP server gets the request for the page with php (or php3, php4, phtml or whatever is configured in Apache's config file), it calls PHP interpreter to generate HTML. Then this HTML is returned to the client - internet browser which sent HTTP request.
PHP has got an access to MySQL DB via several APIs. This simply means, that you can just call some function in PHP script to select, import update or delete some data in a table of DB. You can also maintain the DB, create, delete new tables a.s.o. There is a lot of functions for that ;)
What is the difference between a simple query and a complex query?
A simple search is one based on a single term or criterion.
ER Diagram for a railway management system?
there are three entities involved station railway and passengers railway has station nd attributes of railway are railway no. railway name railway type and railway seats and station attributes are waiting room,office,canteen,station id
What is total participation in database management?
Participation (or optionality) concerns the involvement of entities i a relationship. Participation is about exceptions to the rule. An entity's participation is optional if there is a least one instance of an entity which does not participate in the relationship. An entity participation is mandatory if all instances of an entity must participate in the relationship.
In VHDL, entity is the keyword for defining a new object. In SGML and its derived markup languages HTML and XML, an entity is a named body of data associated with a document. Once defined, an entity can be referenced any number of times within the document, via entity references. An entity typically consists of a sequence of one or more characters, either encapsulated within a declaration of the entity's existence, or encoded and stored externally in a text file. Such entities and their references are comparable to macros and include files in programming languages. However, entities don't necessarily have to contain parseable text; they may also be binary files that are included in a document only by reference, with the entity name as the value of an ENTITY-type attribute.
Answer:
An entity is something that has a distinct, separate existence, though it need not be a material existence. In particular, abstractions and legal fictions are usually regarded as entities. In general, there is also no presumption that an entity is animate. Entities are used in system developmental models that display communications and internal processing of, say, documents compared to order processing.
An entity could be viewed as a set containing subsets. In philosophy, such sets are said to be abstract objects.
Sometimes, the word entity is used in a general sense of a being, whether or not the referent has material existence; e.g., is often referred to as an entity with no corporeal form, such as a language. It is also often used to refer to ghosts and other spirits. Taken further, entity sometimes refers to existence or being itself. For example, the former U.S. diplomat George F. Kennan once said that "the policy of the government of the United States is to seek . . . to preserve Chinese territorial and administrative entity.
Answer:
An entity is a legally recognized and formally structured grouping of people focused on some common cause or objective.
Examples
Here are some examples of entities:
SIL
an SIL branch
UNESCO
Oracle includes numerous data structures to improve the speed of Oracle SQL queries. Oracle includes many new indexing algorithms that dramatically increase the speed with which Oracle queries are serviced like b-tree index, bitmap indexes, function-based indexes, and index-only tables (IOTs
Oracle uses indexes to avoid the need for large-table, full-table scans and disk sorts, which are required when the SQL optimizer cannot find an efficient way to service the SQL query. I begin our look at Oracle indexing with a review of standard Oracle b-tree index methodologies.
What is the maximum database storage capacity of MySQL?
It all depends on the type of MySQL database you wish to use and also the operating system the server has. Most of the restraints are due to the max file size the operating system can store. The limits are done by table size rather than the database size as a whole.
- Win 32 w/ FAT/FAT32 - 2GB/4GB
- Win 32 w/ NTFS - 2TB (possibly larger)
- Linux 2.2-Intel 32-bit - 2GB (LFS: 4GB)
- Linux 2.4+ - (using ext3 file system) 4TB
- Solaris 9/10 - 16TB
- MacOS X w/ HFS+ - 2TB
- NetWare w/NSS file system - 8TB
InnoDB tables are often split up into multiple files to allow larger tables, this is known as a tablespace. The maximum table space is 64TB.
MyISAM tables default size is at 4GB, but this can be changed to a maximum of 65,536TB.
What is Schema in the term of Database Management System?
Schema means structure of the databse. Like, tables, constraints, relation
What is difference between MySQL server MsSQL?
MSSQL is the abbreviation for the Server system Microsoft has.
Compared to MySQL, which is the SQL server system that is open source, maintained by the MySQL company (Now owned by Sun).
The Database Approach has four common characteristics. These are: Self-describing nature, support multiple user view of data, share the data and multiple user transaction processing and insulation between data and data abstraction.
Is MySQL a programming language?
MySQL was written and developed using the C and C++ programming languages.
What is the difference between mysql server and oracle server?
While these three products are very similar, there are some differences. MySQL does not have a GUI interface while the other two do, it is also the only open source product of the three. SQL Server only runs on Windows, while the other two run on a variety of operating systems. Language support differs among the three, with each having some unique language support.
It's free.
Widely used, so there is plenty of support, examples, tutorials.
Better at performing some tasks such as jumping to records without first cycling through the previous records.
It runs on Windows, Windows Server and *nix machines
It is continually being improved (ongoing development)
It can use transactions (ie rollback several update/inserts, if something fails)
Supports live backups, table locking, basically anything any other database can do.
ER Diagram for a airline management system?
The diagram for airline reservation system can be found by doing an internet search. It includes the day of the week and the flight.
Why we are using oracle instead of mysql?
This question is very broad subject and in few lines, we should not answer... For the answer, you must have through idea/knowledge about the Organization like, Budget, IT, Technical Competencies, Capacity Planning, IT infrastructure... If any of the above mentioned area is lacking with funds then you may compromizing with the quality, security or the productivity... In the market, you may find so many products which are promising to handle your organizations Data Management but the best RDBMS is Oracle... Hope it helps... Cheers !!
Star Nirav
+91 9227258878
