Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to get the number of columns in a table in sql

SELECT count(*)
FROM information_schema.columns
WHERE table_name = 'tbl_ifo'
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle sql pad left zeros 
Sql :: sqlite show table indexes 
Sql :: how to make a select in sql 
Sql :: sql percentage with % rounded down 
Sql :: how to calculate number of days between two dates excluding weekends in oracle 
Sql :: search mysql database for column 
Sql :: mysql date range 
Sql :: postgre sql create table 
Sql :: SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key" 
Sql :: mysql failed to login as root@localhost 
Sql :: oracle revoke 
Sql :: left join in codeigniter query builder 
Sql :: function in plsql 
Sql :: ValueError: A string literal cannot contain NUL (0x00) characters. 
Sql :: copy value from one column to another postgres 
Sql :: CONVERT time string into 12 hours in sql 
Sql :: sort by sql 
Sql :: how to count null values in sql 
Sql :: SQL ORDER BY DESC (Descending Order) 
Sql :: SQL Server Configuration Manager location 
Sql :: mysql user 
Sql :: sql get inserted primary key 
Sql :: add multiple row table pl sql 
Sql :: insert array postgresql 
Sql :: mysql multiple order by 
Sql :: regenerate assets odoo 
Sql :: commit in sql 
Sql :: mysql drop key 
Sql :: mysql create table from select statement 
Sql :: list table columns sql 
ADD CONTENT
Topic
Content
Source link
Name
7+6 =