Hi.
On Wed 2002-08-14 at 06:15:22 +, [EMAIL PROTECTED] wrote:
hi guys
this is a weired problem .
my site s almost done and workin fine on my machine
ive just uploaded it and it AINT worin on the host
i confirmed php and mysql support
ve made all the tables and everything
Dear Friends
I observed the very strange problem with my Mysql , My be this is the feature or I
have not configured it properly
please do tell me the reasons and remedy.
Problem is
I am inserting the fields through VB.
When I insert the record in the table of Mysql . Mysql inserts the
Toby:
Wrong forum. Go to php.net and search around there.
Off the top of my head, my guess is the provider has a global include that sends
headers before your page gets a chance to do so. You could try creating a page
called woka-woka.php containing the following and see what it looks like:
Hi,
Somewhere in your code you jump over mysql_free_result() after you
retrieving some data(mysql_fetch()).
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL
Thanks for the comments. I uninstalled mySQL, then I repeated the
unzipping operation, and then - as before - I installed mySQL into my C
partition. (I am using Win2000 with one fairly small primary partition
(C, FAT16, and two logical partitions.) I then tried to compile the
following
-
Hi,
I have already posted this query 4-5 days ago but no
reply yet so posting 2nd time.
Here is the query.
Application Used: Visual Basic 6
Database: MySQL 4.0.2
ODBC: MyODBC 3.51.03
I have create a table which has BLOB field in which i
want to save a bitmap file.
To save
Hi all,
hi all,
I want to create an one to one relationship among
tables using SQL. How can i do this. I creates an
relation but it dose not expect my needs. For Ex they
are two table say tbset nad tb tbprocess. If i set an
one to one relation between the two tables in which
the master table is
data chunk below.
Description:
Bug in SQL parser.
--BEGIN CUT--
eNotjs0KgkAYRfc9xV20itBxzMqhHyImCoxIA9eJX41hOY1m9YI+Vz+4u+dwFre7SQXKe66PpiRj
5VliaaX7NRzL8cAZ4zYb2XwIZyxcJjwfOV19yJdGd5IY2LNOrN5IsxRPwpkqKDI0B4cLd9AWAZ2q
Hello all,
I was check up 4.0.3 (from the Development Source Tree), bug still exist.
Description:
aor I use replication circle (A-B, B-A) with 3.23.51 - all ok.
aor But I got problem, when upgrade both my servers to 4.0.2.
aor Mysqld create 30 new bin-log files every
MySQL
Hi, I would like to change the name of one column of
a
table.
I did:
ALTER TABLE name_table ALTER COLUMN old_column
RENAME
new_column
but it did not work due to don't understand a RENAME
after ALTER COLUMN.
Could someone help me?
Thanks a lot.
Hello !
Is there anyway to convert CDS-ISIS data into MySQL?
Looking forward to hearing from you.
Regards,
DT
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
mysql 3.23.51, mysql max 3.23.51, and mysql max 4.02 crash on HP NetServer LH 6000 U3
under
SUSE Linux Enterprise/Email Server 3.1 at startup directly after installation and first
startup
Error Log File:
020814 10:11:00 mysqld started
mysqld got signal 11;
This could be because you hit a bug.
Hi All,
SciBit is happy to announce the release of Mascon for Linux 0.02, a port of the
popular Mascon for Windows to the Linux (I386) platform.
For those interested, further information, download and installation instructions
available from:
Hi,
all settings in my.cnf:
max_connections = 512
max_connect_errors = 1
join_buffer = 524288
record_buffer =1M
sort_buffer = 8M
tmp_table_size = 24M
key_buffer = 128M
max_allowed_packet = 1M
thread_stack = 128k
wait_timeout = 60
table_cache = 512
But i think sort_buffer etc. are free´d
Hi,
If you have 512 simultaneous connection MySQL could eat up to 128 + (8 + 1)
* 512 = 4736 MB of memory
What is your max_used_connections (displayed with SHOW STATUS;) ?
Regards,
Jocelyn
- Original Message -
From: [EMAIL PROTECTED]
To: ThomasSeifert [EMAIL PROTECTED]
Cc: [EMAIL
Hi all,
Have built mysql (mysql-3.23.49.tar.gz)
--prefix=/usr/local/mysql --with-named-z-libs=no --with-low-memory --enable
-assembler
on a new Solaris machine that we have (v 2.8, patched to June 8_Reccomended
patch level).
The configure, make and install seemed to go ok and were
Hi all,
Tho this is a Visual C++ Group i hope that i will get
the result for my quesion with lot of hopes.
I want to create an one to one relationship among
tables using SQL. How can i do this. I creates an
relation but it dose not expect my needs. For Ex they
are two table say tbset nad tb
Keith,
Tuesday, August 13, 2002, 12:20:28 AM, you wrote:
KJ Is this command supported under version 3.23.51?
Nope. This command is supported since 4.0
KJ SHOW NEW MASTER FOR SLAVE WITH MASTER_LOG_FILE='logfile' AND
KJ MASTER_LOG_POS=pos AND MASTER_LOG_SEQ=log_seq AND
KJ
javier,
Wednesday, August 14, 2002, 12:51:10 PM, you wrote:
Hi, I would like to change the name of one column of
a
table.
I did:
ALTER TABLE name_table ALTER COLUMN old_column
RENAME
new_column
but it did not work due to don't understand a RENAME
after ALTER COLUMN.
Could someone
Aron,
Tuesday, August 13, 2002, 4:58:40 PM, you wrote:
AP Sorry, but I can't seem to locate the page that addresses this question
AP specifically -- so, what version is scheduled to support views?
Views will come around v5.1
--
For technical support contracts, goto
Balaji,
Wednesday, August 14, 2002, 12:15:14 PM, you wrote:
BN I want to create an one to one relationship among
BN tables using SQL. How can i do this. I creates an
BN relation but it dose not expect my needs. For Ex they
BN are two table say tbset nad tb tbprocess. If i set an
BN one to one
l,
I want to create an one to one relationship among
tables using SQL. How can i do this. I creates an
relation but it dose not expect my needs. For Ex they
are two table say tbset nad tb tbprocess. If i set an
one to one relation between the two tables in which
the master table is tbset.
Mike,
Wednesday, August 14, 2002, 1:09:40 AM, you wrote:
MH I am working on a front end to my database, but I am running into a bit of
MH trouble. I have a user who has the proper privileges and grant option create
MH other users, but I need to know this: can that user delete users he has
MH
I highly recommend you update the slave to the same version as the master.
Mark D. Wallace wrote:
I'm trying to set up a replication database and cannot get the slave
to parse the log files on the master.
The slave is connecting to the master as indicated in the log file.
I have tried to
- Original Message -
From: Patrick Sherrill [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 14, 2002 9:22 AM
Subject: MySQL Source Dist.
I know I must be having brain gas, but where are the MySQL source
distributions currently?
Pat...
Send the set autocommit=0 just as you send any other query in perl.
Bob Boden wrote:
Attempts to disable auto-commit mode in Perl using the DBI command
$dbh-{AutoCommit} = 0; returns the following message, Transactions not
supported by database.
I am using the latest version of MySQL-Max
I am running a website which generates around 100,000 pageviews a day and I
am wondering if I stop using persistent conections to the MySQL database and
use
normal open and close conections this would reduce the load onto my server?
Most conections are either made through my main file or the
Patrick,
Wednesday, August 14, 2002, 4:27:58 PM, you wrote:
PS I know I must be having brain gas, but where are the MySQL source
PS distributions currently?
On the MySQL web site, of course:
http://www.mysql.com/downloads/index.html
--
For technical support contracts, goto
Look again.
/usr/local/mysql is owned by root.
Mark Gillett wrote:
Hi all,
Have built mysql (mysql-3.23.49.tar.gz)
--prefix=/usr/local/mysql --with-named-z-libs=no --with-low-memory --enable
-assembler
on a new Solaris machine that we have (v 2.8, patched to June 8_Reccomended
patch
it will reduce the load for sure!
MySQL is very fast in opening and closing connections at least if the database-server
and webserver are on the same machine.
I don't know how it will perform on different machines.
Thomas
On Wed, 14 Aug 2002 14:40:31 +0100
John Wards [EMAIL PROTECTED] wrote:
I have read somewhere that persistent connections in MySQL have a default
timeout of 8 hours. How would I reduce this?
Cheers
John Wards
SportNetwork.net
-
Before posting, please check:
http://www.mysql.com/manual.php
I saw in the MySQL documentation that the myISAM tables maximal size was 8
millions TB. But I couldn't find any information about the maximum number of
tables it can support. Can you give me this information ?
Thanks a lot !
-
jan,
Tuesday, August 13, 2002, 12:34:23 PM, you wrote:
jb Hello i got a problem with mysqldump,
jb i'm forced to dump it to to place the database on a new laptop
jb mysql -u root -p hardwaredb hardwaredbbackup.sql
jb Enter password:
jb ERROR 1065 at line 25: Query was empty
jb and the
I had the same problem.
It occurs when you try to load (3.23.51 or higher) dump file to lower
version of MySQL.
Look at this line...
/*!4 ALTER TABLE mobile_dev DISABLE KEYS */;
As soon as version is not equal 4 everything in comments will be
deleted.
So we have
;
empty query.
On Wednesday 14 August 2002 09:54 am, Thomas Seifert wrote:
I disagree entirely
Persistent connections have little or nothing to do with increasing load!
Given that you mention you are using PHP I'll assume you have mod_php running
in Apache. Each Apache child process in this
Hello,
I need to make search in mysql with accent sensitive request.
It seems that my MySQL server (3.23.41) request are accent insensitive.
Is there an option to make mysql accent sensitive.
When I launch SELECT * FROM table where name LIKE 'José';
I just want José in the answer and not Jose !
On Wednesday 14 August 2002 07:03 am, Balaji Nallathambi wrote:
I think you're expectation is simply wrong.
In MySQL recent versions if you use InnoDB tables you can create a 'foreign
key' constraint. All this means is that you cannot create a record in a
dependent table where the same value
I've run into a weird problem. If I try to insert this value, 78978978,
into a FLOAT(9,2) column, the value changes. See below.
System info:
MySQL-shared-3.23.51-1
MySQL-client-3.23.51-1
MySQL-devel-3.23.51-1
MySQL-Max-3.23.51-1
MySQL-3.23.51-1
Red Hat Linux release 7.3 (Valhalla)
#Wrong
* Jean-Pierre Georgin
I saw in the MySQL documentation that the myISAM tables maximal size was 8
millions TB. But I couldn't find any information about the
maximum number of tables it can support. Can you give me this information
?
There is no limit in mysql, but there may be one in the OS
On Tuesday 13 August 2002 06:50 pm, Steinar Kolnes wrote:
Just create indexes on first and last, that should improve the speed of your
query drastically. It will of course be a BIG index. You might experiment
with only making the width of the index small, like maybe 8 or 10 characters
might
On Wed, 14 Aug 2002, Jean-Pierre Georgin wrote:
I saw in the MySQL documentation that the myISAM tables maximal size was 8
millions TB. But I couldn't find any information about the maximum number of
tables it can support. Can you give me this information ?
Bonjour Jean-Pierre,
each MyISAM
walt wrote:
I've run into a weird problem. If I try to insert this value, 78978978,
into a FLOAT(9,2) column, the value changes. See below.
System info:
MySQL-shared-3.23.51-1
MySQL-client-3.23.51-1
MySQL-devel-3.23.51-1
MySQL-Max-3.23.51-1
MySQL-3.23.51-1
Red Hat Linux release 7.3
Wednesday, August 14, 2002, 5:53:22 PM, Eduardo wrote:
ES Helo,
Hi!
Eduardo, first of all, don't send me questions. Please, send them to
the mailing list.
ES How do I verify if a table already exist on my database ?
ES In Oracle there is an
SQL QUERY SQL QUERY
I inserted a row , and set the sales to 0 for the years that there is none ,
and set the sales to the sales amount for th years
that there were some
INSERT INTO TempSap
(taxid,Company,FirstYear,SecondYear,ThirdYear,ThruDate,WritingAgentID,GroupI
D,
On Wed, 14 Aug 2002, Ludovic GENOT wrote:
I need to make search in mysql with accent sensitive request.
It seems that my MySQL server (3.23.41) request are accent insensitive.
Is there an option to make mysql accent sensitive.
When I launch SELECT * FROM table where name LIKE 'José';
I
Hi,
The best way to speed up your query would be to create a compound index
on (first,last):
create index first_last on subscriber(first,last);
In this case, mysql will use it for both fields instead of doing a
linear search for the second one.
In order to reduce index size without
Group,
I have to move my work from Mysql to Postgres ( political decision ) - Need
any and all recommendations for books on advanced SQL. Mysql is a holds a
lot less to the standard than
postgres - or so it seems and I need to look more at standard SQL for some
of the things that
I am doing.
Selon Thomas Spahni [EMAIL PROTECTED]:
what is your character set in use? (do: mysqladmin variables | less)
I assume you have latin1.
Yes, you're right, my mysql server uses latin1.
sql/share/charsets/latin1.conf maps character E8 (=é) to 45 (=E) in the
sort_order array. This is not only
That is really odd, because I don't see a select statement anywhere.
Mary Stickney wrote:
SQL QUERY SQL QUERY
I inserted a row , and set the sales to 0 for the years that there is none ,
and set the sales to the sales amount for th years
that there were some
INSERT INTO TempSap
Let us know how your support issues are addressed when you have your
first problem.
Mine were never even acknowledged on the postgresql group.
That was the reason I went with MySQL. I have never regretted it.
Norris, Joseph wrote:
Group,
I have to move my work from Mysql to Postgres (
here is is ...
'check to see if agent/dist code are already in temp table
sSql = SELECT * _
FROM TempSap _
WHERE ProducerID=' FixSQLString(
rs3!WritingAgentID) ' _
Hi All (Gerald),
Not sure why that should make a difference as the daemon is trying (it
claims) to write to /usr/local/mysql/var.
Have updated the privs :
from ls -al /usr/local/mysql/var
total 32
drw-rw-rw- 4 mysqlmysql512 Aug 14 11:27 .
drwxr-xr-x 12 mysqlmysql512
We are in Agreement on this point Gerald. I would prefer Mysql to
Postgresql. The problem is that the shop where I work had a major Oracle
system - full of triggers and functions (Oracle $$$ - Yuck!). So the
decision was made to move to Postgresql. The systems that I developed have
been based
I am preparing to do something similar, so I read your post with interest.
I think that the excel cells that only contain alpha characters will have to
have quote marks added in excel. I am thinking of writing a macro to check
my string columns and add quotes if necessary. The resulting csv
I am preparing to do something similar, so I read your post with interest.
I think that the excel cells that only contain alpha characters will have to
have quote marks added in excel. I am thinking of writing a macro to check
my string columns and add quotes if necessary. The resulting csv
Having done some further work (I re-built using 3.23.51) I have managed to
have the server startup and run, however I am still experiencing the :
020814 15:25:48 /usr/local/mysql-3.23.51/libexec/mysqld: Can't create/write
to file '/usr/local/mysql-3.23.51/var/host.domain.pid' (Errcode: 13)
At 11:14 -0400 8/14/02, Tod Harter wrote:
On Wednesday 14 August 2002 09:54 am, Thomas Seifert wrote:
I disagree entirely
Persistent connections have little or nothing to do with increasing load!
Given that you mention you are using PHP I'll assume you have mod_php running
in Apache. Each
Dear MySQL company,
How can I transfer datas from Microsoft Access database to MySQL database?
And also if you could please answer how can I transfer datas from Microsoft
Access database to SQL database.
Best regards.
Hasan
_
Hi,
The solution for this problem is to decrease the wait_timeout variable to
something more reasonable than 28800 seconds.
If you have a very loaded server, I thing a wait_timeout of 60s is great (in
my case).
However I hardly understand why in some cases mysql seems to be no able to
reused
Sabdy Serrano wrote:
I have installed in Linux Red Hat the server of MysQL, and I have the user
management WEBMIN.
From a PC with Windows'98 and OOo 1.0.1 (F4) I connect (ODBC) to the server
MySQL (Linux), and I can create my databases , but when I want to modify a field
or record, it
I'm trying to enforce one column of my table to contain strictly 6 chars.
string. However I've some columns of type VARCHAR (e.g name, etc.) so
mysql silently changes the column to VARCHAR.
Is there any way I can force the column to contain only 6 chars.
Thanks,
-Pushkar S. Pradhan
Hello,
My name is Sumeet Chahal and I work for Usability Sciences in Dallas, TX.
We will be conducting industry research for a large data modeling software
company. The results of this study will be used for product development and
marketing purposes. We are looking for people to participate
I am encountering some strange behavior with the results returned from a
query on a table in MySQL. The query is:
select
t.lu_cn as cn,
sum(if(strcmp(t.work_item_type, 'OPERATIONS'),
t.reference_dollars_labor +
t.reference_dollars_equip +
Heh.. Only $150?? At the most.. Its $75/hour and is hardly what I call
resonable compensation as my clients pay more than that for database
services.
:P
But good luck in any event.
Daniel Gormley
Internet Developer
Cyberbasin Internet Services
And I disagree with this view.
If you've got a server with 512 MB RAM and running the webserver and the
db-server on the same machine, 100 idling mysql-processes are a HUGE overhead.
At most if not every http-request requires a mysql-connection.
I did many benchmarks and I got a huge decrease
Hey,
I have four servers here, all identical when it comes to the hardware as
well as software (same installed packages).
Two of the servers run absolutely beautifully, not a single problem, but
the other two are plagues by insane load as soon as they start receiving
traffic.
The machines are
Thomas,
1. Yes different servers for webserver and database
is the key. They have competing priorities.
2. The 100kb estimate is db-dependent, no?
P.
And I disagree with this view.
If you've got a server with 512 MB RAM and running the webserver and the
db-server on the
It's why I think it's a good idea to lower the wait_timeout parameter, but
to still keep the pconnect.
(my server handle 1M pageviews/day (webserver and database))
Jocelyn
- Original Message -
From: Thomas Seifert [EMAIL PROTECTED]
To: Tod Harter [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
I am wondering if this will help me any, I currently serve 800K+ pageviews
all requesting mysql connections. 120 Queries Per Second. I'm wondering if
persistant connection will help me, and how I could go about it, if there is
40 different pages all using the same db/tables. I'm kinda new to
Hasan,
The only way I was able to do this was by creating a database in MySQL with
the tables set up the same way as those in Access, exporting each table in
Access to a separate CSV file, and then using LOAD DATA INFILE ... to
import the data from the CSV files into the tables. Good luck.
My own server handle more than 200 queries per second (up to 800 queries per
second), and I use pconnect with a wait_timeout of 20 s only.
With a low wait_timeout number and a high number of queries per second I
think I have both the advantages of connect and pconnect (not too many IDLE
threads,
Is there a tool out there for Windows that will let me monitor how many
connections to my MySQL database are currently open at any given moment?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Description:
HAVING Max(x) IS NULL always TRUE.
This has changed since 3.23.39, when if the x column had all Nulls,
Max(x) IS NULL was TRUE and FALSE otherwise.
How-To-Repeat:
CREATE TABLE test1 (
ID int unsigned auto_increment not null primary
sql,query
Hi,
Few days ago ,was someone(i try out to find in my e-mail list ...but i
didn't find him) which was wish to calculate some fields using variables
I don't know if this person it's solved his problem but today i meet a
similarly situation and i solved in the next way :
TABLE
Hi,
- Original Message -
From: Thomas Seifert [EMAIL PROTECTED]
To: Tod Harter [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, August 14, 2002 10:19 PM
Subject: Re: Persisten Connections
And I disagree with this view.
If you've got a server with 512 MB RAM and running the
I just noticed that creations and deletions of temporary tables are
recorded in the MySQL binary log. My question is: during replication,
are these transmitted and replayed on the slave servers? If so, could
someone explain to me why? This would seem to be useless, since the
temporary tables
At 16:33 -0400 8/14/02, Michael McClennen wrote:
I just noticed that creations and deletions of temporary tables are
recorded in the MySQL binary log. My question is: during replication,
are these transmitted and replayed on the slave servers? If so, could
someone explain to me why? This would
On 14 Aug 2002, at 13:31, Sean C. Burbidge wrote:
The query is: select t.lu_cn as cn,
sum(if(strcmp(t.work_item_type, 'OPERATIONS'),
t.reference_dollars_labor +
t.reference_dollars_equip +
t.reference_dollars_travel +
t.reference_dollars_matl +
My Linux installation only has about 1gb in the /var
partition, so I need to relocate my databases to the
/home partition. I'm pretty sure the following
commands will shutdown mysql, move the data directory,
create a symbolic link, and then restart mysql. My
question is, is this complete, or do I
I'm having trouble with a vbulletin database running mysql as the back end.
It's running on linux server. Basically we had some weird problems and was
hoping someone else has seen this. First the boards went down because
somehow all the permissions on the table files in
Ok Im still having some serious speed problems and obviously since more
records are being added every day the problem is getting worse. Here is the
query:
SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
Comp, Jobs.JobID, Employers.EmpID
FROM Employers
INNER JOIN
On 14 Aug 2002, at 14:09, Richard Baskett wrote:
SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
Comp, Jobs.JobID, Employers.EmpID
FROM Employers
INNER JOIN Jobs ON Employers.EmpID = Jobs.EmpID
INNER JOIN JobsLocation ON Jobs.JobID = JobsLocation.JobID
INNER
Ok that saved me 5 seconds per query! So far so good! I couldn¹t use the
STRAIGHT_JOIN though (received errors) so I made it an INNER JOIN. This is
the new query:
SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
Comp, Jobs.JobID, Employers.EmpID
FROM Location
INNER
sql,query
Hello,
This might be off the topic, but I thought I'd ask in case anybody has an
answer. I downloaded the latest version of FreeMascon, but when I run the
installer, a Command prompt window opens and closes and then nothing
happens. Has anyone else installed FreeMascon on Win2K
Hi there,
I posted this a few days ago and recieved no responses, so I thought I would
post it again:
Hi All;
I am working on a front end to my database, but I am running into a bit of
trouble. I have a user who has the proper privileges and grant option create
other users, but I need to know
what version of mysql are you running? I was having similar problem then I
upgraded my mysql to 3.23.51 and the problem was solved.
Richard Baskett wrote:
Ok Im still having some serious speed problems and obviously since more
records are being added every day the problem is getting worse.
I am using 3.23.51 also
Dost thou love life? Then do not squander time; for that's the stuff life
is made of. - Ben Franklin
From: Rahadul Kabir [EMAIL PROTECTED]
what version of mysql are you running? I was having similar problem then I
upgraded my mysql to 3.23.51 and the problem was
On 14 Aug 2002, at 14:46, Richard Baskett wrote:
Ok that saved me 5 seconds per query! So far so good! I couldn¹t use the
STRAIGHT_JOIN though (received errors) so I made it an INNER JOIN. This is
the new query:
You say the EXPLAIN output looks the same, so the 5 second savings is
just
I am using DBD-mysql-2.1018 with a binary mysql_3.23.51 on Solaris 2.8.
I can get thru Makefile.PL and make without errors or warnings. However I
always get the same errors returned during make tests regardless of my
command line parameters.
Below is the Makefile.PL params that I used last
If you were here right now I would kiss you! Well not really, but I can not
believe what that did!! It takes around 2-4 seconds now for the query to
execute completely! I wish I understood when to use what type of join since
it is very obvious to me that it matters, and matters greatly! Thank
I wrote:
SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
Comp, Jobs.JobID, Employers.EmpID
FROM Location
INNER JOIN JobsLocation ON JobsLocation.LocID = Location.LocID
INNER JOIN Jobs ON Jobs.JobID = JobsLocation.JobID
INNER JOIN Employers ON Employers.EmpID =
Hi
To help improve the performance, it would help knowing
- table structures, use show create table name;
- how many records in each table
- have all the tables being analyzed/optimized recently
Inner joins whilst very useful, do impact on performance. In some cases
it is more efficient to
For an example let's say that I have clients in multiple countries and I
want a list of the number of clients per country. In order to do this I
would think a statment like:
select country, count(*) clients from addresses group by country
would work just fine. I have have been working in VB on
I am creating a VB6 application and using option = 1 in my connect
string to obtain the defined size for each column. This option does not
return the define size of VARCHAR columns but the current Maximum Value
in the Field. Any attemp to update a field with a string longer than
the
What is the purpose of creating the symlink if I
manually edit the data directory variable? Would it be
better to:
a) Move the data, and edit the data directory to the
new location
b) Move the data, and create a symlink to the new data
TIA,
--- Rahadul Kabir [EMAIL PROTECTED] wrote:
seaport:/# mysqladmin -h `hostname` version variables
mysqladmin: connect to server at 'seaporthost.com' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
What does this mean?
Dave
-
Before
Hi.
On Wed 2002-08-14 at 15:06:02 -0700, [EMAIL PROTECTED] wrote:
If you were here right now I would kiss you! Well not really, but I can not
believe what that did!! It takes around 2-4 seconds now for the query to
execute completely! I wish I understood when to use what type of join since
Is there a way to combine these queries?
SELECT count(SeekID) FROM Seekers
WHERE DateLastLogNOW() AND DateLastLog(NOW()-INTERVAL 7 DAY)
SELECT count(SeekID) FROM Seekers
WHERE DateLastLogNOW() AND DateLastLog(NOW()-INTERVAL 1 MONTH)
Or these?
SELECT count(ResumeID) FROM Resumes WHERE
Subject: Re: [cobalt-users] glibc download
Date: Tue, 13 Aug 2002 11:26:57 -0700
From: Brian Quinn [EMAIL PROTECTED]
To: Rahadul Kabir [EMAIL PROTECTED]
Yeah i installed the new glib and still can't get it to work.
I got PHP4 to work fine after upgrading, but not mySQL
I always see people with
it means access denied. either cos you dont have permissions in your mysql
privilege table or your password is wrong. did you supply a valid username
and password in the command string?
- Original Message -
From: Dave Reinhardt [EMAIL PROTECTED]
To: MySql Support [EMAIL PROTECTED]
Sent:
1 - 100 of 111 matches
Mail list logo