mysql connector odbc 5 1

1. MySQL has multiple rows that access tables. The most commonly used rows are sequential access and index access. Sequential access refers to browsing a table in one row, that is, full table scan. Disadvantage: It is very time-consuming and inefficient. Index access: Read Only the rows that show the required features, including at least one index, similar to the directory in the book. Www.2cto.com index: a

char (NOT NULL),> Sex int (4) NOT null default ' 0 ',> Degree double (16,2));2. Get the table structureCommand: DESC table name, or Show columns from table nameMysql>describe MyClassmysql> desc MyClass;Mysql> show columns from MyClass;3, delete the tableCommand: DROP table For example, to delete a table named MyClassmysql> drop table MyClass;4. Inserting dataCommand: INSERT into For example, insert two records into table MyClass, two records that say

1. Sample Problem: Log Of Failures Problem example: Fault RecordWhen INSERT fails, I want to record it in the log file to demonstrate the error handling example. I want to get an error record. When the INSERT operation fails, I want to record the error information in another file, such as the error time and cause. I am particularly interested in insertion because it violates the foreign key Association constraints.2. Sample Problem: Log Of Failures (2

Tags: databases mysql SQL databaseFirst, the cmd common MySQL related commandsmysql-d,--database=name//Open Database--delimiter=name//Specify delimiter-H,--host=name//server name-P,--password[=name]//password-P,--Port[=name]//Port number--prompt==name//Setup prompt-U,--user=name//user name-V,--version//output version numberCan be used in combination, such as input-uusernam-ppassword login user name usrname

One, the CMD frequently uses the MySQL related commandmysql-d,--database=name//Open Database--delimiter=name//Specify delimiter-H,--host=name//server name-P,--password[=name]//password-P,--Port[=name]//Port number--prompt==name//Setup prompt-U,--user=name//username-V,--version//output versionAble to use combination, such as input-uusernam-ppassword login username for usrname password for password accountII. Basic data typesIntegral type:

bracket # For example, call the stored procedure defined above Call Productpricing (); # Even without passing arguments, the parentheses "()" Behind the stored procedure name are also required The method for deleting a stored procedure is: Drop Procudure productpricing; To create a stored procedure with parameters: Create Procudure productpricing ( Out P1 decimal (8,2), Out ph Decimal (8,2), Out PA decimal (8,2) ) Begin Select min (prod_price) into PL-products

First, briefly introduce the underlying statement: 1, Description: Create a database tutorialCreate DATABASE Database-name 2, Note: Delete the databaseDrop Database dbname 3, Description: Backup SQL ServerDevice to create backup data---Use masterEXEC sp_addumpdevice ' disk ', ' testback ', ' C:mssql7backupmynwind_1.dat '---start BackupBACKUP DATABASE pubs to Testback 4, Description: Create a new tableCREATE TABLE TabName (col1 type1 [NOT NULL] [pr