Solution to the problem that SQL database query result field contains new line character, which leads to copy to excel dislocation

Problem description:
in the process of work, sometimes encountered such a problem, write a SQL query to query data in the database, see the number of rows (such as 1000 rows), but make a copy of the query results to Excel, but happened mismatch, and lead to Excel in the number of lines is more than 1000 lines, caused the number of rows of data inconsistency.

field value contains char(10) newline character, copy the field value to Excel.
Source:
some corresponding cell contains a newline, lead to dislocation happened in copy to Excel.

Option 1 (Recommended) : Enclose the field values in question in double quotation marks so that the newline characters in the field values are restricted to the correct Excel cell.
scenario 2: use the script to remove the corresponding field value newline character.
create table #t
(
Name nvarchar(50),
Remark nvarchar(50)
)

insert into #t
lues (‘ A1 ‘+ char(10) +’ B1 ‘, ‘row 1’), (‘ A2B2 ‘, ‘row 2’)

select Name, Remark
om #t
— Solution 1: You can put double quotation marks directly in the field, and copy it to Excel without misplacing or showing redundant double quotation marks.
select ‘”‘ + Name + ‘”‘ as Name, Remark
om #t

select replace(replace(Name, char(13), ‘ ‘), char(10), ‘ ‘) as Name, Remark
om #t
drop table #t

Runtimeerror using Python training model: CUDA out of memory error resolution

RuntimeError: CUDA out of memory occurs using the PyTorch training model
Training: Due to the limited GPU video memory resources, the batchsize of training input should not be too large, which will lead to Out of Memory errors.
Solution: Reduce the batchSize to even 1
Use with torch.no_grad():fore testing the code

ValueError: not enough values to unpack (expected 6, got 1)

This is a problem that comes up all the time when dividing data sets by emoji labels.
The code is:

angle, idx, _, gender, expression, gaze = image_name.split('_')

The format of image_name is: dataset000_01_caucasian_female_angry_left.jpg
There have been some errors running on the server

ValueError: not enough values to unpack (expected 6, got 1)

Solution:
Later, it was found that after decompressing the data set in the unified format, the zip file was not deleted after the execution of the unzip command, so it was not easy to find. The main reason for this problem is that the file name of the compressed price can not be divided into 6 parts, so the error has been reported.
Delete the ZIP file.

ValueError: not enough values to unpack (expected 2, got 0)

ValueError: not enough values to unpack (Expected 2, got 0) sometimes appears when reading TXT files. The reason I found myself is that there are several blank lines at the end of the TXT file. Delete the last blank line and make sure that the last line is the text you want to read. The TXT file looks like nothing if you press Enter at the end, but those empty lines actually have one character, the newline \n, so there can be no empty lines.
 

Just like that the blank line between the cursor and the text actually has a newline character on each line.
Click Backspace to go back to your last line of text. Press the direction key of the keyboard cursor can not get down.

Python3-ValueError:not enough values to unpack (expected 2, got 0)

Python3-valueError :not enough values to unpack (expected 2, got 0)
Specific errors are as follows:

Traceback (most recent call last):
  File "/Users/zhangsf/code/python/my-project/Subsidy.py", line 83, in <module>
    xy1.boxplot(column='ranking', by='subsidy')
  File "/Users/zhangsf/anaconda3/lib/python3.7/site-packages/pandas/plotting/_core.py", line 2254, in boxplot_frame
    return_type=return_type, **kwds)
  File "/Users/zhangsf/anaconda3/lib/python3.7/site-packages/pandas/plotting/_core.py", line 2223, in boxplot
    return_type=return_type)
  File "/Users/zhangsf/anaconda3/lib/python3.7/site-packages/pandas/plotting/_core.py", line 2682, in _grouped_plot_by_column
    keys, values = zip(*gp_col)
ValueError: not enough values to unpack (expected 2, got 0)

It means that python expected there to be two return values from zip(), but there were none.
Error: This means that Python expects zip () to return two values, but neither
The error statement is:

xy1.boxplot(column='ranking', by='subsidy')

The reason is that there is a problem with the imported data, which causes the ranking of the column to be NaN and no return value
Just re-introduce the correct data
 

Running Python 3.7 web.py Runtimeerror: generator raised stopiteration exception occurred during test

When I first started learning Python, I found an exception when I ran the web.py home page test code.
The code is as follows:

import web
        
urls = (
    '/(.*)', 'hello'
)
app = web.application(urls, globals())

class hello:        
    def GET(self, name):
        if not name: 
            name = 'World'
        return 'Hello, ' + name + '!'

if __name__ == "__main__":
    app.run()

The exceptions are as follows:

Traceback (most recent call last):
  File "C:\Users\HHHHH\AppData\Local\Programs\Python\Python37-32\lib\site-packages\web\utils.py", line 526, in take
    yield next(seq)
StopIteration

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "D:\workspace\HelloPython\Helloworld.py", line 7, in <module>
    app = web.application(urls, globals())
  File "C:\Users\HHHHH\AppData\Local\Programs\Python\Python37-32\lib\site-packages\web\application.py", line 62, in __init__
    self.init_mapping(mapping)
  File "C:\Users\HHHHH\AppData\Local\Programs\Python\Python37-32\lib\site-packages\web\application.py", line 130, in init_mapping
    self.mapping = list(utils.group(mapping, 2))
  File "C:\Users\HHHHH\AppData\Local\Programs\Python\Python37-32\lib\site-packages\web\utils.py", line 531, in group
    x = list(take(seq, size))
RuntimeError: generator raised StopIteration

 
Follow the exception prompt to find the appropriate code (… Utils.py “, line 531, in group), as follows:

Here, call line 524 take method and modify it as follows according to the information on the official website (note the indentation) :

Restart successfully after modification:

END

How to increase the effect of onchange event after adding readonly attribute to input tag and display time of laydate plug-in

Trial and error: It is not possible to bind the onChange event to the input tag directly in HTML and JS.
Reason: ReadOnly is read-only, and onChange events respond to value changes. However, the actual onChange event is only valid for the interface input value. Modified values through DOM objects are invalid.
Use onblur instead. Onblur events are triggered when an object loses focus. The measured effect can occasionally start, occasionally fail.
Solution 2: Given that the input box renders the event with layDate, in the done function on layDate, assign the input box to the selected value that needs to be executed during the execution of the onChange event.
Solution # 2 Perfect the problem.
Note: When searching the web, be careful to combine your own scene. For example, the input box has been rendered with laydate, which is equivalent to an event. Therefore, we should consider whether we can achieve our requirements in this event.
 
 

Enum type and set type of MySQL

Enumeration type and collection type of MySQL
CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE

create table consumer(
    id int,
    name char(16),
    sex enum('male','female','other'),
    level enum('vip1','vip2','vip3'),
    hobbies set('play','music','read','run')
)

Enumeration here means that you can select only one from here, and set means that you can select more than one from set.
Input insert statement

insert into consumer values(1,'egon','male','vip2','music,read')

And you might be wondering, what happens if I put multiple entries in the corresponding enum?

insert into consumer values(2,'eg','male','vip1,vip2','music,read')


ah