Most voted questions in Database

+2 votes
1 answer

How to export data from MySql to a CSV file?

If you are using MySql workbench then ...READ MORE

Jan 4, 2019 in Database by Priyaj
 • 58,020 points • 1,835 views
+2 votes
3 answers

Difference between SQL and PL/SQL

In Oracle database administration, there are two ...READ MORE

Sep 25, 2019 in Database by gautham
 • 1,840 views
+1 vote
0 answers

SQL: Two select statements in one query

I want to return the newly created ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 38,000 points • 6,359 views
+1 vote
1 answer

how to change format of date from mm/dd/yyyy to dd-mmm-yyyy in MS Excel

i am using in angular its work ...READ MORE

Apr 13, 2023 in Database by manisha
edited Mar 5 • 160,252 views
+1 vote
1 answer

Convert excel column to comma separated list

The CONCATENATE function in Excel can transform ...READ MORE

Apr 6, 2022 in Database by gaurav
 • 23,260 points • 193,456 views
+1 vote
1 answer

How to Insert date value in SQL table

Always use ANSI default string literal format for date i.e. YYYY-MM-DD like below. INSERT ...READ MORE

Feb 17, 2022 in Database by Neha
 • 9,020 points • 184,266 views
+1 vote
1 answer

How to migrate a PostgreSQL database into a SQLServer one?

Hello @kartik, The easier way to accomplish this. First ...READ MORE

May 13, 2020 in Database by Niroj
 • 82,840 points • 1,390 views
+1 vote
0 answers

What are the advantages of SQL? [closed]

Dec 28, 2019 in Database by Yuth
 • 130 points
closed Dec 30, 2019 by Kalgi • 1,260 views
+1 vote
1 answer

Do I need to mention primary key for each table?

Hi Pritha, First, there is no hard and ...READ MORE

Jul 4, 2019 in Database by sampriti
 • 1,120 points • 1,296 views
+1 vote
1 answer

How can I reset my auto_increment column in MYSQL?

Hi Pratim, I understand your issue. I think you ...READ MORE

Jul 2, 2019 in Database by sampriti
 • 1,120 points • 1,313 views
+1 vote
1 answer

What are the features of MySQL?

The features of MySQL are as follows: Ease ...READ MORE

Dec 12, 2018 in Database by DataKing99
 • 8,250 points • 6,469 views
+1 vote
1 answer

What are the data types in MySQL?

The Data Types of MySQL are as ...READ MORE

Dec 12, 2018 in Database by DataKing99
 • 8,250 points • 3,581 views
+1 vote
1 answer

What is the AND operator?

The AND operator is used to filter ...READ MORE

Dec 1, 2018 in Database by Sahiti
 • 6,370 points • 1,754 views
+1 vote
2 answers

List few commands of DDL, DML, and DCL.

The list of commands is as follows:  Data ...READ MORE

Nov 12, 2018 in Database by Sahiti
 • 6,370 points • 120,933 views
+1 vote
1 answer

Difference between cross join and natural join

The cross join produces the cross product ...READ MORE

Oct 12, 2018 in Database by DataKing99
 • 8,250 points • 16,850 views
+1 vote
1 answer

DELETE vs TRUNCATE vs DROP command

After the execution of ‘DELETE’ operation, COMMIT ...READ MORE

Aug 23, 2018 in Database by CodingByHeart77
 • 3,750 points • 2,217 views
+1 vote
1 answer

Cursor and Its Types

The cursor is a temporary work area ...READ MORE

Aug 9, 2018 in Database by CodingByHeart77
 • 3,750 points • 1,303 views
0 votes
1 answer

Why is the object value not updating in MongoDB?

There could be several reasons why an ...READ MORE

Dec 31, 2024 in Database by Navya
 • 227 views
0 votes
0 answers

DFS PUT Command gives error on Windows

When i run DFS PUT command on ...READ MORE

Jul 22, 2024 in Database by anonymous
edited Mar 4 • 98 views
0 votes
0 answers

what kind of a nosql store is azure table storage

what kind of a nosql store is ...READ MORE

Dec 15, 2023 in Database by Priyanka
 • 4,500 points • 839 views
0 votes
0 answers

Cannot connect to SQL server

cannot connect to SQL worked well before ...READ MORE

Nov 10, 2023 in Database by rakshatha
edited Mar 5 • 184 views
0 votes
0 answers

Create a SQL enter script from an Excel worksheet

I have a large excel worksheet that ...READ MORE

Sep 8, 2023 in Database by Satyawrat
 • 460 points • 782 views
0 votes
0 answers

MongoDB convert type of an element in array

In MongoDB, I have a object array ...READ MORE

Aug 7, 2023 in Database by Ramkumar
edited Mar 5 • 164 views
0 votes
0 answers

