In mysql field is stored 104.13 in format Float ;
With this select, I can see the record:
SELECT * FROM parcelas WHERE valor like '104%';
But with this select it does not appear:
SELECT * FROM parcelas WHERE valor =...
When I make an inquiry this way the data is returned correctly (Currently 2 rows):
SELECT * FROM noticias ORDER BY data_noticia DESC LIMIT 30 OFFSET 2
But I need to know how many rows this query returns me so intuitively it would look like...
So folks.
I need to know if I'm going to just send the hours H: i: s from the NOW() function in the database, or send the NOW() complete and then only search the hours?
On the systems I used to develop before, I used to save the full path of the file in the database.
Example:
c:\xampp\htdocs\teste\imagens\post_44\stack_overflow.png
// Image table
imagem
- id = 1
- imagem = imagens/post_44/s...
I have a problem sending email with names that come from the database.
Some names come with accents and when I get the emails the names are unconfigured.
The database is like Utf8 - Default collation
Code php:
$PHPMailer->Charset = 'U...
I created a table, where I put the user's registration on a card for printing; so this table has several records (5 per page) and for each page I access a record in the same table I made an array_push with values ->
$sql = mysql_query("SELECT...
How do not register events in the time zone that is already registered?
Example: I have an event in the DB beginning at 18:00 and ending at 22:00, I need that if the user tries to register a new event from 19:00 to 23:00 the system do not a...
I wonder if it is possible to use AND within a INNER JOIN , eg:
SELECT *
FROM tab1
INNER JOIN tab2
ON tab2.id2 = tab1.id1
AND tab2.camp1 = 'valor'
INNER JOIN tab3
ON tab3.id3 = tab2.id2;
I gave a rather silly exa...
If the maximum length of a field of type VARCHAR is 65535 (ocupa 65KB) , will it always occupy a space of 65KB in the database for each line even if I put less text in it?
EXAMPLE: Does a VARCHAR(65000) field occupy 65kb e...