User Tools

Site Tools


start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
start [2023/04/23 15:43] – [Touchpad] adminstart [2023/08/12 13:07] (current) – [Date.js] admin
Line 107: Line 107:
     <script src="js/date.js"></script>     <script src="js/date.js"></script>
 </code> </code>
 +Date.js can be found at: https://github.com/datejs/Datejs
 +====== Sample ======
 +I used this prompt in bard:
 +generate the mysql 8 table using the following schema: id int 11 autoindex;name varchar 64;dat datetime current_time_stamp;
 +
 +And it generated the following:
 +<code>
 +CREATE TABLE `my_table` (
 +  `id` INT(11) NOT NULL AUTO_INCREMENT,
 +  `name` VARCHAR(64) NOT NULL,
 +  `dat` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
 +  PRIMARY KEY (`id`)
 +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
 +Use code with caution. Learn more
 +This table has three columns:
 +</code>
 +  * id: An integer column that is the primary key of the table. This column is automatically incremented by MySQL.
 +  * name: A string column that stores the name of the record. This column has a maximum length of 64 characters.
 +  * dat: A datetime column that stores the date and time when the record was created. This column is automatically set to the current timestamp when a new record is inserted.
 +
 +I hope this helps! Let me know if you have any other questions.
 +
 +
  
start.1682257433.txt.gz · Last modified: 2023/04/23 15:43 by admin