Is it able to read properly?

|
Suresh M 2022-02-18 12:51:12
I need support
Ab_ddz 2022-02-18 13:05:52
i.              Identify the total numbers of orders placed for each
PaymentID for order placed between “5/02/2020 and
30/04/2020”
Ab_ddz 2022-02-18 13:06:06
SYNTAX FOR THIS PLEASE
2022-02-18 13:08:38
SELECT * FROM TABLE_NAME
WHERE PaymentID BETWEEN ‘5/02/2020′ AND ’30/04/2020’;
Ab_ddz 2022-02-18 13:15:09
Its blank
amuelle1 2022-02-18 13:38:11
Ab_ddz 2022-02-18 13:15:09
Its blank

I don’t think PaymentID is the right column to do a date comparison

Ab_ddz 2022-02-18 13:49:17
amuelle1 2022-02-18 13:38:11
I don’t think PaymentID is the right column to do a date comparison

Can you tell something??

amuelle1 2022-02-18 13:50:43
Ab_ddz 2022-02-18 13:49:17
Can you tell something??

Ist the “PaymentID” column really containing a date? Normally I would except that a column like payment_date contains such information, PaymentID normally I would excpect to contain a ID number/code.

Unknownrjbeast 2022-02-18 14:24:39
mysql_en-17696.jpg
Can anyone tell me how to show whole table its showing in next 🥺
Unknownrjbeast 2022-02-18 14:33:57
mysql_en-17699.jpg

Khushi Hura 2022-02-18 15:36:25
Have u used blob data type?
Khushi Hura 2022-02-18 15:38:01
I think it is showing the full table only 🤔
But your data in a column is large so it is showing this type of format
getgoon 2022-02-18 16:02:38
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=’yourdatabasename’ AND TABLE_NAME=’yourtablename’;
getgoon 2022-02-18 16:02:49
You will get the columns
Unknownrjbeast 2022-02-18 16:25:07
Khushi Hura 2022-02-18 15:38:01
I think it is showing the full table only 🤔
But your data in a column is large so it is showing this type of format

Yes, but any solution

Khushi Hura 2022-02-18 16:26:44
no
Khushi Hura 2022-02-18 16:26:53
it will display like this only
Khushi Hura 2022-02-18 16:27:01
because data isvery large
snehakshaylata 2022-02-18 16:29:00
Khushi Hura 2022-02-18 16:27:01
because data isvery large

I have query

Khushi Hura 2022-02-18 16:30:14
Wht?
Khushi Hura 2022-02-18 16:37:08
YA
Unknownrjbeast 2022-02-18 16:39:25
What is this 🥺
Unknownrjbeast 2022-02-18 17:37:01
Done thx 🥺😊
Pradepp Prajapati 2022-02-19 12:58:05
mysql_en-17739.jpg
MySQL not running issue. Anybody can you please on that
Khushi Hura 2022-02-19 13:02:28
PID file is not updated
Khushi Hura 2022-02-19 13:02:32
Check once
Khushi Hura 2022-02-19 13:02:56
Check your log file
Khushi Hura 2022-02-19 13:03:09
Is it able to read properly?
Pradepp Prajapati 2022-02-19 13:08:36
Khushi Hura 2022-02-19 13:02:56
Check your log file

I am not able to read my .log file. It’s binary formate.

Khushi Hura 2022-02-19 13:08:59
Hm
Pradepp Prajapati 2022-02-19 13:09:00
mysql_en-17746.jpg

Pradepp Prajapati 2022-02-19 13:10:57
But when I tail my .err file it showing something
‘shutdown complete’
Khushi Hura 2022-02-19 13:10:58
Restart your mysql services from settings
Khushi Hura 2022-02-19 13:11:21
MySQL Error – The Server Quit Without Updating PID File – Interserver Tips
https://www.interserver.net/tips/kb/mysql-error-server-quit-without-updating-pid-file/?amp

MySQL Error – The Server Quit Without Updating PID FileInterserver Tips
The MySQL error “Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/yourservername.pid)” is thrown when MySQL fails to start. This occurs when MySQL is upgraded to a later version or due to insufficient permission and ownership issue in MySQL data directory. The PID file in the MySQL data directory is gone and MySQL
Pradepp Prajapati 2022-02-19 13:11:27
mysql_en-17752.jpg

|