answersLogoWhite

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 macro call?

Nested macro calls refer to the macro calls within the macros. A macros is available within other macro definitions also. In the scenario when a macro call occurs, which contains another macro call, the macro processor generates the nested macro definition as text and places it on the input stack. The definition of the macro is then scanned and the macro processor complies it.

How do you draw entity relatoin in databases?

If the question is for databases, then the answer is in the link. If you want to store the ERDs in a database, then the question needs to be clarified to which database.

Does MySQL run on both Unix and Windows?

Yes. There are versions of MySQL for most Unix products, including Mac OS X, as well as Linux and Windows.

How can you restrict the values of data entered into a database?

By creating Data validation rules you should be able to restrict the values of data entered

Can a program be made of only one type of control structure?

Yes, a program can be made using only one type of control structure, such as only using if statements for control flow. However, this may limit the program's functionality and readability, as different types of control structures are often needed to handle various situations and logic.

How do you put today's date into MySQL database?

Use: $todaysdate = date("d/m/y"); And then just send that to the MySQL database

What is the latest version of finacle?

Finacle 10.2...released previous month..now the 10.3 will be released

Can you check symbols like star dot in MySQL database using PHP?

It is unclear what you are asking. If you want to know if you can simulate the regex ".*" behavior in MySQL, you can do so by using LIKE instead of = on the text field and using the percent sign "%" to essentially mean the same thing as .*. Something such as SELECT * FROM user WHERE username LIKE "%eri%"; would select erik, eric, erin, derik and others

What are the disadvantages of databases?

Disadvantages of databases are:

* They are overcomplicated for storage of simple and/or small data.

* They are more complex

* They are more difficult to set up initially

* Crash without saving

Can you explain the structured teamwork model by Dennis Romig?

Structured Teamwork is process where a team can develop the research proven components of great teamwork for themselves. Hence they structure or build their own infrastructure for great teamwork. The key structures are Team Creativity; Team Interpersonal Communication; Team Goals; Team Meetings; and Team Roles and responsibilities.

Structured Teamwork is in sharp contrast to the pizza party or emotional confrontational approaches which have no evidence of improving work or business results.

The book, Breakthrough Teamwork explains how team leaders or coaches can structure a team to achieve on-going breakthrough results.

Dennis A. Romig, Ph.D.

Sql statement for retrieving data between two dates in SQL Server?

SELECT aFieldName, someOtherFieldName, yetAnotherFieldName FROM aTableName WHERE fieldNameWithDateInIt BETWEEN date1 and date2

What is data collection in waterfall model?

The first part: Requirements Gathering & Analysiswhere you collect raw data & process the data into meaningful information which will be used to create software.

What is the limitations of rdbms?

Relational database management systems have various limitations. Such limitations include; high costs of setting up in buying high performance hardware for complex queries, they are not real time and they are not the best when it comes to storing data such as multimedia files and images.

Database holding details about school pupils?

  • Age
  • Name
  • Allergies
  • Sickness
  • Year Group
  • Address
  • Home Phone Number
  • Parents Work
  • Photo
  • Nationalities
  • Siblings Attending School

What is meant by a Relational table?

A relational table is a storage structure in a Relational Database Management System (RDBMS). A table consists of rows and columns. Each row is one record in the table and a column refers to the attributes/characteristics that are stored for each record. Unique identifier values are used for records so records in one table can be associated (related) with specific records in another table. Below is an example to explain this.

If you are tracking business contacts and want to track their name, email address, the name of their company and the address of the company's headquarters. If you were to do this in a spreadsheet, you would create column headings for the person's Name, Email Address, Company Name, Company HQ Address. However, if more than one person works at the same company, you have to store the Company Name and HQ Address multiple times. That is, in the record for each person at that company.

In a RDBMS, a relational table is created for Contact and another for Company. The Contact table would have columns for Contact ID, Name, Email Address and Company ID. The Company table would have columns for Company ID, Company Name and HQ Address. Instead of storing the Company information multiple times, you store the information for each Company in only one record. In the Contact table, you put the Company ID value for the Contact's Company in the Contact table's Company ID column.

Now, if the company moves, you only have to change one record in the Company table and all the Contact information is automatically associated with the right address. When the RDBMS gathers the contact information together, the Company ID serves as a pointer to the location of the Company information "related" to the contact.

What are high and low level languages?

Low level languages expose the internals of a computer's processor and allow you to take advantage of the power of that processor. Every processor has an assembler which allows you to code directly the machine language processed by the processor. This is the lowest level language available, however, the downside is that you are stuck producing code for only one processor and it will take a long time to write any significant program.

The next higher level language will be things like C, which are compiled fairly efficiently down to the machine level. C being higher level can be written and supported by many processors out there. It takes less C code to write a significant program than assembler.

The higher the level of a language the less code that is necessary to write a significant program, however, these programs are no longer efficient in terms of the amount of machine language generated. These programs often run slower and require large amounts of code to do simple things; this is counterbalanced by the ability to get complex things done with very little code. Many higher level languages are called 4GL for 4th generation languages.

A quantitative definition of 4GL has been set by Capers Jones, as part of his work on function point analysis. Jones defines the various generations of programming languages in terms of developer productivity, measured in function points per staff-month. A 4GL is defined as a language that supports 12-20 function points per staff month. This correlates with about 16-27 lines of code per function point implemented in a 4GL.