Module 3: Manipulating a Database

What does the following command do?

 ALTER TABLE horse_gear MODIFY num_code MEDIUMINT(9) PRIMARY KEY NOT NULL AUTO_INCREMENT, MODIFY feed CHAR(15) NOT NULL, CHANGE saddles_bridles tack CHAR(20) NOT NULL, ADD blanket ENUM( 




			
		
		

		


		
Previous page
Table of content
Next page
		
 

    

	
MySQL: Essential Skills
	
    
ISBN: 0072255137
EAN: 2147483647
	 
Year: 2006
Pages: 109
	 
Authors: John  Horn, Michael  Grey, LLC Interstate Software
	 
BUY ON AMAZON
  
	
	 


   
  
  



  

  

  

				
Introducing Microsoft Office InfoPath 2003 (Bpg-Other)
				
Filling Out Forms
Validating Form Data
Adding Views to a Template
Connecting Forms to Databases
Introducing InfoPath Form Template Projects

				
The .NET Developers Guide to Directory Services Programming
				
Searching with the DirectorySearcher
Managing Passwords for Active Directory Users
Primary Group Membership
LDIFDE
Error 0x8007052E: "Login Failure: unknown user name or bad password."

				
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
				
Managing Project Constraints and Documenting Risks
Quantifying and Analyzing Activity Risks
Managing Project Risk
Closing Projects
Conclusion

				
VBScript Programmers Reference
				
A Quick Introduction to Programming
Classes in VBScript (Writing Your Own COM Objects)
Regular Expressions
Adding VBScript to Your VB Applications
Appendix B Variable Naming Convention

				
Managing Enterprise Systems with the Windows Script Host
				
Shell Operations
Registry Operations
Network Administration/WMI
Messaging Operations
System Administration

				
Web Systems Design and Online Consumer Behavior
				
Chapter IV How Consumers Think About Interactive Aspects of Web Advertising
Chapter VI Web Site Quality and Usability in E-Commerce
Chapter IX Extrinsic Plus Intrinsic Human Factors Influencing the Web Usage
Chapter X Converting Browsers to Buyers: Key Considerations in Designing Business-to-Consumer Web Sites
Chapter XIII Shopping Agent Web Sites: A Comparative Shopping Environment




	 

	 

      

	 	flylib.com © 2008-2017. 
If you may any questions please contact us: [e-mail]
		
 

		Privacy policy 
		
    
    
    
  
  










This website uses cookies. Click here to find out more. 

Accept cookies


  

  

1.	How do you make a copy of the table wolfhounds , including its data?
2.	If you have a table called sport and it has the fields football , basketball , soccer , and hockey , how do you make a table called ballgames without the hockey field?
3.	What kind of table resides in memory and lasts only as long as the MySQL Client s current connection?
4.	What does the following command accomplish? LOAD DATA INFILE '\documents\games_stats.txt' INTO TABLE stat_sheet FIELDS TERMINATED BY ':' LINES TERMINATED BY '\r\n';
5.	What are the four options for the ALTER TABLE command and what to they do?
6.	What command inserts only entire records into a table?
7.	What does a table need to have in order to use the REPLACE INTO command and avoid inserting duplicate records?
8.	What do you type on the command line to temporarily turn off the safe-updates option?
9.	Which command allows you to insert data into specific fields within records?
10.	What does the following command do? UPDATE wine_list SET color="red" WHERE variety="Merlot";
11.	Which command(s) removes a table and which command(s) removes only the data in the table?
12.	How is TRUNCATE different from DELETE ?
13.