select

Hi all, I would like how to function select working internals. If each select in BD is mono process or various select is processes in same time without lock table? Tks Marcos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

How can I export compressed databases in MySQL?

Hello everyone, I have to export my databases and I get large files for my dump. How can I export compressed databases in MySQL? I use: #mysqldump --default-character-set=latin1 -u'name_user' -p'pass' 'database_name' > $path/file_name.sql; Thanks, Marcos

Store MySQL data files and log files (log bin) separated!!!

this Thanks Marcos Santos Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/

function select now()

ave the sources of this program :( Thanks. Marcos

Reading oracle table

e name has no extension, it is like this: File_nameBKSql Is there a easy way to read it in Mysql? Ho do I proceed? Thanks very much, Marcos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: deleting rows which table1.row=table2.row

yes, sorry. my intention is to delete repeated rows from TABLE1. and since its a bit difficult with mysql the way that i take is create a new table TABLE2 with the repeated rows (but not repeated in TABLE2), and then i want to delete from TABLE1 all the rows which also are in TABLE2. later on, i I

creating a new table from a SELECT

how can i create a new table from a SELECT...WHERE... ? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

deleting rows which table1.row=table2.row

how to delete rows which table1.field=table2.field thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Exists anything like Oracle TO_DATE('31/12/2003','dd/mm/yyyy') ?

Hi everybody, Is there any function like Oracle TO_DATE in order to insert a date into a DATE type field according to a different format than -mm-dd? I wish to insert a date into a date field but my date format is "dd/mm/". If not, is there any workaround using mysql functions? AFAIK my

Re: A little problem with SELECT

SELECT a.* FROM company a, employee b WHERE a.id=b.cid AND (b.name='joe' OR b.name='bill'); _____ Marcos Henke _ - Original Message - From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc:

Re: help me, please

Select max(No) from table Marcos Henke - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "mustakim abas" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, December 19, 2002 1:51 PM Subject: Re: help me, please > At

connection delphi 6 / ADO with the mysql

I am needing to do a connection delphi 6 / ADO with the mysql that is in a linux Freebsd of the qmail. Does anybody know as I can make that? Thankful, Marcos Birro Calixto [EMAIL PROTECTED] Webmaster - WebDeveloper - Delphi UIN: 9151558

removing mysqll

command? Ângelo Marcos Rigo Webmaster Colégio Anchieta [EMAIL PROTECTED] Visite nosso site www.colegioanchieta.g12.br - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Mysql X Win98

Olá, instalei o mysql no Win98 porém o mesmo não está OK. Alguém tem um passo a passo, porque estou com pressa para procurar na web, mas me parece que tem que ter o perl instalado, isto confere? Marcos P.S.: estou usando Win98 e PWS

random select

hi, i would like to show 5 random field from a total of 100. id is my primary key id name -- abmarcos akjohn how can i show 5 of them randomly? thanks in advance, marcos [EMAIL PROTECTED

changing some tables

. CREATE TABLE user ( login varchar(50), pass varchar(50), att1 varchar(10), att2 int(4), PRIMARY KEY(login)); mysqldump -u user -p password table > table.txt is this right? regards, marcos lloret [EMAIL PROTEC

Brain cramp or unsupported SQL?

>From what I've read in the docs, this should work, yes? select mcorder.ord_id, project.address, mcuser.last_name from project inner join (mcuser inner join mcorder on mcuser.usr_id = mcorder.usr_id) on project.prj_id = mcorder.prj_id; Or am I just stoopid today? ---

"source" vs "\."

I thought \. was a shorcut for "source". Yes? This works: mysql> source /var/lib/mysql/create.txt; This does NOT work: mysql> \. /var/lib/mysql/create.txt; Is there some config setting that I've screwed up? tia - Before pos

mysqldump core dumping mysql

Hi! I'm having core dumps in mysql 3.23.28 ( BSD 4.2 ) during mysqldump. I've tried different options, now I'm currently running: mysqldump -F -l -q -O max_allowed_packet=16777216 db but sometimes mysql core dumps. Thanks for any idea!