 | | | MySQL General | | Jonas Lind?n <jonas.linden@(protected) > wrote
> SELECT * FROM testdb WHERE col1 LIKE '% '
>
> The above SELECT statement doesnt return columns with NULL values. Should it? ).
Yes. % matches aIf 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` handledLee Chalupa wrote
>
> 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 thischarles kline <ckline@(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 contaiManda Sairam <mandasairam@(protected) > wrote
>
> how to import a file to the database
>
> "Marco Bresciani " <m.bresciani@(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 " Hi there.
I 've a table with an auto_increment primary key. I want
to reuse keys (index numbers) that becomes vacant when
I delete entries.
How do I list the vacant keys from a table?
ExampHi!
At first thanks for your help.
Now I can change the PRIMARY KEY of the table but now I have a new
question
How can I change the FOREIGN KEYS?
Best regards
Michael R.
--
MySQ
> > > 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 T "Lorderon " <ighen@(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 Scott Hamm <ScottHam@(protected) > wrote on 17/09/2004 13 15 30
> mysql > create table list_admin (
> - > admin_id int(11) default '0 ' not null auto_increment
> - > )
> ERROR 1067 (420Hi
Our main database server is a 2 x PIII 1.2Ghz with 1.5GB RAM and a 73GB SCSI RAID-5 made up of 3 36GB disks. It does between 300 and
1200 queries per second. The read to write ratio is about "Ranetbauer Michael " <Michael.Ranetbauer@(protected) > wrote
> Hi Richard
>
> At first thank you for your answer.
>
> I 've tried your solution but when I try to drop the PRIMARY KEY I get
> Hi!
I am trying to install mysql++ from an rpm but I get dependency failure
[root@(protected) mayn]# rpm -iv mysql++-1.7.9-4.rh80.i386.rpm
error failed dependencies
libmSp. 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 purgOn Tue 2004-03-02 at 19 00 Bostjan Skufca (at) domenca.com wrote
Bostjan
At first I shall mention you have set up your experiment the hardest way
for comments. You have different hardware The real name of the rpm package should be inside the .spec file
contained within the rpm file.
Best Regards!
On Tue 2004-03-02 at 17 53 David Quenzler wrote
>
>
> My machines have seEmpty
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscribe http //lists.mysql.com/mysql?unsub mysql@(protected)Hi!
First of all in order for us to help you we will need more concise
descriptions of your problems installing mysql i guess for what you are
saying that you are installing on windows so we If you are wanting a checkbook like display then each entry is either a
debit or credit and each is on its own line.
Your query will display this. I would add an ifnull to display a zero
when the thow do I get the digest form instead of individual emails?
Karthik Viswanathan wrote
> Thanks for the information. Before I try to further look into the query
> I would like to know if there is some memory issue. Its strange since
> the speed for execu "Nisim Lior " <lior.nisim@(protected) > wrote
> My server crashes on sub qurey can any one help ?
[skip]
I wasn 't able to repeat crash with my test table and test data. Could you create a repeaI apologize if this has been discussed or reported as a bug (I searched a bit
but couldn 't find mention of it).
When you create a table using the CREATE TABLE IF NOT EXISTS...SELECT syntax
what "Lorderon " <ighen@(protected) > wrote
> > the only why i know how to do this is to write the ind sums to a new table
> > and then sum that table..
>
> How you do it with a new table?
CREATAn invalid datetime or in your case an empty value will be set to the
nearest zero value representation.
> > > > > > > > > > > > > > > > > > Original Message < < < < < < < < < < < < < < < < < <
On 3/2/04 1 06 50 PM Mark RiJonathan Villa wrote
> Ok I 've always used intel machines but this time I 'm stuck using a
> AMD Athlon(tm) XP 1900+
>
> The only AMD I see for download is the AMD64 which is not what I have
Hi
I faced a speed access problem today with the MySQL. In the morning was
working well and fast but after lunch when I tried to access the MySQl
using Apache+PHP it was terrible. For just a A few things to try
1.- did you create the data dir as root?
chown mysql.mysql -R /var/dir-where-you-install
2.- who owns the mysql data dir and it 's parent dirs?
ls -lka /var/dir-whereHi everyone. Has anyone tried building MySQL with Visual Studio .NET
2003? I find two problems
1) The files /strings/Strings.asm and /strings/Strxmov.asm do not
compile due to a command-line p |
|
|
