How long does telegram files get stored in groups Any idea?

|
piterden 2020-10-21 19:08:16
rotiman 2020-10-21 18:37:43

+ INTERVAL 10 MINUTE

2020-10-21 19:47:49
i want to learn relational calculus. what are some good books to learn it? just learnt relational calculus but stuck in relational algebra, so thought of asking it here.
MasterZiv 2020-10-21 22:44:45
2020-10-21 19:47:49
i want to learn relational calculus. what are some good books to learn it? just learnt relational calculus but stuck in relational algebra, so thought of asking it here.

I think Daite s books should be quite good, or you can find Ulman and Garsia-Molino

alexsandro_matias 2020-10-23 02:38:00
Is It possible create a index for a field of type DATETIME???
alexsandro_matias 2020-10-23 02:38:37
try find out on the doc-reference, but it was’nt show anything
2020-10-23 07:40:46
yes
2020-10-23 07:40:51
it is possible.
2020-10-23 07:41:10
datetime is just a datatype like varchar, there is a format if u read the documentation.
2020-10-23 07:41:31
MasterZiv 2020-10-21 22:44:45
I think Daite s books should be quite good, or you can find Ulman and Garsia-Molino

I see. I will look at these books. This seems like a tough topic to master.

2020-10-23 07:42:00
How long does telegram files get stored in groups Any idea? anyone? I want to store some files in cloud storage and I am planning to use telegram for it. Is it viable?
Master Yoda 2020-10-23 20:12:27
2020-10-23 07:42:00
How long does telegram files get stored in groups Any idea? anyone? I want to store some files in cloud storage and I am planning to use telegram for it. Is it viable?

As long as admins want

alexsandro_matias 2020-10-24 03:49:06
2020-10-23 07:41:10
datetime is just a datatype like varchar, there is a format if u read the documentation.

But can I limite the lenght of index ?

alexsandro_matias 2020-10-24 03:49:15
For example
alexsandro_matias 2020-10-24 03:49:48
mysql> CREATE INDEX IDX_SHIPDATE ON LINEITEM(L_SHIPDATE(4) );
ERROR 1089 (HY000): Incorrect prefix key; the used key part isn’t a string, the used length is longer than the key part, or the storage engine doesn’t support unique prefix keys
mysql>
Master Yoda 2020-10-24 07:21:09
alexsandro_matias 2020-10-24 03:49:48
mysql> CREATE INDEX IDX_SHIPDATE ON LINEITEM(L_SHIPDATE(4) );
ERROR 1089 (HY000): Incorrect prefix key; the used key part isn’t a string, the used length is longer than the key part, or the storage engine doesn’t support unique prefix keys
mysql>

I don’t think prefix index are allowed with date types

MasterZiv 2020-10-24 08:00:51
alexsandro_matias 2020-10-24 03:49:48
mysql> CREATE INDEX IDX_SHIPDATE ON LINEITEM(L_SHIPDATE(4) );
ERROR 1089 (HY000): Incorrect prefix key; the used key part isn’t a string, the used length is longer than the key part, or the storage engine doesn’t support unique prefix keys
mysql>

No, you can’t.

Prefix is only used for textual data.

jhay 2020-10-25 13:38:52
Hi! can anyone help me with mySQL? thanks
piterden 2020-10-25 15:18:51
jhay 2020-10-25 13:38:52
Hi! can anyone help me with mySQL? thanks

Just ask your question as detailed as you can

2020-10-25 17:10:42
mysql_en-6509.jpg

2020-10-25 17:10:51
can anyone explain what does that highlighted line means?
2020-10-25 17:11:13
how does this DRC is referencing relation and not attribute name?
MasterZiv 2020-10-25 17:16:04
2020-10-25 17:10:51
can anyone explain what does that highlighted line means?

Not understandable, just ignore, you will see it later.

2020-10-25 17:16:19
MasterZiv 2020-10-25 17:16:04
Not understandable, just ignore, you will see it later.

gr8

nosyeaj 2020-10-26 05:05:00
Hi! whats the ideal way for adding enum value?

I tried alter table and add the enum values (status column) in right order but another error popped up and says invalid default val for ‘featured_date’

piterden 2020-10-26 05:06:20
nosyeaj 2020-10-26 05:05:00
Hi! whats the ideal way for adding enum value?

I tried alter table and add the enum values (status column) in right order but another error popped up and says invalid default val for ‘featured_date’

Show queries you used and DDL of using tables

