Hi Guys, can I used index in whole table, is it good behavior?

|
Ab_ddz 2022-02-23 17:04:20
jollikid 2022-02-23 16:25:13
hello all.
I am a beginner in MySQL.
I got an error.
I don’t know how to fix it.
My version of MySQL is 8.0.
my error code is 1064.
here I try to create a table using the following syntax.
create table persons(
student_name varchar, student_age int,
);
my database name is student
I am in student database while I am writing the code.
using the following syntax.
use student;
please help me to fix this.
thanks in advance.

Studen_name varchar (50) or anything

jollikid 2022-02-23 17:11:46
Ab_ddz 2022-02-23 17:04:20
Studen_name varchar (50) or anything

Should we mention that sir.

Ab_ddz 2022-02-23 17:12:06
Yess obviously
jollikid 2022-02-23 17:13:57
Ab_ddz 2022-02-23 17:12:06
Yess obviously

Oh ok sir.
Thanks a lot.

jollikid 2022-02-23 17:45:45
I am getting the same error if I add that also.
Any other ifea?
Ab_ddz 2022-02-23 17:50:33
Send a picture
jollikid 2022-02-23 18:16:39
mysql_en-17930.jpg

jollikid 2022-02-23 18:18:59
What is the Syntax to clear the screen
Makgato 2022-02-23 18:27:53
Hello guys is it possible to configure Xampp mySQL access with another devices
Ab_ddz 2022-02-23 19:26:24
jollikid 2022-02-23 18:16:39

Use workbench

nikhil02220 2022-02-23 19:39:07
jollikid 2022-02-23 17:45:45
I am getting the same error if I add that also.
Any other ifea?

Remove comma after int

Omnipotent 2022-02-23 20:43:06
Hello guys, when I want to install MySQL it shows that the Installer is Valid. I tried many times by reinstall but every time I get same error. What to do???
YogeD 2022-02-23 22:23:04
I’m getting SSH tunnel timeout issue.
We are using tcp/ip over ssh method for mysql connection
YogeD 2022-02-23 22:23:10
Can someone help
svart 2022-02-23 22:26:28
YogeD 2022-02-23 22:23:04
I’m getting SSH tunnel timeout issue.
We are using tcp/ip over ssh method for mysql connection

It is not mysql issue

Chandan Chowdary 2022-02-24 08:24:21
Hello, guys, anyone has a MySQL InnoDB cluster setup document please share it with me.
Var 2022-02-24 08:28:10
Hi Guys, can I used index in whole table, is it good behavior? And please tell what is the using rules of index’s?
Raju Banik 2022-02-24 11:39:12
Omnipotent 2022-02-23 20:43:06
Hello guys, when I want to install MySQL it shows that the Installer is Valid. I tried many times by reinstall but every time I get same error. What to do???

Also I’m facing this problem

Raju Banik 2022-02-24 11:39:18
Can anyone help??
Var 2022-02-24 14:19:22
Var 2022-02-24 08:28:10
Hi Guys, can I used index in whole table, is it good behavior? And please tell what is the using rules of index’s?

Any Answers please?

rodrigo_tc7 2022-02-24 23:22:14
Var 2022-02-24 08:28:10
Hi Guys, can I used index in whole table, is it good behavior? And please tell what is the using rules of index’s?

Use index if you put that field in the where statement and affects less than a 50% of results

Manojnaik 2022-02-25 07:32:51
Please find the details about the database for “Employee Information System” (EIS) application.
Write the SQL commands to create a user (use following information) and a database in MySQL
database. (5 marks)
o Database name: Demo
o User name: admin
o password: msis
o Privilege: all
 Write java code (console ba
Manojnaik 2022-02-25 07:37:10
Anyone ans plz
j m 2022-02-25 07:42:40
python full stack developer

please send some project name with description with client name 🙏 Please Reply

Amit Kumar 2022-02-25 10:42:48
mysql_en-17995.jpg

Amit Kumar 2022-02-25 10:43:11
Hi all can we purge spt_syslog_event ?
Amit Kumar 2022-02-25 10:43:23
Any precheck for this ?
Ab_ddz 2022-02-25 12:34:11
Can anyone tell mandatory skills for sql developer!
svart 2022-02-25 13:37:49
Ab_ddz 2022-02-25 12:34:11
Can anyone tell mandatory skills for sql developer!

sql knowledge is mandatory for sure

Ab_ddz 2022-02-25 13:38:25
Yea obviously any other??
svart 2022-02-25 13:46:48
Ab_ddz 2022-02-25 13:38:25
Yea obviously any other??

in order to read documentation you must understand english at least to a certain degree

Ab_ddz 2022-02-25 13:47:18
svart 2022-02-25 13:46:48
in order to read documentation you must understand english at least to a certain degree

Thanks alot👍

svart 2022-02-25 13:48:47
you are very welcome. but i forgot to mention one skill which you lack for sure: to be able to find required information in google
Ab_ddz 2022-02-25 14:04:10
svart 2022-02-25 13:48:47
you are very welcome. but i forgot to mention one skill which you lack for sure: to be able to find required information in google

So mention

Ab_ddz 2022-02-25 14:04:14
Here na
|