Printable View
Hi,
I am a newbie in MySQL database. I need some information on types of database in a SQL platform. Please list all the different types same. What I am familiar about that there are some 13 types of raw data and recognized by several synonyms such valid data types. I need information on the primary data types. Also how to set a query by which the changes in the field values in specified table based on specific criteria can be updated. Thanks in advance.
You are right that the SQL data types are classified into 13 types of raw data and recognized by several synonyms such valid data types. The primary data types are BINARY used for inquiries about product accompanying table database that defines a binary data type. BIT used for Values Yes / No or True / False. BYTE used for An integer value between 0 and 255. COUNTER for An increased number automatically (Long type). CURRENCY for An integer between 922.337.203.685.477,5808 scalable and 922,337,203,685,477.5807, etc
Here are some more types of primary data used in MySQL Database. DATETIME - A date or time value between 100 and 9999. SINGLE - A value in single-precision floating point with a range from - 1038 to 3.402823 * -1.401298 * 10-45 for negative values, 1.401298 * 10 - 45 to 3.402823 * 1038 for positive values, and 0. DOUBLE - A value in double precision floating point with a range of - 1.79769313486232 * 10308 at -4.94065645841247 * 10-324 for negative values, 4.94065645841247 * 10-324 to 1.79769313486232 * 10308 for positive values, and 0. SHORT - A short integer between -32.768 and 32,767. LONG - A long integer between -2,147,483,648 and 2,147,483,647. LONGTEXT for From zero to a maximum of 1.2 gigabytes. LONGBINARY for From zero to 1 gigabyte. Used for OLE objects
Follow this to create an update query that changes the field values in a specified table based on specific criteria. Its syntax is: UPDATE Table SET Field1 = Value1, Field2 = Value2, Campon = valorN WHERE Criterion. UPDATE is especially useful when you want to change a large number of records or when they are in multiple tables. You can change several fields at once. UPDATE does not generate any results. To find out which records are going to change, we must first examine the results of a select query that uses the same approach and then run the update query.