how load a table with empty fields

[Xolink1389]

Hi community,

i wanna know how can i make to load only the field with zero date in it, im using this expression to load but it still load content, i just want to load the name of the fied with no data

you might wonder why im try to load empty field, well i just wanna see how many field contain the table, or if i can put a default value of 1 to each field in order to the table load faster

[Anil_Babu_Samineni]

@Xolink1389 Perhaps like below

1) Select * ... Where 1=2;

I have tried this, and it seems to be OK.

Load * Inline [
Name
a
b
c
] Where 1=2;

[Vegar]

You could try 

FMIT:

LOAD *;

SQL SELECT *

FROM FMIT

LIMIT 0;

This query will be selecting all the columns (*) from the FMIT table, and using the LIMIT 0 means it will not return any rows (only the column names)

[Xolink1389]

i get this error 

[Xolink1389]

i get this error

[Anil_Babu_Samineni]

It should be with Load statement not select statement. 

[Xolink1389]

Still not working ☹️

[BrunPierre]

Here are the respective syntaxes for a standard SQL SELECT statement and a Preceding Load:

FMIT:
SQL SELECT *
FROM FMIT
WHERE 1=2;

or

FMIT:
LOAD *
WHERE 1=2;
SQL SELECT *
FROM FMIT;

[Xolink1389 · Accepted solution]

only this works :D, but finally works, thank a lot

FMIT:
LOAD *
WHERE 1=2;
SQL SELECT *
FROM FMIT;

[Vegar]

I see that you already have found a solution to your issue, that's great.

The suggestion I sent you was in mysql syntax and your database is probably not mysql.

In MSSQL you can try this

SELECT TOP 0 *
FROM FMIT;

In Oracle you can try this

SELECT *
FROM FMIT
FETCH FIRST 0 ROWS ONLY;