how to create a table using query

dummy is a data base name and student info is the table name
how to crate a table
CREATE TABLE `dummy`.`studentinfo` ( `name` INT(30) NOT NULL AUTO_INCREMENT , `username` VARCHAR(30) NOT NULL , `password` VARCHAR(30) NOT NULL , `firstname` VARCHAR(30) NOT NULL , PRIMARY KEY (`name`)) ENGINE = InnoDB;
CREATE TABLE `dummy`.`studentinfo`
( `name` INT(30) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR(30) NOT NULL ,
`password` VARCHAR(30) NOT NULL ,	not null means have to enter the data,
`firstname` VARCHAR(30) NOT NULL ,	name means name , that length, and type of the data
PRIMARY KEY (`name`)) ENGINE = InnoDB;

create table database.tablename

how to create table using query

autoincriment
CREATE TABLE Persons (
Personid int NOT NULL AUTO_INCREMENT,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
PRIMARY KEY (Personid)
);