python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - mysql-workbench

Mysql-how to assign value from a field of select into local variable?

I'm trying to assign a value from a field of a select statement to a local variable in my trigger. Does it have any way to do that? Any help would be very appreciated My trigger DELIMITER $$ CREATE T...
test-img

Phan Quang Thang

mysql

triggers

mysql-workbench

Votes: 0

Answers: 0

Stored procedure that only updates chosen column if user is allowed

I need to write a stored procedure that would allow a user to change the values in a table, but only in certain rows. Basically this is for investigators to define the sensor parameters they want and ...
test-img

João Tavares

mysql

mysql-workbench

Votes: 0

Answers: 2

Latest Answer

SET Column = value - mysql does not do variable substitution for column name you either need to use dynamic sql or test and update for every column to be changed WHERE id = 'CultureID' - This should p...
test-img

P.Salmon

My SQL Workbench: Lost connection to MySQL server at 'waiting for initial communication packet', system error: 60

I have an issue when connecting to the database. Last week everything is running well. However, today I tried to connect again and it appeared the messages like: Lost connection to MySQL server at 'wa...
test-img

Thompson Phung

mysql

mysql-workbench

system-error

Votes: 0

Answers: 1

Latest Answer

first tests: 1 can you ping database? 2 are you in LAN or outside your network? 3 if outside your network do you have static or dinamic IP? 4 check your router configs (if you set a dinamic IP, maybe ...
test-img

raOliveira

MySQL stored procedure with transaction syntax error

I have actually moved to MySQL from SQL Server and it looks like the SQL syntax is quite different, I'm having hard time to complete creating the below stored procedure as I'm get different kind of er...
test-img

Abed Ajarmeh

mysql

mysql-workbench

Votes: 0

Answers: 1

Latest Answer

Thanks @P.Salmon, worked just fine. DELIMITER // CREATE PROCEDURE CreateCustomer(IN email VARCHAR(100),IN passVARCHAR(128),IN phoneNumber VARCHAR(12),IN gender INT,IN birthday DATE) BEGIN DECLARE las...
test-img

Abed Ajarmeh

Posts

Questions

Blogs

Jobs