How to add crud operation in Laravel via ajax?

I have created a project in Laravel ...READ MORE

Jul 13, 2023 in Database by Muhammad
edited Mar 5 • 75 views
0 votes
0 answers

How to create Login and Register in Laravel verify by OTP?

I want to create a project in ...READ MORE

Jul 13, 2023 in Database by Muhammad
edited Mar 5 • 163 views
0 votes
0 answers

How to Extract Tally ODBC to Sales Register table Excel, items wise In SQL Statement

How to Extract Tally ODBC to Sales ...READ MORE

Jun 17, 2023 in Database by Arun
edited Mar 5 • 74 views
0 votes
0 answers

How do I delete rows from two tables with ID in MySQLi using php?

I want to delete rows in two ...READ MORE

May 25, 2023 in Database by Hannes
edited Mar 5 • 92 views
0 votes
0 answers

Select employee details of dept number 10 or 30

Dept Table:                     DeptNo Dname Loc 10 Accounts Bangalore 20 IT Delhi 30 Production Chennai 40 Sales Hyd 50 Admn London Emp ...READ MORE

Feb 12, 2023 in Database by Nischitha
edited Mar 4 • 99 views
0 votes
0 answers

why this error ? ERROR Cannot add or update a child row a foreign key constraint fails

create table per( sl_no int UNIQUE NOT ...READ MORE

Dec 13, 2022 in Database by abc
edited Mar 4 • 84 views
0 votes
0 answers

I am having a forbidden error response when I try to login to Docker Desktop on a Windows OS

I am new to docker and I ...READ MORE

Nov 30, 2022 in Database by Gustave
edited Mar 4 • 46 views
0 votes
0 answers

Get json object values and store as arrays

[ ['david','female','john','e6a33eee180b07e563d74fee8c2c66b8',1,1,'roger63'], ...READ MORE

Nov 16, 2022 in Database by Ashwini
 • 5,430 points • 1,800 views
0 votes
0 answers

Can PHP arrays hold items of different type?

The definition of an array in other ...READ MORE

Nov 16, 2022 in Database by Ashwini
 • 5,430 points • 1,007 views
0 votes
0 answers

nsert into a table, data returned from reserved command

Hi, I want to insert in a table, ...READ MORE

Oct 18, 2022 in Database by Edvaldo
edited Mar 4 • 61 views
0 votes
0 answers

Apache Hive - command Describle formatted table

About the describe formatted table command, is ...READ MORE

Oct 15, 2022 in Database by Edvaldo
edited Mar 4 • 60 views
0 votes
0 answers

Apache Hive - command Describle formatted table

About the describe formatted table command, is ...READ MORE

Oct 15, 2022 in Database by Edvaldo
edited Mar 4 • 61 views
0 votes
1 answer

ERROR 1064 (42000): You have an error in your SQL syntax;

It is varchar and not var_char CREATE DATABASE IF NOT EXISTS ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 9,568 views
0 votes
1 answer

Delete all the records

You can use this if you have ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 1,002 views
0 votes
1 answer

How can I create a unique constraint on my column (SQL Server 2008 R2)?

The "indexes and keys" dialogue, not the ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 1,184 views
0 votes
1 answer

Using ORDER BY and GROUP BY together

Correctly use the  group by: select l.* from table ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 866 views
0 votes
1 answer

IN Clause with NULL or IS NULL

An in statement will be parsed identically to field=val1 or ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 877 views
0 votes
1 answer

What is the difference between a primary key and a surrogate key?

The unique key in your database that ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 8,409 views
0 votes
1 answer

How do I obtain a Query Execution Plan in SQL Server?

There are several ways to get an ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 1,738 views
0 votes
1 answer

How to retrieve the current version of a MySQL database management system (DBMS)?

Many responses advise using mysql —version. But ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 898 views
0 votes
1 answer

How do I do multiple CASE WHEN conditions using SQL Server 2008?

There are three formats of the case expression. ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 2,489 views
0 votes
1 answer

java.sql.SQLException: Column count doesn't match value count at row 1

I think PreparedStatement would be a better choice. I ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 2,633 views
0 votes
1 answer

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

Your table dbo.Sup Item Cat refers to ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 63,600 points • 9,432 views
0 votes
1 answer

Escape Character in SQL Server

You can escape quotation like this: select 'it''s ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 63,600 points • 1,290 views
0 votes
1 answer

Function to Calculate Median in SQL Server

Use a simple-ish median calculation for a ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 63,600 points • 1,777 views
0 votes
1 answer

Highest Salary in each department

SELECT DeptID, MAX(Salary) FROM EmpDetails GROUP BY ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 63,600 points • 2,413 views
0 votes
1 answer

SQL Server: IF EXISTS ; ELSE

Try this: update b set code = ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 63,600 points • 4,310 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.