For questions involving the MySqlHelper Class.
The MySqlHelper is a class wrapper intended to make working with the MySQL data provider easier.
Questions tagged [mysql-helper]
6 questions
1
vote
1 answer
MYSQL how to update the ship amount for the order dates after 2015-03-30 15:22:31 to 15
I'm having trouble with this question: Write an UPDATE statement that modifies the Orders table. Change all ship amount for order dates after 2015-03-30 15:22:31 to 15. If you get an error due to safe-update mode, you can add a LIMIT clause to…
specter kun
- 23
- 6
1
vote
2 answers
How to get dataset from MySql Query using variables
I have a query like this:
SET @a = (SELECT GROUP_CONCAT(Id) FROM MyTable1 WHERE Id < 10);
SELECT * FROM MyTable2 WHERE find_in_set(IdLite, @a);
SELECT * FROM MyTable3 WHERE find_in_set(IdLite, @a);
SELECT * FROM MyTable4 WHERE…
genespos
- 3,211
- 6
- 38
- 70
0
votes
1 answer
Lag Based on Specified Order in SQL
Does anyone know of a way to LAG in a specified order? In the example below, I provide a table with my current output [Lag (Current)] and my desired output [Lag (Desired)] columns. I am interested in creating a lag for the event time based on event…
leaner007
- 17
- 5
0
votes
2 answers
MYSQL UPDATES, DELETES, INSERTS, CREATE clauses
I'm trying to create a database schema for Game achievements which should include these:
Users:
username,
avatar image file location,
achievements their received in each game
Each achievement has
achievement name
achievement level
achievement type
a…
specter kun
- 23
- 6
0
votes
1 answer
Call stored procedure with an output parameter using ExecuteDataset
I need to call a stored procedure in a MySQL (5.7) database from a VB.NET application. Said procedure makes a SELECT statement at the end which I need to retrieve in my app as a DataSet. Previously it worked fine, but I added an output parameter to…
Rodrigo Salgado Atala
- 334
- 2
- 6
- 24
-1
votes
2 answers
How to use MySqlHelper.UpdateDataSet
I've searched around the web looking for samples on how to use MySqlHelper.UpdateDataSet but all I've found is:
Public Shared Sub UpdateDataSet( _
ByVal connectionString As String, _
ByVal commandText As String, _
ByVal ds As DataSet, _
…
genespos
- 3,211
- 6
- 38
- 70