nosyeaj 2020-10-26 05:09:46
piterden 2020-10-26 05:06:20
Show queries you used and DDL of using tables

sql
ALTER TABLE `images`
CHANGE `status` `status`
ENUM(‘active’,’pending’,’deny’)
CHARACTER SET utf8
COLLATE utf8_general_ci
NOT NULL DEFAULT ‘pending’;

piterden 2020-10-26 06:02:30
nosyeaj 2020-10-26 05:09:46
sql
ALTER TABLE `images`
CHANGE `status` `status`
ENUM(‘active’,’pending’,’deny’)
CHARACTER SET utf8
COLLATE utf8_general_ci
NOT NULL DEFAULT ‘pending’;

https://www.google.com/search?newwindow=1&q=mysql+alter+table+change+column+type&oq=mysql+alter+table+change+column+type

mysql alter table change column type – Google SearchGoogle
MasterZiv 2020-10-26 08:03:17
nosyeaj 2020-10-26 05:05:00
Hi! whats the ideal way for adding enum value?

I tried alter table and add the enum values (status column) in right order but another error popped up and says invalid default val for ‘featured_date’

The ideal way is not to use enum values. Use a usual relational dictionary table

nosyeaj 2020-10-27 05:51:38
MasterZiv 2020-10-26 08:03:17
The ideal way is not to use enum values. Use a usual relational dictionary table

Ok got it thanks. My temporary fix was to set sql_mode in my dev

AnyAny_0 2020-10-30 17:35:15
For daily programming tips, tech insights, internship opportunities and so much more.
Check out our page https://www.instagram.com/freeloc_solutions/ and share among friends.
Makgato 2020-10-31 19:12:15
mysql_en-6549.jpg
Please guys i am beginner in this SQL programming can u explain for me how to start new database and run it
Makgato 2020-10-31 19:14:28
Please help me guys i really need help i tried to check it via YouTube i didn’t find solutions please ๐Ÿ™๐Ÿ™
smlkw 2020-10-31 19:24:52
Makgato 2020-10-31 19:12:15
Please guys i am beginner in this SQL programming can u explain for me how to start new database and run it

create database mydb1;

smlkw 2020-10-31 19:24:55
use mydb1;
smlkw 2020-10-31 19:25:03
you these two commands
Makgato 2020-10-31 19:37:45
mysql_en-6554.jpg
Please help where can i press to run and see results of my program
Master Yoda 2020-10-31 19:39:14
Makgato 2020-10-31 19:37:45
Please help where can i press to run and see results of my program

Remove id before create table and press ctrl + enter

Makgato 2020-10-31 19:39:39
Master Yoda 2020-10-31 19:39:14
Remove id before create table and press ctrl + enter

Ok lets me try

Makgato 2020-10-31 19:42:12
Master Yoda 2020-10-31 19:39:14
Remove id before create table and press ctrl + enter

mysql_en-6557.jpg
Now i see this after removing id and press ctrl + enter

Master Yoda 2020-10-31 19:43:11
Because table customer already is there
Master Yoda 2020-10-31 19:43:18
In database
Master Yoda 2020-10-31 19:43:50
I wonder you are testing me or yourself๐Ÿ˜
Makgato 2020-10-31 19:44:39
Master Yoda 2020-10-31 19:43:11
Because table customer already is there

๐Ÿ˜ญ๐Ÿ˜ญ i don’t understand

Makgato 2020-10-31 19:46:01
Master Yoda 2020-10-31 19:43:50
I wonder you are testing me or yourself๐Ÿ˜

Is the first time using it and this is my first program please help me i am not testing u

Makgato 2020-10-31 19:47:10
mysql_en-6563.jpg

Makgato 2020-10-31 19:47:45
Makgato 2020-10-31 19:47:10

I copied this please help me guys i really need help

adinath_kamode 2020-10-31 19:59:52
Table you trying to create is already present in database. So u getting error. You can use srop table if already exista before creating it.
Makgato 2020-10-31 20:23:02
adinath_kamode 2020-10-31 19:59:52
Table you trying to create is already present in database. So u getting error. You can use srop table if already exista before creating it.

Can u tell me steps to do that because i don’t know Manu of mysql ๐Ÿ™๐Ÿ™

Master Yoda 2020-10-31 22:34:51
Makgato 2020-10-31 20:23:02
Can u tell me steps to do that because i don’t know Manu of mysql ๐Ÿ™๐Ÿ™

“Drop table customer.”

2020-11-03 09:45:41
Can I have MySQL course?
|