Tag Info

Hot answers tagged

4

What catches my eye is the Query recorded in the general log 150629 9:17:14 76946 Query UPDATE `api_dictionaryitem` SET `name` = '', `group_id` = 4, `count` = 2248844, `last_occurence` = NULL WHERE `api_dictionaryitem`.`id` = 8 when you got signal 11 09:17:14 UTC - mysqld got signal 11 ; I would suspect you hit some weird bug when running the ...


3

oNare's answer shows the principle way to achieve this. (He gets a +1 !!!) He set the variable @names as follows: SET @names="'oNare','Another'"; Then, his algorithm worked perfectly. SUGGESTION Instead of putting single quotes in @names, do it without the single quotes. Do the delimiting before processing the query with this SET ...


3

You can't pass a User-defined variable (UDF) through a IN clause, but you could make a Dynamic SQL Statement like this: Example table: CREATE TABLE user ( id int(11) NOT NULL, fName varchar(45) DEFAULT NULL, lName varchar(45) DEFAULT NULL, pwd varchar(45) DEFAULT NULL, rol varchar(45) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT ...


1

This variable controls whether binary logging should trust the stored function creators for not to create stored functions that will cause unsafe events. Eg. having UUID functions. This has been explained well in documentation: When you create a stored function, you must declare either that it is deterministic or that it does not modify data. ...


1

Perhaps you should use --single-transaction mysqldump --single-transaction -u root -p common_schema > common_schema_bkup.sql Why ? According to the MySQL Documentation on mysqldump, you need the following rights: mysqldump requires at least the SELECT privilege for dumped tables, SHOW VIEW for dumped views, TRIGGER for dumped triggers, and LOCK ...


1

I used JOIN and LEFT JOIN to modified your query: SELECT u.*, p.*, f.approved FROM test.default_user AS u JOIN test.default_profile AS p ON (u.id>1 AND p.user_id = u.id) LEFT JOIN test.default_friend AS f ON ((f.user_id = u.id AND f.friend_id = 1) OR (f.friend_id = u.id AND f.user_id = 1)) WHERE u.email LIKE '%some_string%' OR u.username ...


1

Yes you can use innodb_file_per_table = 1 for your slaves. Additionally take below points in your consideration If you have same version on MySQL on both Master and Slave. You can directly take backup and setup replication from Master to Slave by adding innodb_file_per_table = 1 on slave in my.cnf Please have a look at How to set Master Slave ...


1

That error is nonsequiter with regards to MySQL. This would especially be true if your Windows server crashed for reasons other than MySQL. There are ways to fix IRQL_NOT_LESS_OR_EQUAL. However, if you are reloading a mysqldump and it is the only reason Windows crashes, you may have to accommodate Windows until you fix the IRQL_NOT_LESS_OR_EQUAL error by ...


1

(!!! Make a backup first before trying the following !!!) Step 1 : Setting in your ini file: [mysqld] innodb_force_recovery = 1 (Change your mysql port from 3306 to something else if you don't want clients to reconnect during your recovery) https://dev.mysql.com/doc/refman/5.0/en/forcing-innodb-recovery.html Step 2: Increase the number carefully until ...


1

It appears the OP is conflating how the data should be stored in the database with how the data will be displayed and/or entered when taking classroom attendance. These are not necessarily the same thing. Display should not drive storage. The UI could display the data the way the OP shows above in a classroom attendance form and have a middle layer that ...



Only top voted, non community-wiki answers of a minimum length are eligible