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

+ INTERVAL 10 MINUTE

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

Is It possible create a index for a field of type DATETIME???

try find out on the doc-reference, but it was’nt show anything

yes

it is possible.

datetime is just a datatype like varchar, there is a format if u read the documentation.

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

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

But can I limite the lenght of index ?

For example

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

No, you can’t.

Prefix is only used for textual data.

Hi! can anyone help me with mySQL? thanks

Just ask your question as detailed as you can

can anyone explain what does that highlighted line means?

how does this DRC is referencing relation and not attribute name?

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

gr8

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

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

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

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.

Please guys i am beginner in this SQL programming can u explain for me how to start new database and run it

Please help me guys i really need help i tried to check it via YouTube i didn’t find solutions please 🙏🙏

create database mydb1;

use mydb1;

you these two commands

Please help where can i press to run and see results of my program

Remove id before create table and press ctrl + enter

Ok lets me try

Now i see this after removing id and press ctrl + enter

Because table customer already is there

In database

I wonder you are testing me or yourself😁

😭😭 i don’t understand

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

I copied this please help me guys i really need help

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 🙏🙏

“Drop table customer.”

Can I have MySQL course?