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
33 views

How to import mySQL data to Solidity?

I have created a mySQL database through phpMyAdmin, storing health data. I would like to use Solidity to develop a smart contract which will implement access control to the data in the database. My ...
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
19 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
82 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
562 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
81 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 ...