How do I do mapping with user profile?

Thanks ilia ill read the article shared by you.

The using cancat possible

You’d better asked your question …

CREATE TABLE user( userid INT(24) AUTO_INCREMENT, username VARCHAR(255)AS(CANCAT(“user”,”,”userid”)), useramount INT(25), PRIMARY KEY(userid) ); while x >10000 INSTER INTO user(concat(user,userid),10000)

Did you use
SET ULTRASONIC_FAST_INSERT ON;
before inserting ?

No

then try it !

In my.cnf

NO, this is SESSION switch.

Do you seriously think such a switch exist ?

Ok…we are using jar to upload the data and through loop they are running the insertion

What is “Anne check” ?

Sorry typing mistake

Go!

Is there any way I can simulate a count(distinct (…)) Without using the keyword distinct?

No

Why do you ask?

Because I have a “database exam” and I was resolving some old exams, and I used count(distinct ()) but my professor has never explained it

Count ( field ) counts non null values in this field

Count ( distinct field ) counts distinct (unique) non null values in this field

And there in no operation in SQL which would take a set and produce a set of unique values.
So distinct is unreplaceable.

By the way, count (distinct field) is a very strange operation and it is very rarely used

Select b.guest_number from hotel h inner join booking b on h.hotel_number =b.hotel_number where h.hotel_number = 107

U can add more filters example date , city & hotel name

The error says it exactly..
Check the table’s name.. maybe there’s a typo somewhere.

This needs more details, what you do, what is the query, what are the tables,what you get as diagnostics, and so on