At 1:23 -0400 6/26/03, [EMAIL PROTECTED] wrote:
I grown my db to 4 tables 8). I'm going to ask this plainly in
hopes that my syntax in ok:
I know how to SELECT * from 2 related tables and get all the records
listed in the resultset.
(Either using INNER JOIN or WHERE.) Now... and I have been
Ok, I trying to get this example... what is table1 t1, table2 t2,
table3 t3, table4 t4, I mean, what does the t1, t2, t3, t4 represent?
If you say, table 1, table 2, etc well, I assume that, but isn't
that there already?
Let me, or may I, give ask again with my visual? Here are my tables
Hi MySQL Fans ;-);
Does anybody understand what the QUICK option is doing when used with the
DELETE command ? It says in the manual ..no MERGEing of INDEX leaves during
delete.
Sorry, but I could not make any sense out of this. Could somebody please be so
kind to enlighten me ?
I guess it is
[EMAIL PROTECTED]:
Ok, I trying to get this example... what is table1 t1, table2 t2,
table3 t3, table4 t4, I mean, what does the t1, t2, t3, t4 represent?
If you say, table 1, table 2, etc well, I assume that, but isn't
that there already?
t1, t2 etc represents an alias for the table.
Text1Hi all,
Is there any way to do a mysql dump in which each table is dumped into a
separate file. I know I can use the --tables option to specify a table,
but this means I have to type out each table name (and there are a lot
of them). Is there any way to get mysql to automatically iterate
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 1:26 AM
To: michael young; [EMAIL PROTECTED]
Subject: Re: user privileges question
At 18:02 -0400 6/25/03, michael young wrote:
Hi,
I am creating a small web based program for
Hi,
I have been working with databases for many years and MySQL for a few
months, so I'm almost embarrassed to be asking this question :( I have
searched the manual and Deja news and come up blank.
Live environment is MySQL 3.23.56 on Linux, test environment is 3.23.57 on
WinXP.
I am using
Regular MySQL 4 setup exe does not work on my version
of WINXP Pro.
Can you provide link to an MSI installer download of MySQL 4
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Rob,
I think there was a similar question today.
Is mysqldump -T perhaps doing what you are looking for ?
Best regards
Nils Valentin
Tokyo/Japan
2003 6 26 17:[EMAIL PROTECTED] :
Text1
--
---
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTECTED]
URL: http://www.knowd.co.jp
I have a question regarding compiling a C program with the mysql C api.
From the documentation, the only way I really see explained for compiling
is a shell script that looks like this:
CFG=/usr/bin/mysql_config
sh -c gcc -o $1 `$CFG --cflags` $1.c `$CFG --libs`
This works great when all my
Hi,
I've seen this question once already on this list, but no answer - has
anybody here used or otherwise have any experience of the cluster software
from www.emicnetworks.com ?
What other clustering packages exist?
Andy
--
Andy Stubbs, B.A., Ph.D.
Network Manager, Active Hotels Ltd.
+44
Daniel Rossi [EMAIL PROTECTED] wrote:
hi there i was wondering if there is anyway to setup static variables in mysql , ie
to setup predefined paths in mysql . so all i can do is go select variablname as
path etc .. ??
Nope.
--
For technical support contracts, goto
David Shealy [EMAIL PROTECTED] wrote:
I don't know where the error log is. I used the -l option with
safe-mysqld and this is what I got:
/usr/libexec/mysqld, Version: 3.23.56-log, started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command
[EMAIL PROTECTED] wrote:
I have a MySQL server running with some users besides root, that I want to grant all
privileges for their own databases, but no rights for anything else.
So to say, I have a user web01 that shall be able to do whatever he wants with the
database db01. There are more
Date: Thu, 26 Jun 2003 18:02:23 +
To: [EMAIL PROTECTED]
From: Syamsul Arifien
Subject: Help me pls
Hi ...
I hv problem...
I can't conec to my MysqlSvr with mysql_connect() in my php script..
anybody knows?
best regard
Syamsul Arifien
--
MySQL General Mailing List
For
Syamsul Arifien [EMAIL PROTECTED] wrote:
Hi ...
I hv problem...
I can't conec to my MysqlSvr with mysql_connect() in my php script..
anybody knows?
What error message did you get?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
You may be better asking this one on the PHP list:
http://www.php.net/mailing-lists.php
But you will need a bit more detail such as your version/setup/platform and
some code (without password/username that is!)
On 6/26/03 2:12 PM, Syamsul Arifien [EMAIL PROTECTED] wrote:
Date: Thu, 26
Dear All,
I have this two queries
The first one gives me the right result for the sum():
SELECT DATE_FORMAT(ordini.dataord,'%d-%m-%Y'),
SUM(ordini.totale),
SUM(ordini.quantita),
ordini.codcliente,
I run the following query:
select * from x where x like 'x/%' ;
I would like the result of this query to go to a file or pause at the end of the
screen so that I can view each page. Any help would be appreciated.
On Thu, Jun 26, 2003 at 08:07:48AM -0400, David Bush wrote:
I run the following query:
select * from x where x like 'x/%' ;
I would like the result of this query to go to a file or pause at the end of the
screen so that I can view each page. Any help would be
- Original Message -
From: Fred van Engen [EMAIL PROTECTED]
To: David Bush [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 3:11 PM
Subject: Re: Help me: I'm a beginner
On Thu, Jun 26, 2003 at 08:07:48AM -0400, David Bush wrote:
I run the following query:
EMS HiTech company is pleased to announce MySQL Manager for Windows 2.5 -
the next version of the best MySQL administration and development tool!
You can download the latest version and user's guide from
http://www.mysqlmanager.com/download.phtml
What's new in version 2.5?
1. We have added a
Pat,
I think it might be caused by the fact that you are grouping by a column
that isn't being selected - ordini.numordine is not in the select part.
Andy
-Original Message-
From: PaT! [mailto:[EMAIL PROTECTED]
Sent: 26 June 2003 12:50
To: [EMAIL PROTECTED]
Subject: sum() problems
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
pswebcode, nyc wrote:
Regular MySQL 4 setup exe does not work on my version
of WINXP Pro.
Can you provide link to an MSI installer download of MySQL 4
[EMAIL PROTECTED]
There is not an MSI installer for MySQL 4.0. There will be one for 4.1
[EMAIL PROTECTED] wrote:
Ok, I trying to get this example... what is table1 t1, table2 t2,
table3 t3, table4 t4, I mean, what does the t1, t2, t3, t4
represent? If you say, table 1, table 2, etc well, I assume that,
but isn't that there already?
Let me, or may I, give ask again with my
Hi MySQL Experts,
I am pretty new at this and need your help in figuring out if it is possible
to create a query to search for words in a given field. What I am trying to
do is allow a user to enter words to search for a given title in the
database. For example, a person is looking up the title
PaT! [EMAIL PROTECTED] wrote:
I have this two queries
The first one gives me the right result for the sum():
SELECT DATE_FORMAT(ordini.dataord,'%d-%m-%Y'),
SUM(ordini.totale),
SUM(ordini.quantita),
David Bush [EMAIL PROTECTED] wrote:
I run the following query:
select * from x where x like 'x/%' ;
I would like the result of this query to go to a file or pause at the end of the
screen so that I can view each page. Any help would be appreciated.
Use SELECT ..
You could try
SOUNDEX(str)
http://www.mysql.com/doc/en/String_functions.html
which might do what you are looking for
HTH
Peter
-Original Message-
From: Tom Johnson [mailto:[EMAIL PROTECTED]
Sent: 26 June 2003 14:23
To: [EMAIL PROTECTED]
Subject: Need your help in a search query
hi all!
i am very much interested in knowing the
intricacies of the MySql server. i use Mysql version
3.23.52.
how can we get informations regarding all Mysql
transactions and regarding the tables and databases
that have been dropped. Also how can we get the amount
of time spent
I think you are after subselects more than a UNION. The latest example
of me using union was where a had 2 queries with table A and B: first
query has tableA LEFT JOIN tableb, second query had tableb LEFT JOIN
tablea. By using UNION I was able to retrieve the results of both with
one query.
Hi-
I'm running mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) / RedHat
7.3 on a AMD 2400XP 256 MB.
I've got a table (type=MyISAM) that's grown to 1,7 GB (154,815 records) and
it takes several seconds to perform even simple querys:
select data from eod where symbol='ZOOM'
yields: 1 row
This may not help with the comma problem, but your app looks like a good
candidate for FULLTEXT searching, check out
http://www.mysql.com/doc/en/Fulltext_Search.html for information.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Tom Johnson [mailto:[EMAIL PROTECTED]
Do you have disk performance data? My guess would be it's the time to
read the information off the disk.
I think redhat has the iostat command. Try running
iostat 1
in one window while you run your query in another, what result do you
get from the iostat?
--
Michael Conlen
Bob Ostermann
Hi,
MySql crashed complaining about signal 11 after we reconfigured the db for a
large db type.(It was running fine on medium db configuration) It is running on
Solaris 2.8 with 1 GB RAM along with Resin App Server.
Does large db configuration require the whole machine to run mysql?.
At 2:58 -0400 6/26/03, [EMAIL PROTECTED] wrote:
Ok, I trying to get this example... what is table1 t1, table2 t2,
table3 t3, table4 t4, I mean, what does the t1, t2, t3, t4
represent? If you say, table 1, table 2, etc well, I assume
that, but isn't that there already?
t1, t2, etc. are
At 16:22 +0900 6/26/03, Nils Valentin wrote:
Hi MySQL Fans ;-);
Does anybody understand what the QUICK option is doing when used with the
DELETE command ? It says in the manual ..no MERGEing of INDEX leaves during
delete.
Sorry, but I could not make any sense out of this. Could somebody please be
At 6:32 -0400 6/26/03, Andrew Pierce wrote:
I have a question regarding compiling a C program with the mysql C api.
From the documentation, the only way I really see explained for compiling
is a shell script that looks like this:
CFG=/usr/bin/mysql_config
sh -c gcc -o $1 `$CFG --cflags` $1.c
I've been having a few problems loading blobs via the LOAD_FILE function
I've tried things along the lines of:
UPDATE table SET binaryRecord=LOAD_FILE(/Users/shared/filename.mov)
where refNo=1;
It only seems to happen when loading something over 1-1.5mb, as I've
been able to load smaller
* Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
On Tue, Jun 24, 2003 at 09:14:18PM -0700, Carl B. Constantine wrote:
I want to be able to take a database running on a primary server and
duplicate/mirror it on a secondary server. I want to be able to update
the secondary server on a selectable
can someone help me with this error, with my database in MySQL 3.23.49
SQL-query :
SELECT *
FROM `traffic`.`trafficdb`
LIMIT 132947
MySQL said:
Got error 127 from table handler
have I lost the data, or is there something odd happened which i
Please bear with me here as I am new to this whole MySQL thing. Does
anyone know where I can find a good example of how the C API function
call mysql_thread_init() is implemented? Any help would be
appreciated. Thanks in advance.
Sean
--
MySQL General Mailing List
For list archives:
Check the client sources.
The mysql client is a great example for the c API.
Sean Macmillan wrote:
Please bear with me here as I am new to this whole MySQL thing. Does
anyone know where I can find a good example of how the C API function
call mysql_thread_init() is implemented? Any help would
Just a guess from a raw newbie, but try using:
`traffic.trafficdb` instead of `traffic`.`trafficdb`
Ryan
Thursday, June 26, 2003, 1:13:03 PM, you wrote:
SD can someone help me with this error, with my database in MySQL 3.23.49
SD
SD SQL-query :
SD SELECT *
SD FROM
We are in the process of implementing enterprise wide (20,000+ users)
application that will use mySQL as the Database engine. I was wondering if
the slashdot readers can provide me some details about best practices /
experiences for Backing Up and Restoring mySQL Databases. I am planning to
setup
Where can I find more info on converting and what can be converted.
Thanks
Mike Benzel [EMAIL PROTECTED]
Promote your Product with a Free SkyWiremeeting!
SkyWire Meeting - Internet Training from you PC or our Server.
thanks for your hint in that direction!
i'm currently using the latest mysql 3.23, but i guess, i'll upgrade to 4.0 before i
get my server up and running.
but what i found, and may be more appropriate for my needs is the --safe-show-database
option. i just added it to /etc/my.cnf, restarted the
If your tables are InnoDB, you could look at InnoDB HotBackup:
http://www.innodb.com/hotbackup.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: SAQIB [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 11:45 AM
To: [EMAIL PROTECTED]
Subject: Best Pratices
Sounds like a corrupt table, try REPAIR TABLE:
http://www.mysql.com/doc/en/REPAIR_TABLE.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Steven Dowd [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 11:13 AM
To: [EMAIL PROTECTED]
Subject: error message
If your tables are InnoDB, you could look at InnoDB HotBackup:
http://www.innodb.com/hotbackup.html
No I m not using InnoDB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I ran iostat, what are important values to consider?
I ran the job from 12:31:51 to 12:32:18. I can see there was a noticeable
drop in tps. I should mention that this node is basically idle at this time
(it's a new development node, so no non-core processes except mysqld.
Linux 2.4.18-3
mysqlhotcopy does your locking for you.
SAQIB wrote:
We are in the process of implementing enterprise wide (20,000+ users)
application that will use mySQL as the Database engine. I was wondering if
the slashdot readers can provide me some details about best practices /
experiences for Backing Up
Hello all,
My /var partition has become full, and now when I try load my db (the files
are in /var/lib/mysql/db/) I get the following message for the table
my_table:
use db;
Didn't find any fields in table 'my_table'
I then do describe my_table and I get:
ERROR 1016: Can't open file:
Hi there,
Is there a way to upload a saved script file into the GUI window to
execute? On the GUI interface, there are SAVE, EXECUTE buttons. But I
cannot find anything for uploading, even copying functions.
Thanks for the help.
Regards,
Sean Tang
perror 145
Vikas Gupta wrote:
Hello all,
My /var partition has become full, and now when I try load my db (the
files are in /var/lib/mysql/db/) I get the following message for the
table my_table:
use db;
Didn't find any fields in table 'my_table'
I then do describe my_table and I get:
Dear All,
I have these two queries which are supposed to return the same results
for the fields with the same name (ex query 1 sum1 = query 2 sum1):
The first query gives me back the correct result for the sum():
SELECT DATE_FORMAT(ordini.dataord,'%d-%m-%Y') date1,
I've got an interesting problem for you all. I'd love to hear what you think.
I've simplified the database design of my web application to its root problem,
so it'll be very easy to see my difficulty, and if you're feeling generous
possibly offer a solution.
I have two tables.
member table
mysqlhotcopy does your locking for you.
So running
./mysqlhostcopy dbase /path/to/backup/dir
is perfectly safe while database operations (selct, insert, update etc)
are being performed?
---
Saqib Ali
http://www.xml-dev.com
--
MySQL General Mailing List
For list archives:
I'd be interested to see what happens when MySQL gets run on a G5.
SPECint and SPECfp numbers look very good. there is an 8GB RAM limit on
it, though.
Curtis
On Tue, 24 Jun 2003, Jeremy Zawodny wrote:
On Tue, Jun 24, 2003 at 05:37:24PM -0400, Curtis Maurand wrote:
Linux compiled on
Why would you expect they should have the same results?
The second query contains a join and may have many times more rows in
the result set.
PaT! wrote:
Dear All,
I have these two queries which are supposed to return the same results
for the fields with the same name (ex query 1 sum1 = query
The G5 may not be all Apple says it is, but then, nothing is what it
seems when it comes to CPU's and performance tests. That said, if anyone
who wants to buy me one when they come out, I won't complain.
Interesting article. get's a bit numberish though.
It is a perl program, so you can look at it and see.
SAQIB wrote:
mysqlhotcopy does your locking for you.
So running
./mysqlhostcopy dbase /path/to/backup/dir
is perfectly safe while database operations (selct, insert, update etc)
are being performed?
---
Saqib Ali
http://www.xml-dev.com
On 26 Jun 2003 at 12:24, SAQIB wrote:
mysqlhotcopy does your locking for you.
So running
./mysqlhostcopy dbase /path/to/backup/dir
is perfectly safe while database operations (selct, insert, update
etc) are being performed?
Yes, but the inserts and updates will all be blocked until
On 26 Jun 2003 at 15:07, gerald_clark wrote:
The second query contains a join and may have many times more rows in
the result set.
[snip]
++-+--++--+
| date1 | sum1| sum2 | cod| fromprev |
SELECT * FROM ardata
WHERE title REGEXP '.*2000.*'
change that into parameter, but if you want to search on multiple words as
OR, youll have to split them and do separate ORs on tile REGEXP per word, or
rewrite this one something like .*(2000)|(leagus).* perhaps, not sure if
grouping is suported
Well, the find / -name mysql.sock didn't return anything at all so this
*is* an odd predicament. Would it work if someone with a similar
version e-mailed me a copy of their mysql.sock file?
Kevin
John Nichel wrote:
It doesn't look as if you have any conflicting MySQL versions. When the
What is the purpose of the join? I think I know what you are trying to do
so make the first query a sub query and join the subquery to the carello
table.
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com -
Is this better than using mysqldump?
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On Thu, 26 Jun 2003, SAQIB wrote:
Hello all,
Does anyone know if you can put the value(not the string) NULL?
Something like
UPDATE TABLE some_table SET field = NULL
Thanks,
Bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 13:48 -0700 6/26/03, Bill2 wrote:
Hello all,
Does anyone know if you can put the value(not the string) NULL?
Something like
UPDATE TABLE some_table SET field = NULL
Sure. If the column isn't defined as NOT NULL, anyway.
Why? Did you try this and get results you didn't expect?
Thanks,
your statement will do just that, but make sure the field has no default
value and allows NULL
- Original Message -
From: Bill2 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 1:48 PM
Subject: can you insert null?
Hello all,
Does anyone know if you can put the
mysqldump creates text files containing insert statements that recreate a
table and repopulate it with data. They are somewhat portable across
database servers and human editable if necessary. They take up less space
than the original table because they do not contain indices (only the
Hi,
I would like to know if there are some websites, references (except the
manual ;) ), exemples of using the libmysql, especially from windows.
I get crazy trying to call the dll from a C# environment !! I get
nothing else than a NullReferenceException ???!!!???
I read that for using the
At 14:20 -0700 6/26/03, danchik wrote:
your statement will do just that, but make sure the field has no default
value and allows NULL
Why would it matter if it has a default value?
- Original Message -
From: Bill2 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 1:48
hm? i just did a little test on mysql 3.23.56-nt, and had no problems setting a null
value on a null column having a default value other than null. it turned to be null,
rather than the default value.
··· yves at unclassified.de
-Ursprüngliche Nachricht-
Von: danchik [EMAIL
mysqladmin -uroot -ppassword reload
Curtis
On Tue, 24 Jun 2003, Riaan Oberholzer wrote:
Hi,
I am created a user by using:
GRANT ALL ON *.* TO username@% IDENTIFIED BY
password
I did this from the mysql command line tool, logged in
as root. The command succeeds and the new user is
Cool, Thanks a ton. I think I will stick with mysqldump for a while until
my tables get too large. Currently my backups only take a few seconds.
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com - Shop
Yes, that works for Teradata and Oracle as well.
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On Thu, 26 Jun 2003 [EMAIL
I am having a similar problem. I looked at another Linux machine that
has MySQL 4.0.13 running on it and the file /var/lib/mysql/mysql.sock
is there but it is empty. So I created the file, chmod to 777 and then
tried to light up /usr/bin/mysqld_safe and it is giving the same error
message
Hello All,
Could somebody please enlighten me as to why it takes nearly 2 hours to put 8 rows
of data into my table?
The insert commands I use are:
insert into mytab2
select y03m02_Pt.person, y03m02_Acdt.place, y03m02_Acdt.charge_id, y03m02_Acdt.disch,
y03m02_Pt.age, y03m02_Pt.sex,
On 26 Jun 2003 at 17:16, Ware Adams wrote:
mysqldump creates text files containing insert statements that
recreate a table and repopulate it with data. They are somewhat
portable across database servers and human editable if necessary.
They take up less space than the original table because
Steven
Why do you include the field name in your FROM part ? The syntax is SELECT
fields FROM table
I guess that could be the reason. Try with :
SELECT *
FROM `traffic`
LIMIT 132947
Freddie
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Donnerstag, 26. Juni
On 26 Jun 2003 at 17:45, Charles Vos wrote:
Could somebody please enlighten me as to why it takes nearly 2
hours to put 8 rows of data into my table?
It's not the INSERT that's taking so long -- it's the SELECT. Try
the SELECT alone, and it will probably take the same amount of time.
I keep getting this error when I try to create a new database:
mysql create database cheese_catalog;
ERROR 1044: Access denied for user: '@localhost' to database'cheese_catalog'
--
Ed Kiefer
Advantage Mail Services
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
was the field type varchar? because it seems that no default varchars set
the NULL or (NULL) as a literal (NULL) not a binary 0 for some reason.
- Original Message -
From: [EMAIL PROTECTED]
To: danchik [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 2:31 PM
Subject:
Actually, denormalizing aside, are multiple Joins or statements like...
SELECT lastName, location, model, make
FROM people, make, models, machines
WHERE people.peopleID = machines.peopleID AND make.makeID =
models.makeID AND models.modelID = machines.modelID
...common?
I guess that's actually
I take that back about defaults, worked fine on all types... the earlier
test i did on varchar after inserting NULL i brought the field up in edit
mode and aparently the editor converted it to literal (NULL) from NULL
(maybe it thought to be smart with varchars) where as the actual stored
value
I ran the SELECT without the INSERT earlier today and it ran considerably
faster (at least 4 times), so I didn't think that it would be too bad to insert the
data.
Would it be faster to combine the two SELECT statements into:
insert into mytab2
select y03m02_Pt.person,
hm, no, it works fine with int and varchar(40)
-Ursprüngliche Nachricht-
Von: danchik [EMAIL PROTECTED]
An: [EMAIL PROTECTED]
Gesendet: Freitag, 27. Juni 2003 00:01
Betreff: Re: can you insert null?
was the field type varchar? because it seems that no default varchars set
the NULL
hi there
I wrote this querie :
select pop, prot, sw_or_local, sum(qtd_porta) as soma from clientes where
status'C' group by pop,prot,sw_or_local
And I have this result :
+++-++
| pop| prot | sw_or_local | sum |
On 26 Jun 2003 at 15:01, danchik wrote:
was the field type varchar? because it seems that no default varchars
set the NULL or (NULL) as a literal (NULL) not a binary 0 for some
reason.
You're confusing various meanings of null. NULL in SQL has nothing
to do with binary 0 bytes (which would
Fabio Bernardo wrote:
select pop, prot, sw_or_local, sum(qtd_porta) as soma from clientes where
status'C' group by pop,prot,sw_or_local
And I have this result :
+++-++
| pop| prot | sw_or_local | sum |
+++-++
|
Major problem!
I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is
- quad-xeon (500mhz each cpu)
- 3 gig RAM
- Linux Redhat 7.3
When I start up mysql, processes looking like the following begin to pile up
until it kills the server:
| 106 | unauthenticated user |
Hi MySQL Fans,
I understood that within the mysql command line client there exist two help
pages:
a client help page - accessable with help
a server help page accessable with help all
I found that the file (seems like a table within the mysql privilege database)
was not included in the 4.1
Hi Subhakar,
I would be interested to know what you mean with roll forward ?
In case you have another backup let's say @10AM you could use this one, but if
you dont have another backup where do you want to do a roll forward from ??
Do I miss something here ??
Best regards
Nils Valentin
I'd instead setup a 2nd backup server that's a slave to the master,
replicates all the time, keeps in sync.
At X time, stop replication/mysql, backup data to tape .. restart mysql
and it will catch up/re sync back to master..
On Thu, 26 Jun 2003, SAQIB wrote:
mysqlhotcopy does your locking
Hi Keith,
The wrong IP address could only avoid a client to connect to the database
server.
If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in
config.inc.php or which ever tool you use than of course it will try to
connect to this IP address.
Best regards
Nils
hi there i dont think this will help any further on my full text searching but i would
like an example of how to use FORCE INDEX , there is no example on the mysql site and
the hint is misleading i am getting sql errors , lemme know thanks
--
MySQL General Mailing List
For list archives:
sorry i worked it out put it after the table , i got some interesting results
Queried The Database 1 times for 9.9892050027847 seconds
+---+--+--+--+-++--+-+
| table | type | possible_keys
I have this
CREATE TABLE `dictionary` (
`id` int(11) NOT NULL auto_increment,
`word` text NOT NULL,
`def` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
I have a huge text file, that is in the format of
stringtabstringreturn
I want to load this into mysql, but I
1 - 100 of 109 matches
Mail list logo