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
0answers
25 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
17 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
77 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
386 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
75 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 ...