Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to insert an empty line to SQL table? [duplicate]

Tags:

sql

sql-server

tsql

Possible Duplicate:
Inserting rows into a table with one IDENTITY column only

I have a SQL table with just one column. Column is an autoincrement field like:

Id INT IDENTITY

I need to insert a rows to this table (this is a bulk/dummy table temporarily):

INSERT INTO my_table VALUES ()

But I'm got a syntax error.

How can I do this?

like image 594
Oomph Sonar Avatar asked Nov 28 '12 12:11

Oomph Sonar

People also ask

How do I add a new line in a table in SQL?

-- Using both \r\n SELECT 'First line. \r\nSecond Line. ' AS 'New Line'; -- Using both \n SELECT 'First line.

1 Answers

INSERT INTO my_table DEFAULT VALUES
like image 100
gbn Avatar answered Sep 18 '22 09:09

gbn
Sign in to Comment

Related questions

How to ORDER BY a SUM() in MySQL?
SQL - select distinct only on one column [duplicate]
Duplicating a TABLE using Microsoft SQL Server Management
How to create table using select query in SQL Server?
SQL Server SELECT to JSON function
SQLite Foreign Key
Doctrine query builder using inner join with conditions
How to get stored procedure parameters details?
Quickest way to fill SQL Table with Dummy Data
Truncate with condition
Execute sp_executeSql for select...into #table but Can't Select out Temp Table Data
MySQL: Insert datetime into other datetime field
Can I set ignore_dup_key on for a primary key?
Using Raw SQL with Doctrine
Custom order by in SQL server like P, A, L, H [closed]
Inserting null to an Integer column using JDBC
select from mysql table between datetime x min ago and datetime x min ago
SQL Table Aliases - Good or Bad? [closed]
GROUP BY and COUNT in PostgreSQL
How to do a count on a union query

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!