Questions tagged as 'store'

0
answers

how to do an update sql query correctly

I am setting up a stored procedure to update some data in a table but when I update it executes correctly but does not write anything about the database USE [qappdotnet] GO /****** Object: StoredProcedure [dbo].[webhook] Script Date: 10/23...
asked by 24.10.2018 / 01:26
0
answers

rewriting Mysql fields or fields to null

I have a hosting in Godaddy of unlimited space with a MySQL database in MyISAM for my application. The bbdd has a weight of 280.4Mb and one of the tables contains 120713 records. For some time now some of these fields in this table are being...
asked by 14.09.2018 / 19:41
1
answer

Problem in mysql stored procedure (Illegal mix of collations (utf8_unicode_ci, IMPLICIT) and (utf8_general_ci, IMPLICIT) for operation '=')

I have a stored procedure, which tries to validate that the user and the mail that is being entered does not exist in the database before creating the record (inserting them) in the database. The code I have is this: CREATE DEFINER='root'@'loc...
asked by 29.08.2018 / 04:35