A strange problem of time format

here"s the thing:

the program prompts: Incorrect datetime value:""2018"-"05"-"23"11": "42": "53 "for column" time" at row 1

when inserting records into the database."

later, I copied the prompt "2018"-"05"-"23"11": "42": "53", and then manually inserted it into the database. After saving, the result "2018 "-" 05 "-" 23 "" 11 ":" 42 ":" 53 "automatically became" 0000-00-0000: 0000". Then I typed "2018"-"05"-"23"11": "42": "53"
and then I could insert it normally.

but there is no difference between "2018"-"05"-"23"11": "42": "53" in the error prompt and "2018"-"05"-"23"11": "42": "53" that I hit by hand. I compared two strings with svn, and they were really different, but I couldn"t see the difference. And ask the gods for advice. Thank you!

the following is the error time (the gods can copy it and insert it into the database for a try):
2018 "-" 05 "-" 23 "" 11 ":" 42 ":" 53

the following is the hand time:
2018-05-23 11:42:53

Javascript mysql

Mar.13,2021

'2018-05-23 11:42:53'.split('').map(v => v.charCodeAt(0))

/*
[50, 48, 49, 56, 8206, 45, 8206, 48, 53, 8206, 45, 8206, 50, 51, 8206, 8206, 32, 8206, 49, 49, 8206, 58, 8206, 52, 50, 8206, 58, 8206, 53, 51]
*/

printed, mixed with strange things with a Unicode code point of 8206?

look up what is left to right symbol .

you can look it up like this:


										
												Previous: I do a paged content in Vue, that is, click on different page numbers to show different content, how should I do it?
												                		Next: Mini Program guide page instruction button, hidden to the last picture, there is a jump button
                							
					
						
					
															
						
														
								The mysql table clearly has data, why does it return an empty array when extracting the data?
								
 ask the elders, want to extract the user name and password from the mysql to verify the login, the mysql table clearly has data, but the request is to return an empty array, check the database statement can not see the problem, I would like to ask the s...
								
									
																														Express
																				node.js
																				backend
																				javascript
																				mysql
																			
									
										Mar.04,2021
									
								
							
														
								On the problem of mobile front-end cache
								 at present, business is a very common news. App, wants to cache the news after getting the news data, and it will also cache when switching between different columns. Because I chose vue, I saved the data in vuex. Can achieve the desired effect, but if t...
								
									
																														Javascript
																				mysql
																				html5
																			
									
										Mar.06,2021
									
								
							
														
								How to insert the array structure Sequelize at one time?
								
var data = [{
  id:1
}
,{
  id:2
}
,{
  id:3
}]
 is similar to this structure. An element object in  data  corresponds to a record in a database table.  then  Sequelize  how to do it all at once? 
...
								
									
																														Javascript
																				mysql
																				vue.js
																				node.js
																				sequelize
																			
									
										Mar.10,2021
									
								
							
														
								About the problem of PHP receiving emoji conversion storage?
								
 encountered a problem when typing emoji on the phone (unable to store it in the database).  the reason for the utf8mb4 of the database when it is found after searching for the problem (because emoji is 4 bytes, while utf-8   s database is 3 bytes).  the...
								
									
																														Php
																				javascript
																				mysql
																			
									
										Mar.11,2021
									
								
							
														
								Questions about mysql foreign key queries, such as the following figure and code
								
< H2 > set up two tables as follows. How can curd change the two tables at the same time, that is, query the data of the two tables? in addition, do you use this method much in the actual project <   H2 >?
< H2 > my_class <   H2 >
CREATE TABLE `my_class`...
								
									
																														Python
																				java
																				php
																				javascript
																				mysql
																			
									
										Mar.13,2021
									
								
							
														
								I would like to ask you how a given address can be divided into separate administrative divisions of provinces, cities and regions. I have been thinking about it all day without any ideas.
								
 ask for help from seniors: if the long address is xxxx, Nanjing Road, Heping District, Tianjin 
 how can it be dealt with by means of no manual intervention: Tianjin; Heping District; Nanjing Road; this kind of administrative division? 
 because the inp...
								
									
																														Java
																				php
																				javascript
																				mysql
																				python
																			
									
										Mar.13,2021
									
								
							
														
								I want to write an e-commerce site with php, js, mariadb (mysql), but I have a big problem with "update"!
								
 I want to be an e-commerce website.  is paired with php + mysql . Now I have a big problem . At present, I intend to do a customized service , that is, this set of e-commerce websites are sold directly to you, and all the functions are maintained by me....
								
									
																														Mariadb
																				javascript
																				mysql
																				php
																			
									
										Mar.21,2021
									
								
							
														
								Problems encountered in the implementation of joining the shopping cart after Vue violently updated the view.
								
1. express: 
  Link description   https:  api.billson.club api .
2. appID

3. vuex

 

 
...
								
									
																														Javascript
																				mysql
																				express
																			
									
										Mar.28,2021
									
								
							
														
								Mongoose Association query
								 when you associate with mysql, you can use id to associate, and you can store two tables during the same database operation. Because the primary key id can be self-increasing and is not affected by other factors, the two tables can be associated with id,...
								
									
																														Javascript
																				mysql
																				node.js
																				mongoose
																				mongodb
																			
									
										Jul.07,2021


				
					
						
	
						
		css
		mysql
		arrays
		josn
		react
		html
		typescript
		webpack
		npm
		sass
		R
		objective-c
		.net
		sql-server
		jquery
		python-3.x
		angularjs
		django
		angular
		excel
		regex
		iphone
		ajax
		linux
		xml
		pandas
		vba
		spring
		database
		wordpress
		string
		wpf
		xcode
		windows
		bash
		postgresql
		oracle
		multithreading
		eclipse
		list
		firebase
		algorithm
		macos
		forms
		image
		scala
		visual-studio
		azure
		bootstrap
		spring-boot
		react-native
		python-2.7
		docker
		performance
		function
		winforms
		matlab
		powershell
		apache
		dataframe
		api
		sqlite
		numpy
		rest
		shell
		selenium
		flutter
		dart
		maven
		loops
		qt
		swing
		android-studio
		csv
		express
		file
		class
		tensorflow
		sorting
		codeigniter
		perl
	
						MySQL Query :  SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5 
 MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3e429-2b761.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") 
 MySQL Errno : 1021 
 Message :  Disk full (/tmp/#sql-temptable-64f5-1b3e429-2b761.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") 
Need Help?