Resources
Answers
Examples
Sign in
Get Started
What do you want to save?
Add Code snippet
New code examples in category SQL
Awgiedawgie
2022-03-27 14:45:18
delete database mssql ddl command
DROP DATABASE Sales;
Add solution
Awgiedawgie
2022-03-27 14:20:11
pl sql drop trigger
DROP TRIGGER trigger_name;
Add solution
Awgiedawgie
2022-03-27 13:55:07
import DB through mysql console
# if your database is not locally hosted mysql -u username -p -h dbhost dbname < filename.sql
Add solution
Awgiedawgie
2022-03-27 13:30:01
alter schema sql
ALTER SCHEMA toSchemaName TRANSFER fromSchemaName.TableName
Add solution
Awgiedawgie
2022-03-27 13:25:04
Sql to search who modified
SELECT DISTINCT StartTime ,hostname ,LoginName ,ObjectName ,CASE WHEN EventClass = 46 THEN 'Created' WHEN EventClass = 47 THEN 'Dropped' ...
Add solution
A-312
2022-03-27 13:10:17
Selecting Data in SQL - Select Data
//code for selecting name from user table SELECT name From users; // When requesting data with sql statements like SELECT , we say that we're making a query
Add solution
Phoenix Logan
2022-03-27 12:15:23
create user mysql debian 10
mysql -u root -p --enter password-- CREATE USER 'user'@'localhost' IDENTIFIED BY 'password'; CREATE DATABASE `myDB`; GRANT ALL PRIVILEGES ON myDB . * TO 'user'@'localhost'; FLUSH PRIVILEGES;
Add solution
Awgiedawgie
2022-03-27 12:05:20
mysql select all table that have field names
SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN('column1', 'column2') AND TABLE_SCHEMA = 'schema_name';
Add solution
Awgiedawgie
2022-03-27 11:55:09
sql commands in android
mydatabase.execSQL("CREATE TABLE IF NOT EXISTS TutorialsPoint(Username VARCHAR,Password VARCHAR);"); mydatabase.execSQL("INSERT INTO TutorialsPoint VALUES('admin','admin');");
Add solution
Awgiedawgie
2022-03-27 11:15:23
how to change the column name in sql
EXEC SP_RENAME 'TABLE_NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME'
Add solution
‹
1
2
3
4
5
6
7
8
9
10
...
403
404
›
Best helpers
daily
weekly
monthly
for 3 months
Ranking is empty
This website uses cookies to make IQCode work for you. By using this site, you agree to our
cookie policy
Welcome Back!
Sign up to unlock all of IQCode features:
Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings
Sign in
E-mail
Password
Recover lost password
Log in
Or log in with
Not registered?
Sign up takes less than a minute
Create a Free Account
Sign up to unlock all of IQCode features:
Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings
Sign up
Email
Password
Sign up for free
Or sign up with
By signing up, you agree to the
Terms and Conditions
and
Privacy Policy
. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.