Dopeelf: my_print_defaults.

 
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