Varieur: I’ve read the.

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:

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

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

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

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 :