Hi all!
I need some help with ORDER BY in the following example. I want to order by
selected category, then by subcategories of the selected category, then by
categories with the same parent_id of the selected category, then by random
if possible, or random within the categories if possible, but t
Greetings.
I need to import data to mysql from a db format I don't know. Unfortunately
the person in charge of the data won't be reachable for the next 2 weeks and
I want to continue my work.
Does anyone knows the db format extensions like:
.bdd
.ind
.mor
.ped
Thanks in advance.
Apologies for m
Greetings.
I'm building an application and I need to import data to mysql from a db
format I don't know. Unfortunately the person in charge of the data won't be
reachable for the next 2 weeks and I want to continue my work.
I was wondering if anyone knows the format extensions like:
.bdd
Greetings.
I have Text fields in some tables which contain text in Portuguese with
accent characters like á, à, é, í, ú, ü, ó, ö, ç, etc.
When I query like:
SELECT text_column
FROM table
WHERE text_column LIKE %maçã%
[ or ]
WHERE text_column LIKE %ç%ã%
it also returns 'maca', 'maça', etc
Greetings!
I am building a website using MySQL 5.0.18 and PHP 5.1.2.
When I try to insert in a table a timestamp value from php's mktime() I get
the following error:
1292: Incorrect datetime value: '1139776424' for column 'access_date' at row
1
The sql for the table is:
CREATE TABLE `members_acs`
> -Mensagem original-
> De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>
> "pedro mpa" <[EMAIL PROTECTED]> wrote on 01/31/2006 12:49:48 AM:
>
> > Greetings.
> >
> > I need help on the following query.
> > I get an error like
Greetings.
I need help on the following query.
I get an error like "Unknown/Invalid column total_price [...]" when I try
filter by total_price.
How can I do this correctly?
SELECT receipts.*,
(SELECT SUM(receipt_itens.price) FROM receipt_itens WHERE
receipt_itens.id_receipt=recei
Solved.
Thanks.
-Mensagem original-
De: pedro mpa [mailto:[EMAIL PROTECTED]
Enviada: domingo, 29 de Janeiro de 2006 18:25
Para: mysql@lists.mysql.com
Assunto: Help on query joining a 3rd table
Hello!
I am building a query to get a monthly total for receipts and receipts plus
TAX.
My
Hello!
I am building a query to get a monthly total for receipts and receipts plus
TAX.
My problem is the TAX, it can be different for each receipt.
I need help on including and relating each TAX value/id with each receipt,
like receipt_items.price * 1.21 etc.
The tables are like the following ex
Hi!
I need help on implementing a query that performs a search for items under
nested categories. An example is on ebay search where you can restrict your
search by selecting a subcategory and you only get items under that
category/subcategories.
Do I have to first get a list of all subcategories
10 matches
Mail list logo