Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-calendar.html
Monday Tuesday Wednesday Thursday Friday Saturday Sunday 1 2 3 4 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 There are no dates between October 4 and October 15. Any dates before the cutover are Julian, and any dates following the cutover are ... MySQL uses what is known as a proleptic Gregorian ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
FOR UPDATE, and so on) consistent between the different transactions or applications that experience the issue. Error number: 1217; Symbol: ER_ROW_IS_REFERENCED; SQLSTATE: 23000 Message: Cannot delete or update a parent row: a foreign key constraint ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-23.html
Also, with the implementation of the new mechanism, a getObject(columnIndex) call on a DATETIME column returns a LocalDateTime object now instead of a String. While a java.sql.TIME instance, according to the JDBC specification, is not supposed to ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-type-conversions.html
If set to true (the default), then the returned object is of type java.sql.Date. MySQL Connector/J is flexible in the way it handles conversions between MySQL data types and Java data types. In general, any MySQL data type can be converted to a ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-stored-proc.html
A stored procedure is a set of SQL statements that is stored in the server. Clients make a single call to the stored procedure, passing parameters that can influence the procedure logic and query conditions, rather than issuing individual hardcoded ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-select.html
The task is to select all employees hired in the year 1999 and print their names and hire dates to the console. Note that we are using unquoted %s-markers where dates should have been. The first column in the row is stored in the variable ... The ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-stored-proc.html
A stored procedure is a set of SQL statements that is stored in the server. Clients make a single call to the stored procedure, passing parameters that can influence the procedure logic and query conditions, rather than issuing individual hardcoded ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-select.html
The task is to select all employees hired in the year 1999 and print their names and hire dates to the console. Note that we are using unquoted %s-markers where dates should have been. The first column in the row is stored in the variable ... The ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-annotations.html
In ClusterJ (as in JPA), annotations are used to describe how the interface is mapped to tables in a database. The annotation @PersistenceCapable(table="employee") is used to let ClusterJ know which database table to map the Employee to (in this ...