The id field in the database table should be stored as 1.1.1.1. The foreground shows that the order should be arranged in ascending order, and the null judgment should be repeated. Please see if my existing ideas are correct. - Codes Helper - Programming Question Answer

The id field in the database table should be stored as 1.1.1.1. The foreground shows that the order should be arranged in ascending order, and the null judgment should be repeated. Please see if my existing ideas are correct.

the receptionist wants to display as

set five fields of id1,id2,id3,id4,id,

id is the primary key and type is varchar.

id1,2,3,4 type is int.

foreground ascending order: select id1,id2,id3,id4,id from t_task group by 1, 2, 3, 4

if you want to add a new piece of data, when the foreground enters "1.1.1.1", it is transmitted to the background in the form of a string. Convert the characters of the string 1, 3, 5, 5 and 7 into the int type. If not, set it to empty. The "1.1.1.1" stored in the id1,id2,id3,id4, entry is directly stored in the id field in the format of the string, and then the null judgment is repeated by the way. If the input format of the foreground is incorrect, you should also remind you to report an error, and the background processing and judgment should be written in java

.

if there is only one "1", save it as 1? The display is also 1, and the id1 must be greater than 0. if the last three digits are empty, they will be set to empty.

I wonder if my preliminary idea is correct? Also ask the god for advice, thank you!

Java sql mysql

Oct.14,2021

Why is the

1 sort followed by group by ? what the heck is this? Since
2 is a numerical sort, if not, it should be set to 0

Previous: Vant introduces Dialog component to report error

Next: What about the garbled data obtained by node's http.request?

I want to use sql to query out the posts I have posted and the posts posted by the users I follow. How should I write this sql?
select t.* from talk t where t.user_id = 2 Union select t.* from talk t, user_contact c where c.user_id = 2 and c.contact_type = 1 and c.be_user_id = t.user_id you can write it this way, but you don t want to write it this way. You want to use an inner...

Java sql mysql spring

Jun.25,2021
MYSQL closes the remote connection and the program cannot be accessed. What is the reason?
if you want to close remote 3306 access due to security problems, add skip-networking shared_memory=ON to the my.ini file. at this time, you can access mysql with navicat, but not with the program. Baidu has no root cause for a long time. I don t...

Navicat java sql mysql

Oct.09,2021
Query 100000 items of data with SQL or JSON+LINQ?
I have a dataset with a size of about 100000. The dataset is rarely added or updated, mainly because of frequent query operations, efficient query, and regardless of memory footprint and preload time. Which solution is better to use SQL or JSON+LINQ? ...

Python java sql mysql c-sharp

Mar.21,2022
Query 100000 items of data with SQL or JSON+LINQ?
I have a dataset with a size of about 100000. The dataset is rarely added or updated, mainly because of frequent query operations, efficient query, and regardless of memory footprint and preload time. Which solution is better to use SQL or JSON+LINQ? ...

Python java sql mysql c-sharp

Mar.21,2022
Query 100000 items of data with SQL or JSON+LINQ?
I have a dataset with a size of about 100000. The dataset is rarely added or updated, mainly because of frequent query operations, efficient query, and regardless of memory footprint and preload time. Which solution is better to use SQL or JSON+LINQ? ...

Python java sql mysql c-sharp

Mar.21,2022

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-1e3f164-26d44.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-1e3f164-26d44.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?