Bingham: Marcosis, it is the other way round, insert . on duplicate key update .
Battaglia: Can a select and insert be combined into the same statement?
Salvesen: Dimi1947: See http://dev.mysql.com/doc/refman/5.6/en/insert-select.html
Tomson: Hey, so I read that if I set a mysql p***word to expire, a user will be prompted to change it next time they log in, which is a requirement on the project I’m working on, so two questions.1 there are scripts that use that p***word on the server. Is there a way to set some sort of trigger to update those once they change it.and 2 I’m running LXDE as the desktop, is there a way to make the p***word change happen in a
Biffer: GUI box when the user first signs into the server, and not into mysql?
Selnes: Is http://dev.mysql.com/doc/refman/5.1/en/create-table.html wrong?
Kupchinsky: Create table orders id auto_increment primary key int; dosen’t work.
Klinner: Yet, column_definition is defined as data_type . auto_increment . primary key
Strzelczyk: But now you’ve learned something, so turn that frown upside down! /perky
Decrosta: Perhaps that table doesn’t exist
Setser: I am doing this actually, http://help.unitime.org/Timetabling_Installation
Bodman: Hello. I’ve been wondering, I have 5 fields a, b, c, d and e. Lets have an example: a=500, b=800, c=700, d=600, e=500. Is it possible to write one query to update a and e to 30? a and e because I need top 3 to have their original values while everything that is less than top3 to give constant value. Any ideas?
Bouton: I am just beginning to study the INSERT.SELECT Risse.and I am not sure if it can help me,let me explain.I want to take data from two tables and and insert them in a third one.
Lazarini: Cerkauskas: you should have 3 rows instead
Barbur: Naktibalda, data could change and, for example, I would change a to 1000, it should udate e and d to 30, so I don’t think your solution is good for my problem
Cychosz: First of all this third table has 2 fields.and to fill each of them with data from the tho other tables
Giorgio: Is there a way to do a restore from db dump, but leave a specific table or set of tables out of the restore?
Maccord: I will prepare a query and tell me then if it is right or wrong.I will have to start from somewhere
Svinth: Cerkauskas: if you have them in rows, you can do something like UPDATE table SET field = 30 ORDER BY field ASC LIMIT 2;
Brittman: Dimi1947: first write a select that gives you the correct rows. you will probably be using a JOIN ON
Mokiao: Give me a second.am on it
Pargo: Cerkauskas: There is not a simple way to find the maximum 3 fields within a single row. It could be done with some effort, perhaps.
Lineberry: Cerkauskas: you would have to write a very long CASE statement for every column
Strevel: Cerkauskas: UPDATE table SET a = IF a b + a c + a d + a e 3, 30, a, b = IF b a + b c + b d + b e 3, 30, b;
Zwack: Add other columns yourself
Lillis: Cerkauskas: UPDATE table SET a = IF a b + a c + a d + a e = 3, 30, a, b = IF b a + b c + b d + b e = 3, 30, b;
Malay: I thought there is simplier way :
Luneau: Beje, malonu matyt bendratautį :
Brittman: Anill: are you getting an error? You might not need the ;
Mckouen: Is there any way to ignore or filter out the slow query log so that certain queries are excluded in the event that a query being ‘slow’ is expected?
Thaemert: Hey. I run mysql 5.6 on FreeBSD 10.2. I recently upgraded from 10.1 and it seems like mysql isn’t starting like it should. I run the script to start mysql-server and it starts 2 processes but I don’t get a socket and it doesn’t create a pid file. There’s nothing in the logs as far as I can tell.
Fortman: It has run for a while but I don’t see anything in the logs for freebsd. Does mysql have it own logs? I know very little about mysql.
Brittman: Dopeelf: my_print_defaults mysqld grep -i log
Brittman: Dopeelf: my_print_defaults mysqld_safe grep -i log