0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
Can you join a table to itself?
Yes. In MySQL you can join a table to itself. You must use different alias name for each instance.
What would you have to do to a table in a Microsoft Word to make it look like a tabbedlist?
Use the Convert to Text option in the Table options and use the Tab as the delimiter to separate what was in each cell on a row.Use the Convert to Text option in the Table options and use the Tab as the delimiter to separate what was in each cell on a row.Use the Convert to Text option in the Table options and use the Tab as the delimiter to separate what was in each cell on a row.Use the Convert to Text option in the Table options and use the Tab as the delimiter to separate what was in each cell on a row.Use the Convert to Text option in the Table options and use the Tab as the delimiter to separate what was in each cell on a row.Use the Convert to Text option in the Table options and use the Tab as the delimiter to separate what was in each cell on a row.Use the Convert to Text option in the Table options and use the Tab as the delimiter to separate what was in each cell on a row.Use the Convert to Text option in the Table options and use the Tab as the delimiter to separate what was in each cell on a row.Use the Convert to Text option in the Table options and use the Tab as the delimiter to separate what was in each cell on a row.Use the Convert to Text option in the Table options and use the Tab as the delimiter to separate what was in each cell on a row.Use the Convert to Text option in the Table options and use the Tab as the delimiter to separate what was in each cell on a row.
How the primary key is declared in MySQL?
Its best to choose an ID for each table to use as the Primary Key (PK). This is best as an INT due to speed.
Data base system?
System that store data that is related to each other are known as database system. Example of database system : mysql, sql+, oracle etc.
Why is it better to store data in multiple related table rather than one big table?
Basically to minimize redundancy (unnecessary repetition) of data in the database. By storing only information (fields) that directly relate to each other in each table AND modeling how the tables should relate to each other you also get the maximum flexibility in ways to retrieve information. A simple example would be a table to store INVOICES and a table to store CUSTOMERS. The INVOICE table only has information about an invoice; Inv#, Amount, Date, etc. and The CUSTOMER table information about customers; Name, Address, Phone, etc. An Invoice has one customer but a customer can have many invoices. If we give the customer a unique ID then, in the INVOICE table we need only store that ID (called a foreign key) but with it the database can look up the rest. So you dont store customer name, address, etc over and over again every time a customer gets a new invoice. The process of splitting up data into separate structures is called normalization. Often times data is de-normalized and repeating data allowed for performance or snapshot reasons.
What is a Trigger in MySQL Define different types of Trigger?
A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an update. A trigger is associated with a table and is defined to activate when an INSERT,DELETE, or UPDATE statement for the table executes. A trigger can be set to activate either before or after the triggering statement. For example, you can have a trigger activate before each row that is deleted from a table or after each row that is updated. Sender : Yugant khokhar
Can you sort more than one column at a time using Excel?
No, you can sort multiple columns or rows if you hightlight a range, but all columns or rows will need to be sorted with the same criteria (e.g. lowest to highest). You can sort an entire row by clicking on the row number at the left of the screen, then sort, as desired. You also can do the same for columns by clicking on the column letter at the top of the screen.
The collection of related records called as file or table?
A table is a collection of related records in a database. Each record in a table represents a specific entity or object, and each column in the table represents a specific attribute or characteristic of that entity. Tables are used to organize and store data in a structured and efficient manner.
Word 2007 how to insert a table next to a table on the right?
There are lots of ways to do it. You can create a table across the page and then remove some of the vertical borders in a middle column, which will make it look like it is two separate tables. You could create two tables and then change the formatting to the page to have two columns and so have two tables beside each other. You could make one large table with just two cells that are beside each other. Then into each cell you would put a table, resulting in you having two tables beside each other.
In a database a table is a collection of related?
In a database, a table is a collection of related data organized in rows and columns. Each row represents a record, and each column represents a field or attribute of that record. Tables are used to store, retrieve, and manipulate data efficiently.
How do switches know which device is connected on which circuit?
switches will monitor the frames sent from each interface and it will store the source MAC-addresses in a table. fm
In a table the specific field names are displayed at?
At the top of each column of each table.
