Search
 
SCRIPT & CODE EXAMPLE
 

SQL

ERROR 1046 (3D000): No database selected

# At first you have to create Database 
CREATE DATABASE student_sql;

# Next, specify the database to use
USE student_sql;

# Demo: create a table 
CREATE TABLE student_table(
    student_id INT PRIMARY KEY,
    name VARCHAR(20),
    major VARCHAR(20)
);

# Describe the table 
describe student_table;
Comment

PREVIOUS NEXT
Code Example
Sql :: 3rd highest value in sql 
Sql :: Create table Statement Syntax in SQL Server 
Sql :: sql now 
Sql :: sql paging query 
Sql :: version and edition of SQL Server Database Engine 
Sql :: sql row number in result set 
Sql :: sql end of month 
Sql :: pyspark sql row get value 
Sql :: round in sql server 
Sql :: how to set up a trigger in sql 
Sql :: with postgres 
Sql :: postgresql delete multiple rows 
Sql :: enable foreign key checks postgres 
Sql :: r rmysql connect local database Plugin caching_sha2_password could not be loaded 
Sql :: mysqlclient error 
Sql :: convert polygon to text in mysql 
Sql :: mysql delete data in table 
Sql :: count number of entires by months sql 
Sql :: sql query rename table 
Sql :: mysql function variable 
Sql :: SQL Add Column in a Table 
Sql :: Add image in MySQL database 
Sql :: df to sql pandas sql achemy 
Sql :: change column name mysql 
Sql :: NVL() Functions 
Sql :: sqlite show table structure 
Sql :: show details of table postgres 
Sql :: mysql community server 
Sql :: mysql find duplicate rows multiple columns 
Sql :: oracle group 
ADD CONTENT
Topic
Content
Source link
Name
7+9 =