Search
 
SCRIPT & CODE EXAMPLE
 

SQL

ring MySQL execute a query on the database then print the result.

con = mysql_init()
see "Connect to database" + nl
mysql_connect(con, "localhost", "root", "root","mahdb")
see "Execute Query" + nl
mysql_query(con, "SELECT Name FROM Employee WHERE Id=1;"+
                 "SELECT Name FROM Employee WHERE Id=3")
see "Print Result" + nl
see mysql_result(con)
mysql_next_result(con)
see mysql_result(con)
see "close database" + nl
mysql_close(con)
Comment

PREVIOUS NEXT
Code Example
Sql :: store case result sql 
Sql :: can you create views in dbbrowser 
Sql :: difference between nvl and nvl2 in oracle 
Sql :: plsql regex match whole word 
Sql :: mysql read row 
Sql :: sql grant 
Sql :: oracle sql , set operators 
Sql :: Insert Row Providing Value Explicitly 
Sql :: TSQL select 50 records at a time 
Sql :: postgresql 
Sql :: Monthly Birthday SQL Query 
Sql :: SQL Remove Primary Key Constraint - SQL Server, Oracle 
Sql :: employee sample data mysql 
Sql :: oarcale list objects 
Sql :: sql requete number pair 
Sql :: mysql grant user wildcard database 
Sql :: how to fetch highest score in minimum time using mysql 
Sql :: sql filter rows with condition 
Sql :: multiple value select mysql 
Sql :: mysql drop table 
Sql :: tsql rename column name 
Sql :: All Some Any 
Sql :: what is a stored procedure 
Sql :: convert google analytics dathourminute to time stamp? sql 
Sql :: mysql stand for 
Sql :: raven ql select count 
Csharp :: how to make mouse invisible unity 
Csharp :: visual studio c# print to console 
Csharp :: how to edit postprocessing through script 
Csharp :: how to convert float to int in c# unity 
ADD CONTENT
Topic
Content
Source link
Name
3+2 =