Questions tagged [mysql]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
21 views

How can I store the hash of a set of data in the ethereum and make the chain validated always?

I am working on a University Management System and I want to develop the system using Centralized Database like Mysql and to keep the data safe I want to use blockchain to store the hash of the data ...
0
votes
1answer
16 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
65 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
303 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
1k 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
72 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 ...