{"id":2035,"date":"2015-06-09T15:16:04","date_gmt":"2015-06-09T15:16:04","guid":{"rendered":"https:\/\/raspberry-projects.com\/pi\/?p=2035"},"modified":"2015-06-09T18:09:27","modified_gmt":"2015-06-09T18:09:27","slug":"parameterized-prepared-statement-type-codes","status":"publish","type":"post","link":"https:\/\/raspberry-projects.com\/pi\/programming-in-c\/databases-programming-in-c\/mysql\/parameterized-prepared-statement-type-codes","title":{"rendered":"Parameterized (Prepared) Statement Type Codes"},"content":{"rendered":"<p>\n&nbsp;\n<\/p>\n<pre>\r\n<code>\r\nMYSQL_TYPE_TINY\r\n\tC Variable: signed char\r\n\tSQL Type: TINYINT (-128 to 127)\r\n\r\nMYSQL_TYPE_SHORT\r\n\tC Variable: short int (int16_t)\r\n\tSQL Type: SMALLINT (-32768 to 32767)\r\n\r\nMYSQL_TYPE_LONG\r\n\tC Variable: int (int32_t)\r\n\tSQL Type: INT (-2147483648 to 2147483647)\r\n\r\nMYSQL_TYPE_LONGLONG\r\n\tC Variable: long long int (int64_t)\r\n\tSQL Type: BIGINT (-9223372036854775808 to 9223372036854775807)\r\n\r\nMYSQL_TYPE_FLOAT\r\n\tC Variable: float\r\n\tSQL Type: FLOAT\r\n\r\nMYSQL_TYPE_DOUBLE\r\n\tC Variable: double\r\n\tSQL Type: DOUBLE\r\n\r\nMYSQL_TYPE_TIME\r\n\tC Variable: MYSQL_TIME\r\n\tSQL Type: TIME\r\n\r\nMYSQL_TYPE_DATE\r\n\tC Variable: MYSQL_TIME\r\n\tSQL Type: DATE\r\n\r\nMYSQL_TYPE_DATETIME\r\n\tC Variable: MYSQL_TIME\r\n\tSQL Type: DATETIME\r\n\r\nMYSQL_TYPE_TIMESTAMP\r\n\tC Variable: MYSQL_TIME\r\n\tSQL Type: TIMESTAMP\r\n\r\nMYSQL_TYPE_STRING\r\n\tC Variable: char[]\r\n\tSQL Type: TEXT, CHAR, VARCHAR\r\n\r\nMYSQL_TYPE_BLOB\r\n\tC Variable: char[]\r\n\tSQL Type: BLOB, BINARY, VARBINARY\r\n\r\nMYSQL_TYPE_NULL\r\n\tC Variable: \r\n\tSQL Type: NULL\r\n<\/code><\/pre>\n<p>\n&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; MYSQL_TYPE_TINY C Variable: signed char SQL Type: TINYINT (-128 to 127) MYSQL_TYPE_SHORT C Variable: short int (int16_t) SQL Type: SMALLINT (-32768 to 32767) MYSQL_TYPE_LONG C Variable: int (int32_t) SQL Type: INT (-2147483648 to 2147483647) MYSQL_TYPE_LONGLONG C Variable: long long int (int64_t) SQL Type: BIGINT (-9223372036854775808 to 9223372036854775807) MYSQL_TYPE_FLOAT C Variable: float SQL Type: FLOAT [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73],"tags":[],"class_list":["post-2035","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/posts\/2035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/comments?post=2035"}],"version-history":[{"count":2,"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/posts\/2035\/revisions"}],"predecessor-version":[{"id":2045,"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/posts\/2035\/revisions\/2045"}],"wp:attachment":[{"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/media?parent=2035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/categories?post=2035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/tags?post=2035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}