Question SQL

[WASSIm.]

hi guys, i working for Sqlite browser panel but i don't know get all data from sql with tables please if anyone know it tell me

[_DrXenon]

i am also new for SQL thingy...

but i used:

executeSQLQuery("SELECT * FROM sqldataName ( column, column) ")

or something like that, anyway you may also check wiki.multitheftauto.com

[Citizen]

i am also new for SQL thingy...

but i used:

executeSQLQuery("SELECT * FROM sqldataName ( column, column) ")

or something like that, anyway you may also check wiki.multitheftauto.com

The syntax is wrong, you probably meant:

SELECT * FROM tableName 

And it will return all rows and columns from a table with the name "tableName"

But before that you probably 1st want to list all tables from the database you are connected on:

SHOW TABLES 

And if you need to list databases:

SHOW DATABASES 

[#DRAGON!FIRE]

function returnAllData (   ) 
  local data = executeSQLQuery( "SELECT * FROM SQL" ) 
   if ( #data > 0 ) then 
      local table = {   } 
      for _,alldata in ipairs( data ) do 
           table.insert( table, alldata ) 
       end 
   end 
  return table 
end    

[WASSIm.]

i use sqlite with dbConnect and SHOW TABLES not working

addEventHandler("onResourceStart", resourceRoot, 
function ( ) 
    connection = dbConnect("sqlite", "database.db") 
    if (connection) then 
        outputDebugString("Successfully connected to database.db") 
    else 
        outputDebugString("Failed to connect to database.db", 3) 
    end 
end) 
  
addEvent("onPlayerLoadDatabase", true) 
addEventHandler("onPlayerLoadDatabase", root, 
function( ) 
    local query = dbQuery(connection, "SELECT * SHOW TABLES") 
    local data =  dbPoll(query, -1) 
    triggerClientEvent(source, "onClientPlayerLoadDatabase", source, data) 
end) 

[Mr_Moose]

You have

SELECT * SHOW TABLES 

in your code, it should only be

SHOW TABLES 

if you want to list all tables in your database.

[WASSIm.]

debug show me this: dbPoll failed near "SHOW": syntax error

[Saml1er]

"SELECT * SHOW TABLES" 

As you can see here you have spaces SHOW TABLES. Not sure but I don't think so you can use spaces and it should be

"SELECT * FROM MyTableName" 

[Arnold-1]

i don't have a huge knowledge about SQL, but i think "SELECT * FROM *" would work to get ALL the data.

[Mr_Moose]

It depends on what type of database you have, some say SQL even when they mean SQLite for instance, here's the syntax for all major databases:

MySQL 
SHOW [FULL] TABLES [FROM db_name] [LIKE 'pattern'] 
  
Oracle 
SELECT * FROM dba_tables 
  
MSSQL 
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' 

SQLite is like MySQL basically.