Seefried: Though not sure md5 is secure enough
Hamm: This is for a school project I hope
Berthelot: Using wamp makes this fruserating. tried to instal openssl when id dint realize it came presinstalled and *****ed it all up lol
Kwiecien: Once im versed i nsecurity ill make it nice and secure.
Karpiak: Idd take security 2 in 2003 but times have changed.
Fasheh: I type incorreclty because of asigmatism. thanks. later.
Venzke: Can we do math in databases like multply, divide etc?
Gliem: I meant, are there any other ways
Bacco: Varieur, I was wondering Select 1 / 3 has an answer that cannot fit in any memory
Starring: Maybe explain what you want to do in addition to explaining why you want to do it in another way?
Detrich: Lost_soul, precision math
Varieur: Voyage: no idea what “cannot fit in any memory” means.
Suss: Varieur, what is the answer of 1 / 3? Your answer has your answer
Kuhns: I think he may mean something like pi that would just keep going on endlessly
Varieur: Voyage: include precision.
Manross: Voyage: select cast1 / 3 as decimal9,6;
Varieur: Voyage: add decimal places.
Manross: Voyage: https://dev.mysql.com/doc/refman/5.6/en/cast-functions.html
Varieur: Lost_soul: knowing Voyage, he’ll be confused for a while
Manross: Voyage: select 1.0000 / 3.0000;
Delawder: Manross, what is 9 in select cast1 / 3 as decimal9,6;
Manross: Voyage: go look at the url
Manross: Voyage: or look at the DECIMAL data type
Holsworth: Voyage: See http://dev.mysql.com/doc/refman/5.6/en/data-types.html
Bayhonan: Manross, cant find what is 9 in select cast1 / 3 as decimal9,6;
Christine: I get that 6 is the number of decimal places but what is 9
Manross: Voyage: or look at the DECIMAL data type
Dominique: Browsing down. Have to looik later. Thanks!
Canton: Salary DECIMAL5,2 in this example, 5 is the precision and 2 is the scale DECIMAL5,2 be able to store any value with five digits and two decimals, so values that can be stored in the salary column range from -999.99 to 999.99.
Jabbie: I have complex sql query including joins dan subqueries
Marcusen: The problem is that I am no sure about what columns to add in a multicolumns index table
Southworth: And it would take lots of time to try if I incorrectly set the index because the table I am working on has 1M plus data on it.
Weymouth: Ask : is there any suggestion toolonline is okay for picking me up which columns should be added if I provide certain query on it?
Off: How do I store arrays in a mysql db?
Kaczmarski: Curmet: See http://dev.mysql.com/doc/refman/5.6/en/multiple-column-indexes.html
Daltorio: Varieur: I’m actually getting multiple arrays for different columns
Tuchman: An unset not empty TIMEDATESTAMP matches on field = ‘whatever’ – is that cause it trys to cast it, ends up with 0000, and then 0000. is = 0000 field default – and if so, can i stop that other than using LIKE
Prevot: Can anyone explain what is p.*, f.* in this example http://stackoverflow.com/questions/17371639/how-to-store-arrays-in-mysql
Cardo: Varieur: I don’t want any support, I just want to know the meaning of that command
Camarillo: Varieur: its pretty old. 2 years back
Safa: Varieur: I just wanted to know the meaning of those commands,
Varieur: Ask the real MySQL question instead.
Seier: Varieur: what do INNER JOIN and ON mean?
Grinkley: Also, how can I merge query results from multiple table at once
Caudill: Varieur: I’ve read the manual about multiple column as you suggested, I’m just not so sure about what I am doing unless I test and test the index again , but it would take time. the EXPLAIN command in mysql does help a bit , but again not sure :