I am trying to find the number of members who have renewed their memberships for a given month and year. Members need to renew each year, and I would like to know for each month and year how many me..
Tag : mysql
I wanted to ALTER an existing table and add a new column with a foreign key constraint .
I looked at Chat GPT and also some youtube videos which showed the same syntax so I used the follwoi..
Newb question here – when I define the maximum length of a VARCHAR column (say VARCHAR(16384) for instance), does each row necessarily occupy that number of characters? For instance, if I inserted a row with only 8000 characters (rather than 16,384) into that column, would the database still reserve the full 16384 bytes of storage ..
There’s a ..
I have a table in my MySQL database with schedule templates for my workers, which are then used in a schedule planner. When there is a modification to the employee’s employment contract, a new set of records is added with the new sch..
I have a table with a b_mag field that contains about 13000 records which is VARCHAR but I need FLOAT because I have to sort them numerically and do other things.
The values that b_mag contains are all of the type 12.45, 9.5, 10.5 and some empty fields.
I created a new b_mag_num field of type FLOAT and ran this ..
EXEC %%System().FireTrigger(ID = 225, ID = 102, ID = 0, ID = 0, Value = @server,
ID = -1, ID = 0, ID = 0, Value = NULL,
ID = 7, Value = @server, Value = @srvproduct2, Value = @provider, Value = @datasrc, Value = @location, Value = NULL, Value = @ca..
When trying to restore a mysql database, I try the following. This bd is in a con..
When trying to restore a mysql database, I try the following. This bd is in a con..
The problem is that I’m making an electronic journal, ratings with full name are taken from the MYSQL database, and inside the code I have filtering in ascending alphabetical order. And if, let’s say, one person has a rating and after filtering he changes the position, then the rating remains where the name should have been before filtering…