Anyone know about limitation in mysql?

|
MasterZiv 2022-02-15 18:13:12
Liran 2022-02-15 18:08:44
if it is * what it means then? because the mySQL im trying to connect is with * not % for bind-address

it is user account only. But you need first to connect to the MySQL Server by network.

MasterZiv 2022-02-15 18:33:54
Liran 2022-02-15 18:08:44
if it is * what it means then? because the mySQL im trying to connect is with * not % for bind-address

read this, and check

https://t.me/mysql_en/17548

Vijay A in MySQL (EN)Telegram
Then try to ask MySQL related questions if connectivity is good
Mr R 2022-02-16 06:30:06
Hello, good morning, could any one has the documentation of Transactions concept, if yes , could you share please?
M S 2022-02-16 08:33:55
Good Morning all taking backups using xtrabackup the time taken for fullbackup is equal r sometimes more for taking incremental backup when i checked size of the db files ,which are less compared to fullbackup files can anyone tell why its taking that much time for incremental backup
Lovish8890 2022-02-16 10:09:13
Can anyone tell me what will be best resource to learn database
Lovish8890 2022-02-16 10:09:21
MySQL
SMTABL 2022-02-16 18:01:32
Hi folks i need help, as a data analyst which tool is to be used for ETL
H4XXOR 2022-02-16 19:24:50
mysql_en-17579.jpg

H4XXOR 2022-02-16 19:25:05
H4XXOR 2022-02-16 19:24:50

product table

H4XXOR 2022-02-16 19:25:29
mysql_en-17581.jpg

H4XXOR 2022-02-16 19:25:45
H4XXOR 2022-02-16 19:25:29

Out should be, please help

H4XXOR 2022-02-16 21:16:11
H4XXOR 2022-02-16 19:25:29

In mysql

piterden 2022-02-17 02:22:34
Это англоязычный чат. Ты бы хотя бы в русском оффтопил
neerajaj29 2022-02-17 04:26:08
SMTABL 2022-02-16 18:01:32
Hi folks i need help, as a data analyst which tool is to be used for ETL

There are many for etl talend and informatica are widely used

SMTABL 2022-02-17 09:38:19
mysql_en-17592.jpg

SMTABL 2022-02-17 09:38:26
How to get it? Any suggestions
piterden 2022-02-17 09:47:19
Use SQL
SMTABL 2022-02-17 10:03:11
How to write query to get ans
SMTABL 2022-02-17 10:03:17
I got wrong ans
SMTABL 2022-02-17 10:03:51
Select brand.. sum(unit_sold)
SMTABL 2022-02-17 10:04:13
Where unit sold> 500
SMTABL 2022-02-17 10:04:33
Between 20190101 and 20193112
MasterZiv 2022-02-17 10:16:34
SMTABL 2022-02-17 10:04:33
Between 20190101 and 20193112

This is incorrect syntax

SMTABL 2022-02-17 10:20:27
How to solve?
snehakshaylata 2022-02-17 11:47:50
Anyone there for help
snehakshaylata 2022-02-17 11:48:49
Hell??
snehakshaylata 2022-02-17 11:49:05
Anyone know about limitation in mysql??
sadans dan 2022-02-17 16:57:37
hey who is good with mysql ineed help
smlkw 2022-02-17 17:29:00
Guys and girls, please post your questions without offtopic messages
smlkw 2022-02-17 17:29:31
SMTABL 2022-02-17 10:20:27
How to solve?

Read about forming SQL queries more

getgoon 2022-02-17 18:36:54
SMTABL 2022-02-17 09:38:19

The date is in format of char so convet to date type by using CAST([Date] AS DATE)

SMTABL 2022-02-17 18:44:19
Thanku bro
SMTABL 2022-02-17 18:45:19
getgoon 2022-02-17 18:36:54
The date is in format of char so convet to date type by using CAST([Date] AS DATE)

Is str_to_date also gives the same result??

getgoon 2022-02-17 18:51:04
SELECT * FROM tablename WHERE unitsold>500 AND CONVERT(date , Date) BETWEEN ‘2019/1/1’ and ‘1
2019/12/31’
getgoon 2022-02-17 18:51:09
try this once
|