Thats true, but the actuall query looked more like this
SELECT * FROM testdb WHERE col1 LIKE '$var%'
and if I left the $var empty my plan was to get all columns. But I use the
"OR col1 IS NULL" trick which solved my problem.
Thanks anyway
/Jonas
If you want all values why not just do
SELECT *
Sigh...RATFM: Read *All* The Fine Documentation. I'll remember that in the
future. Thanks for pointing that out.
j- k-
On Wednesday 03 March 2004 09:16 pm, Paul DuBois wrote:
> DATE_FORMAT() is documented here:
>
> http://www.mysql.com/doc/en/Date_and_time_functions.html
>
> Hint: Take
At 22:04 -0700 3/3/04, Sasha Pachev wrote:
Joshua J. Kugler wrote:
In the manual that came with MySQL 4.0.17 (at least in the Mandrake
packages of such) it says I can use %f to get the microseconds in a
DATE_FORMAT call. This does not work, however, and searching the
archives reveals that %f wa
Daniel R. Anderson wrote:
Whenever I start up mysql through mysqld (in my rc.d file), I get the
following error:
Warning: asked for 196608 thread stack, but got 126976
(Note: numbers vary)
Is this bad, and what (if anything) should I do about it?
In theory, it could be bad ( in some bad configu
Cliff wrote:
Recently I tried to convert our largest table from MyISAM to InnoDB. During
the process I believe there was a problem where something was corrupt along
the way. It was stupid, but I did not verify that our backup system was
working correctly, since I assumed it had been running as usua
On Wednesday 03 March 2004 08:04 pm, Sasha Pachev wrote:
> Joshua J. Kugler wrote:
> > In the manual that came with MySQL 4.0.17 (at least in the Mandrake
> > packages of such) it says I can use %f to get the microseconds in a
> > DATE_FORMAT call. This does not work, however, and searching the arc
Defryn, Guy wrote:
Hi there,
I would like to know some professional opinions on the following:
-Are there any drawbacks on installing Mysql on a windows server? Would it be possible to install it on the same server that hosts SQL server? Can they coexist properly?
I do not expect too much usage
Joshua J. Kugler wrote:
In the manual that came with MySQL 4.0.17 (at least in the Mandrake packages
of such) it says I can use %f to get the microseconds in a DATE_FORMAT call.
This does not work, however, and searching the archives reveals that %f was
only added in 4.1.1. So..which one is co
That's true. I'm only using one table. It is called a self-join. You alias
the tables in the FROM clause, and then can refer to them as two separate
tables in your WHERE clause. See the part of the FROM clause where I say
"as"? That's aliasing the table. A temporary renaming, if you will.
I only have 1 table for this job. Your example is using 2 table.
~Elle~
-Original Message-
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 11:08 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: FW: query
Oh, so what you're looking for a a find dup
Andre MATOS wrote:
>What is the best way to make a good and trustable backup from a live
>database, in other words, without shutdown the database? Is there any
>free open source tool for this also?
There's no free/open source tool that makes a true hot backup when
you're using InnoDB.
mysqldump
Oh, so what you're looking for a a find duplicates query (as MS Access calls
it). That's something like this (I'm rusty, so you might have to debug).
SELECT fname, lname, etc FROM my_table as table1, my_table as table2
WHERE table1.fname = table2.fname
AND table1.lname = table2.lname
...etc...
A
go to www.codewalkers.com under the tutorials/basics section there is a
tutorial called "Sorting Database Results with PHP". It will show you how
to display the data. If you are just looking for a quick cheat - You need
to use tables. Place each record on a table row and each attribute in
a tab
In 1 table, I probably have double records or triple records with the same
value for several fields.
Example : table customer with field customer_id, address, DOB, Services
I need to know that customer data in my table have more than 1 record for 1
customer. So he/she has more then 1 customer_id.
I don't understand your question. And if I don't understand it, there are
probably a lot of others who don't understand it either.
Rhino
- Original Message -
From: "Elly Wisata" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 03, 2004 10:20 PM
Subject: query
> Hi *,
Hi *,
How to query records that most of the fields are the same value? Izit
possible?
Thanks in advance
~Elle~
Hi,
I am using MySQL 4.0.18 with InnoDB and I would to have some suggestions
about how can I backup the data. I read in this list that some people are
using mysqldump, others are using some tools such as Hot Backup.
What is the best way to make a good and trustable backup from a live
database,
You can use MySQL's built in locking, or you can do this:
Find a job that is waiting
Run an update like this:
UPDATE table SET status = 'processing'
WHERE jobid = found_job AND status = 'waiting'
If you get back a 1 from that query, it made one change, and you're good. If
you ge
Whenever I start up mysql through mysqld (in my rc.d file), I get the
following error:
Warning: asked for 196608 thread stack, but got 126976
(Note: numbers vary)
Is this bad, and what (if anything) should I do about it?
Thanks in advance,
Dan
--
MySQL General Mailing List
For list archives: h
Hi. I am new to my my sql and have a basic question about locking.
I am running Ver 11.18 Distrib 3.23.54, for Win95/Win98.
I have a table that holds work on jobs needing processing
FieldTypeNullKey Default Extra
--- - -- ---
Recently I tried to convert our largest table from MyISAM to InnoDB. During
the process I believe there was a problem where something was corrupt along
the way. It was stupid, but I did not verify that our backup system was
working correctly, since I assumed it had been running as usual. It was not
Hi there,
I would like to know some professional opinions on the following:
-Are there any drawbacks on installing Mysql on a windows server? Would it be possible
to install it on the same server that hosts SQL server? Can they coexist properly?
I do not expect too much usage of the Mysql ser
Permissions /\
/ \
/o o \
V
^
Jeez - thank you; I was looking at all the esoteric stuff whilst the snake was
chewing on my leg. Thanks. Sockets are files(sorta). When I copied the file tree
/tmp was propagated without global write. Not a probl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You can ALTER TABLE
http://www.mysql.com/doc/en/ALTER_TABLE.html
> I´'m new with mysql and have following question:
>
> I have a table, that has a primary key with two columns and want to add a
> third column to this primary key.
>
> Is this possible and when yes: Do I have to delete all tables,
Here is what I am doing now...
SELECT id, first_name, last_name, password FROM account WHERE password =
ENCODE("1234", 'foobar') ORDER BY last_name LIMIT 0,10
I need to do a where password LIKE '%1234%' instead, I can not seem to get
this to work, is there some trick?
--
---
Since I don't use MySQL 4.1, is this query OK?
SELECT SQL_CALC_FOUND_ROWS * FROM
((SELECT * FROM t1 WHERE id>100 GROUP BY country)
UNION ALL
(SELECT * FROM t2 WHERE id>150 GROUP BY country)
LIMIT 0,10);
I want this to return all the rows of the UNION sub-query there.. the
You are correct. Sorry about that.
>>> charles kline <[EMAIL PROTECTED]> 3/3/2004 2:46:51 PM >>>
sub selects are only in 4.1 I thought?
On Mar 3, 2004, at 5:08 PM, Jacque Scott wrote:
> Also you can have subselects in 4.0.
sub selects are only in 4.1 I thought?
On Mar 3, 2004, at 5:08 PM, Jacque Scott wrote:
Also you can have subselects in 4.0.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I know, I get it, I was trying for humor.
Curtis
On Wed, 3 Mar 2004, Michael Stassen wrote:
>
> Curtis Maurand wrote:
> > :-)
> >
> > someflag enum('TRUE','FALSE');
> >
> > Not quite boolean, but it works.
> >
> > Curtis
> >
> > On Wed, 3 Mar 2004, Mark Warner wrote:
> >
> >
> >>The thin
> And the testing burden of the same software against several database
> back-ends would be considerable.
Just one comment. If you are using MySQL, there would be no "testing
burden...against several database backends." The protocol, commands,
connection methods, etc, are identical. A client
Try something like this:
SELECT ID, Name, Country
FROM peoplelist
GROUP BY Country
HAVING count(Country)>10;
That might work. Also you can have subselects in 4.0.
Hi,
I have a problem about writing a proper SELECT query
for the following goal: (I only have basic knowledge
of SQL)
Table name: peoplelist
column 1: id (not NULL, auto_incremental)
column 2: name
column 3: country
now, there are about 7,000 rows in this table. I want
to select out:
first (in
In my original post I didn't add that I close the connection just before
I exit the function.
If lngRecordAffected <> 0 Then ' if the execute was successful then
let's commit the updates
cn.CommitTrans
WriteData = lngRecordAffected
Else ' otherwise let's rollback to before
In the manual that came with MySQL 4.0.17 (at least in the Mandrake packages
of such) it says I can use %f to get the microseconds in a DATE_FORMAT call.
This does not work, however, and searching the archives reveals that %f was
only added in 4.1.1. So..which one is correct? The release anno
The parent dir, /usr/local/mysql, owned by root is fine. We can see
that the data dir is owned by mysql, but what about its contents? Try
chown -R mysql:mysql /usr/local/mysql/data
(as root or using sudo), then try mysqladmin again.
Michael
Jonathan Villa wrote:
nevermind that webmaster s
Hi,
Does any one help me in formating the output result in PHP with mysql?
The code is here.
Host Details $today";
$i=0;
while ($i < $num) {
$hostid=mysql_result($result,$i,"hostid");
$hostname=mysql_result($result,$i,"hostname");
$cabinetnumber=mysql_result($result,$i,"cabinetnumber");
echo "$h
This error usually occurs for one of two reasons:
1. There is already a /tmp/mysql.sock. You've ruled this out.
2. The user mysqld runs as, typically mysql, does not have permission to
write to /tmp. Normally, you would want to `chmod 1777 /tmp`. If
that's not appropriate for a jail, just ma
Thank you for the replies. Jail is a FreeBSD construction that provides a
chroot'ed environment that allows you to create another instance of the entire
OS. So in my case the physical server running the jails appears to the world
like 5 hosts. Each jail has its own IP and is running an independent
Sp. Raja,
please check with
SHOW INNODB STATUS\G
if purge is still running and removing delete-marked rows. Also check that
you do not have old, dangling transactions, which can prevent purge from
running, as those old transactions could still see the delete-marked rows.
Best regards,
Heikki
I
Kieran Kelleher wrote:
Here is the user, host and password fields from one of my MySQL servers
named TestServer
mysql> select user, host, password from user;
+++--+
| user | host | password |
+++-
I have an extrememly query heavy site that I tried to switch from MySQL to
PgSQL. And after spending literally a week reconfiguring thousands of
queries and rewriting code, I finally had the pgSQL version of the site
live, but when I had even a trickle of users on the site it was HORRENDOUSLY
slow
Lior,
this is probably the subquery bug that was fixed in the 4.1 source tree
about 2 months ago. The seg fault happens because MySQL-4.1.1 releases table
'intention' locks too early, and InnoDB closes the consistent 'read view' of
the transaction.
Best regards,
Heikki
Innobase Oy
http://www.inn
On Wed, Mar 03, 2004 at 10:51:40AM -0800, James Kelty wrote:
> As a DBA I have a few questions about what you said here.
>
> You have worked with both PostgreSQL and MySQL, and yet you say that
> MySQL is 'signifigantly' faster than Oracle? Can you PROVE that?
For a given set of data and workload
Michael,
I couldn't agree more! I didn't even realize there was a boolean issue
until now. I don't really understand the issue of using 0 as false, and
1 as true. The way I view it is that "true and false" are merely
abstract names for 0 and 1. When the database is accessed using Java, I
don't
Curtis Maurand wrote:
:-)
someflag enum('TRUE','FALSE');
Not quite boolean, but it works.
Curtis
On Wed, 3 Mar 2004, Mark Warner wrote:
The thing which bothers me most about MySQL is the lack of a proper
boolean. I don't like having to abstract a tinyint(1) into true or
false. As much of my
We did benchmarking, with identical schemas on identical hardware.
Second, we use InnoDB, which does have constraints, transactions and row
locking. Not sure where this significnatly out-dated idea that MySQL has no
data integrity comes from, but it's false if you use BDB or InnoDB. It will
soon b
At 16:20 3/3/2004, [EMAIL PROTECTED] wrote:
Que es la version de MySQL. De la computadora?
4.0.XX, más especificamente me refiero a la versión
4.0.15. No es la computadora.
Regards,
For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certi
In your VB code, are your connections pooled, or are you using the same
connection for each database call?
>> Original Message <<
On 3/3/04, 1:12:07 PM, Jacque Scott <[EMAIL PROTECTED]> wrote regarding
CREATE TEMPORARY TABLE:
> I am trying to create a temporary
Que es la version de MySQL. De la computadora?
>> Original Message <<
On 3/3/04, 12:42:25 PM, Miguel Angel Solorzano <[EMAIL PROTECTED]> wrote
regarding Re: Fw: imposible cargar datos en tablas:
> At 15:33 3/3/2004, Marcelo Rodriguez Salinas wrote:
> >Me podrian
I am trying to create a temporary table through code in my DB. I can do
it when I use MySQL Control Center or something like that, but when I
try to do it through my VB program it doesn't work.
Here is the sql string:
CREATE TEMPORARY TABLE IndenturedList (Level_1 TEXT, Level_2 TEXT,
Assembl
Hm. I am not a professional DBA, but I have used both MySQL and
PostreSQL for the same application, and I can say that I am more
satisfied with PgSQL. It is faster and more reliable, on the platform
that I have built (Dual Opteron 244 w/ 3GB of PC3200). While I had few
technical problems with M
> I do not approve or disapprove of your choice of Postgres over MySQL.
I don't profess to be a postgresql expert, i'm still learning about it.. but a quick
glance at the documentation tells me that the only option would be to use pg_dump
utility which creates a sql file. I haven't looked at on
nevermind that webmaster stuff...wrong 'send as' setting...
On Wed, 2004-03-03 at 12:59, HPGM Webmaster wrote:
> 1.- did you create the data dir as root?
> > chown mysql.mysql -R /var/dir-where-you-install
> Well, the data dir was created when I untarred mysql...
> > 2.- who owns the mysql dat
As a DBA I have a few questions about what you said here.
You have worked with both PostgreSQL and MySQL, and yet you say that MySQL
is 'signifigantly' faster than Oracle? Can you PROVE that? And how is it
faster to chase down data problems when MySQL has no native constraints in
it data design?
One other point that I forgot I mentioned - PostgresQL does not have a
decent replication solution. There are a few solutions, including one from
PostgreSQL.com.
The PostgresQL.com version is not the latest - you need to pay for support
to get that. The other ones were (last I looked) incomplete.
At 15:33 3/3/2004, Marcelo Rodriguez Salinas wrote:
Me podrian dcir el por que sucede esto
dependiendo de la versión de MySQL es un bug con el wait_timeout
al lado del cliente. Usa las últimas versiones.
Error Code:2013
Lost connection to Mysql server during query
Atentamente
Regards,
For techni
from the manual it appears that "char(0) null default null" can be
used as a boolean, will the values of either null or "". haven't
tried it myself, but its documented.
http://www.mysql.com/documentation/mysql/bychapter/manual_Column_types.html#Column_types
[NATIONAL] CHAR(M) [BINARY | ASCII |
Subj
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello David,
I do not approve or disapprove of your choice of Postgres over MySQL.
To best of my knowledge, Postgres does not have media (or point in
time) recovery, at all.
The only thing possible is a consistent backup, resulting in a SQL
dump. No clues how
long it will take to restore it.
Ok! =) YES was the short answer!
The long answer is: it will deeply in the choice of language you choose
(php, java, perl) and the choice of access you use to communicate with
the server (web, client-server, web service)
On Wed, 2004-03-03 at 13:32, Manda Sairam wrote:
> I would like to import
As a DBA and someone who has worked both with PostgresQL and MySQL, I think
I can answer this knowingly.
First, MySQL is significantly faster than PostgresQL and Oracle.
Second, MySQL is also a simpler database to set up and configure.
Third, the documentation is better, and there are far more t
Here is the user, host and password fields from one of my MySQL servers
named TestServer
mysql> select user, host, password from user;
+++--+
| user | host | password |
+++--+
| root | localh
Jail is a technique available on FreeBSD to have isolated environments
running on a common operating system (something similar to virtual machines,
but shares memory as main difference).
More detailed about this is available at:
http://www.freebsd.org/doc/en_US.ISO8859-1/books/arch-handbook/jail.h
chrooted ?
Rhino wrote:
Maybe you could explain what a "jail" is. In 20+ years doing systems work
I've never heard that term mean anything but "a place where criminals are
locked up".
Rhino
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 03,
Hi folks,
I have a question regarding backups taken from a running slave. I have a
slave
replicating to a master server, and do a hot backup using the following
script:
#!/usr/bin/perl
use strict;
use DBI;
use File::Copy;
use POSIX ":sys_wait_h";
my $dbh =
DBI->connect("DBI:mysql:dbname=mysql;m
That's not the way of removing the service! Change it to the older file.
Then run:
"nameofold-mysql.exe --remove"
To reinstall the service:
"nameofthenew-mysql.exe --install"
On Wed, 2004-03-03 at 13:31, Teddy Ruxpin wrote:
> (sorry my english)
> I had in my computer EasyPHP. Always worked.
do you mean inserting the whole .zip file in a table?
if the above is right, short answer is: YES
On Wed, 2004-03-03 at 13:32, Manda Sairam wrote:
> I would like to import zip file into mysql database. Is this possible?
> regards
> sairam
>
>
> -
> Do you Yahoo
Oh I see... so how would I get balance_amt to have a running balance?
Thanks,
Charles
On Mar 3, 2004, at 11:20 AM, Victoria Reznichenko wrote:
charles kline <[EMAIL PROTECTED]> wrote:
Hi all,
Just trying to figure out why the SUM() in this query is not returning
the sum, but is returning the sam
:-)
someflag enum('TRUE','FALSE');
Not quite boolean, but it works.
Curtis
On Wed, 3 Mar 2004, Mark Warner wrote:
> The thing which bothers me most about MySQL is the lack of a proper
> boolean. I don't like having to abstract a tinyint(1) into true or
> false. As much of my work involves b
Since I didn't get an answer to this, I'll try asking it another way:
has anybody gotten a binlog with binary data (images) to load from one
server to another? And if so, what version are you using?
Thanks,
- Mark
On Mon, 1 Mar 2004 21:09:22 -0800, Mark Maggelet wrote:
> Hi,
> I'm having problems
I would like to import zip file into mysql database. Is this possible?
regards
sairam
-
Do you Yahoo!?
Yahoo! Search - Find what youre looking for faster.
Hi everyone,
I have XML data with a corresponding DTD, and I want create the necessary tables and
load the data.
Does anyone has experience with this?
Are there any tools to help me?
Thanks for your advice.
Bernd
Maybe you could explain what a "jail" is. In 20+ years doing systems work
I've never heard that term mean anything but "a place where criminals are
locked up".
Rhino
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 03, 2004 11:28 AM
Subject: m
(sorry my english)
I had in my computer EasyPHP. Always worked.
I tried update EasyPHP and mysql stopped work.
I saw the Mysql service was pointing a file that doesn't
exist.
On regedit I made point to correct file "mysqld.exe".
But to the try execute the service, show a error message.
Even executi
Hello Sir,
I have a file with the name doc.db.001 It is a binary file and it is a mysql file.I
tried opening the file using load data file command but failed with errors .Actually
the problem is i donot know about the columns or the details about the db file.How can
i import such a file.
regard
Victoria:
In response you wrote:
"> Also... if I run the same query twice.. first run and selecting
columns..
> then I run the same query but selecting COUNT(*).. does the second
time will
> run using MySQL's cache?
No. Queries should be the same, byte for byte, otherwise MySQL will
treat them a
All:
I recently discovered the Show Processlist statement which is great. My
question is this...
One the process completes it falls off this list. Is there another
command that will show me the run time of the processes that have
completed?
Is this info in a log? If so, which one?
Thanks f
"Lorderon" <[EMAIL PROTECTED]> wrote:
> I'm running MySQL 4.0 and it doesn't support sub-queries...
>
> I've checked and found that the next query returns rows of counting each
> union part seperatedly and could make sum on its rows:
> (SELECT COUNT(*) FROM table WHERE id>100) UNION ALL (SELECT
I have a system running FreeBSD 4.9 four jails. MySQL is running in two of the
jails and I am trying to add it to a 3rd jail. Starting the server gets the
message:
040302 19:34:15 mysql started
040302 19:34:15 Can't start server : Bind on unix socket: Permission denied
040302 19:34:15 Do
charles kline <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Just trying to figure out why the SUM() in this query is not returning
> the sum, but is returning the same value that signed_amt contains.
> Anyone have a clue? Thanks for any help :)
>
> Here are the results I am getting:
>
> id | signed
Do these files contain the .frm, .myd and .myi file extensions? How were
these files originally created?
Original Message dated 3/3/04, 10:11:10 AM
Author: Manda Sairam <[EMAIL PROTECTED]>
Re: Re: how to import a file to the database :
The file is a binary file these are mysql db files I need
If you want all values why not just do
SELECT *
FROM testdb
...
The `%` will not match NULL values.
>> Original Message <<
On 3/3/04, 9:41:22 AM, "Jonas Lindén" <[EMAIL PROTECTED]> wrote
regarding LIKE % not including NULL values?:
> Hello list
> SELECT * FROM
If you plan on constructing this your self may I suggest that you create
a matrix of all the possible scenarios/issues you would like to trap and
define how you want to those `automatically` handled. For example,
`replication stopped`, `duplicate index`, `long running query`, `corrupt
table`, e
Hi Sasha,
after I sent this email for the list, I did some tests and I realized that
the problem could be my firewall, so I just turned off for some tests and
it worked. Now I need to reconfigure the firewall to permit access for the
MySQL.
Thanks a lot.
Andre
On Tue, 2 Mar 2004, Sasha Pache
Jonas Lind?n <[EMAIL PROTECTED]> wrote:
> SELECT * FROM testdb WHERE col1 LIKE '%'
>
> The above SELECT statement doesnt return columns with NULL values. Should it? ;).
Yes. % matches any number of characters, NULL is not character string. Use IS NULL or
IS NOT NULL operators if you want to test
Does the file contain valid MySQL syntax? If so, you can import the file
using
\. file_name
from the MySQL monitor
>> Original Message <<
On 3/3/04, 8:40:45 AM, Manda Sairam <[EMAIL PROTECTED]> wrote regarding
how to import a file to the database :
> how to i
In the last episode (Mar 03), [EMAIL PROTECTED] said:
> > Would you trust anything to developers who do not know what they
> > are doing?
> >
> > As a _novice_ developer I learned the noted aspects of MySQL: it's
> > part of knowing how the database works and how to use it, and not
> > terribly so
seems like gotcha :))
use:
SELECT * FROM testdb WHERE col1 LIKE '%' OR col1 IS NULL;
On Wednesday 03 of March 2004 16:41, Jonas Lindén wrote:
> Hello list
>
> SELECT * FROM testdb WHERE col1 LIKE '%'
>
> The above SELECT statement doesnt return columns with NULL values. Should
> it? ;). Should I
"Marco Bresciani" <[EMAIL PROTECTED]> wrote:
> Egor Egorov <[EMAIL PROTECTED]> ha scritto:
>
>>You can't do it only with MySQL. Retrieve table names from List table:
>> SELECT CONCAT("FX", Name) FROM List;
>>
>>and then use programming language to construct a query.
>
> Thank you... I've su
Hello list
SELECT * FROM testdb WHERE col1 LIKE '%'
The above SELECT statement doesnt return columns with NULL values. Should it? ;).
Should I approce the problem in another direction?
Regards
/Jonas
The thing which bothers me most about MySQL is the lack of a proper
boolean. I don't like having to abstract a tinyint(1) into true or
false. As much of my work involves building applications with Yes or No
questions, I think I am switching to PostgreSQL.
[EMAIL PROTECTED] wrote:
What advantag
> Would you trust anything to developers who do not know what they are doing?
>
> As a _novice_ developer I learned the noted aspects of MySQL: it's part of knowing
> how the database works and how to use it, and not terribly sophisticated.
Then you may be a good developer but experience tells
> >> Are you sure about quality? Check out:
> >>
> >> http://sql-info.de/mysql/gotchas.html
>
> Those have nothing to do with the quality of MySQL.
No? Why not?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
Hi,
Due to poor database design and heavy load, database tables get corrupted a
lot.
I want to monitor that process and once a table to get corrupted to repair
it on the fly and send email to the support team that table is corrupted and
reapired automatically including the hostaname, and mysql vers
David wrote:
>> Are you sure about quality? Check out:
>>
>> http://sql-info.de/mysql/gotchas.html
Those have nothing to do with the quality of MySQL.
>> I don't think i'd trust it for anything critical
>> unless you very confident your developers know what they are doing.
Would you trust an
The documentation I find describes the slave contacting the master
to initiate the replication service.
I need the master to be able to contact the slave. Is this possible.
Thanks
lee
--
Lee Chalupa
Something Else Enterprises, Inc.
[EMAIL PROTECTED]
770 381 2377
--
MySQL General Mailing
Egor Egorov <[EMAIL PROTECTED]> ha scritto:
>You can't do it only with MySQL. Retrieve table names from List table:
> SELECT CONCAT("FX", Name) FROM List;
>
>and then use programming language to construct a query.
Thank you... I've supposed it...
What about using UNION? Something like:
SEL
Manda Sairam <[EMAIL PROTECTED]> wrote:
>
> how to import a file to the database
>
> -
> I have a file called dat.db.001 in local system . It is mysql database file .
>
> I have installed mysql in my system and now would like to open the file dat.db.001
> .I am
"Marco Bresciani" <[EMAIL PROTECTED]> wrote:
> Hello all,
> I have a little problem to solve.
> I have a "List" table that lists the tables contained in the same DB. This
> table has a "Name" filed that contains such names.
>
> My problem is that the list.name filed doesn't contain the complete n
1 - 100 of 134 matches
Mail list logo
