Questions tagged [mysql]

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

Filter by
Sorted by
Tagged with
0
votes
1answer
34 views

How do I test the Ethereum Blockchain app [closed]

I have created an Ethereum blockchain application that stores data on the blockchain network. I want to test the application from a SQL injection attack using SQLMap tool. The SQLMap tool, when ...
0
votes
1answer
28 views

Trigger manual DB UPSERTs through smart contract

Can I add a trigger to smart contract to insert/update data to my traditional DB. E.g. Let's say I have students private blockchain where each student has to update their info. Once they insert/update ...
0
votes
0answers
88 views

Migrating or representing a Microsoft SQL Database on the Chain

I am wondering what is the best way to migrate or represent a massive, 50 table, Medical Health Records SQL Database on the Blockchain. Is it best done with IPFS hash on Ethereum or is Hyperledger a ...
1
vote
1answer
852 views

ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: '1545042106' for column 'test123' at row 1 [closed]

web3.eth.getBlock(12345).then(res => { connection.query(`INSERT INTO blockdata(bnumber,btimestamp) VALUES ("${res.number}","${res.timestamp}");`) }); I got timestamp already. I wanna insert data ...
3
votes
2answers
2k views

Index and query blockchain data and levelDB

Would it be more performant to query the blockchain data directly through the underlying database levelDB instead of using the provided geth api? How would it be possible? Can I just index the ...
3
votes
0answers
84 views

SQL syntax error near `logsBloom` when call web3.eth.sendTransaction

When I am trying to call web3.eth.sendTransaction I receive this error stack: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ...