Skip to main content

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
2 answers
18 views

storing login credentials, mySQL or IPFS

hi im very new to developing, total newbie here and im on my final year project on blockchain development. i want to ask if for creating a login session we must store the credentials (username & ...
rokuroxx's user avatar
0 votes
0 answers
28 views

How to calculate ETH percentage supply in profit?

I'm trying to calculate the ETH percentage supply in profit. Definition is: The percentage of circulating supply in profit, i.e. the percentage of existing coins whose price at the time they last ...
Leo Nguyen's user avatar
0 votes
0 answers
5 views

Remote access local mysql server

I'm using Laravel and Hostinger as a web hosting, how will i get or send data to my local database on ubuntu ? Can you suggest any solution on how will i do this ? thank you!
drei-sys's user avatar
1 vote
3 answers
107 views

How to get all transactons of a specific address?

I am trying to retrieve all transactions for a particular address at once. My current approach is to collect all transactions of all blocks in MySQL DB and issue a query like "SELECT * FROM table ...
Pierogi's user avatar
  • 203
0 votes
2 answers
67 views

2 kind of NFTS in one contract / how to access SQL DB

first of all sorry if this was asked before but i couldn't find a appropriate answer, and im pretty new to all of this, so thanks in advance for your understanding. i want to create a game (1on1) ...
m k's user avatar
  • 1
1 vote
1 answer
99 views

Is it possible to create a game that can withdraw a coin balances tracked off-chain?

I have a game where the data is saved in a MYSQL database Is it possible to create a "play to earn" game, that the balance is saved in the database and the user can make the withdraw using ...
jureg chave's user avatar
0 votes
1 answer
57 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 ...
Ujjwal Vaish's user avatar
0 votes
0 answers
121 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 ...
0TTT0's user avatar
  • 672
1 vote
1 answer
2k 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 ...
戴廷逸's user avatar
5 votes
2 answers
3k 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 ...
jeff's user avatar
  • 603
3 votes
0 answers
118 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 ...
Dmytro Zarezenko's user avatar