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






False


Django, Why does the system automatically generate an empty session? every time the request is made?


Use python to convert dict1 to dict2, in the example. I tried for a long time but couldn't find a solution.


How to self-start the php-fpm service when building a LNMP environment with docker?


Can an array in react state be bound to a dom state using an element in the array?


Wechat browser version 6.6.5 cannot prevent the springback of pull-up and drop-down to the top under ios system.


In express+hbs, how do you define the routed data as a variable on the page?


How to use symbol reference of Iconfont in dva


How to elegantly add data to JSON objects?


Using node to build video streaming server


The proportional width of the echarts graph is inconsistent.


React uses axios to call the background data. After success, how to jump to the page based on the returned value?


I don't understand what a linux command means. Please explain it.


Vue introduces multiple components in vue-router by nesting named views, and does not refresh the same reference in other pages.


Running nodejs reports fewer errors ")"



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



What exactly is the working memory and main memory of the jvm memory model? On what level is the division made?


I would like to ask vue to use the modal box to pop up the sub-assembly, is there any example?


Discussion on Entity and DTO


The problem with vue $index?


Baidu map API map.removeOverlay () can not clearly marker




© 2021 CodesHelper


Advertising
Contact us
About us


Menu