hello,
i got a really long text to put in mysql
n when i use longtext field, it isnt enuff
Can u help me pls ??
thx in advance
feroze
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
I'm fairly certain now() runs off system time...so you can adjust your system
time on the server to reflect your time zone...
if thats not possibly, or not wanted, in place of now, you can use..
DATE_SUB(NOW(), INTERVAL 2 HOUR)
cheers!
On January 7, 2002 11:53 pm, Kevin Campbell wrote:
>
Hi All.
Has anybody from the MySQL source distribution successfully build a working MySQL ?
I have done it using Compaq's C and C++ compiler - But I would like to have build
instructions when using GNU C.
Regards and thanks,
Karsten Elgaard Sørensen
Compaq Computer ApS
Denmark
Rezal writes:
> hello,
> i got a really long text to put in mysql
> n when i use longtext field, it isnt enuff
>
> Can u help me pls ??
>
> thx in advance
I'll do my best to decipher your message... you have something
that's bigger than the maximum size of a LONGTEXT and you want
to put in in
Heikki Tuuri wrote:
>
> Hi!
>
> Are you running mysqld under the safe_mysqld script, which automatically
> restarts mysqld after a crash?
>
Yes, mysqld started with safe_mysqld script
> If yes, look at the 'hostname'.err file and send its contents to me.
Nothing happens in the hostname.err
* matt
> I was wondering how I would insert a value which is present in another
> table, specifically, this is a member_id field from a main members table
> which acts as a foreign key in this table (Although I know this not
> truly possible in MySQL). I think this attempted, although non
> functi
Bernard Chambon wrote:
> 020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more
>than
1024
Bernard:
How come you're not giving your OS more file descriptors?
ulimit problem, perhaps.
Van
database,sql,query,table
--
Brian Snopek writes:
> I'm fairly certain now() runs off system time...so you can adjust your system
> time on the server to reflect your time zone...
The computer should know what timezone it's in. You can unset TZ
before running safe_mysqld to get MySQL to run on UTC, but that is
a kludge, r
Ok.
Bring down server:
Find the process by useing ps command.
Then use the kill command and then send a TERM signal to the server to see
if it will respond by shutting down normally.
Check tables using myisamchk and isamchk.
Restart server with --skip-grant-tables option.
Set new root p
I was reading about adding/managing users.
I understand hat the user table holds user information.
the example I will give is taken from the oreilly book.
insert into user (host, user, password, select_priv, insert_priv,
update_priv, delete_priv)
values ('%', 'bob', password('mypass'), 'Y',
1.) the % IS a wildcard and the user bob CAN connect from any host.
2.) the string 'mypass' will be inserted into the table. but the user bob
can not logon because he doesnot know the unencrypted password of 'mypass'.
--
Zu Zhihui <[EMAIL PROTECTED]>
- Original Message -
From: "Matthew
Hi
If you have a new copy of MySQL use GRANT.
If you have an old copy update it.
If you can not do this then
Yes % is a wild card. Yes bob can use any host at "user" table is global.
Yes you can use clear text passwords.
Hope this helps.
Simon
PS I like using "desc tablename"
PPS Get the ne
>Description:
Using "set character set cp1251_koi8" before updates insert right
data on master server (cp1251 from client recode to koi8 on server),
but replication on slave server wrong (data dosn't recode from
cp1251 to koi8).
>How-To-Repeat:
Setup replica
Hi,
I prefer to used load data infile command to insert text file (CSV format)
to MySQL. I wonder that Could load data use with pure text file (no
delimiter)? if not how to insert text file in to MySQL faster than read
every line?
SF
-
thanks for your help on this,
I would like to use the grant sql command as I am using the latest version 3
of mysql, however I am find problems finding good usage guide for grants. I
will update the oreilly mysql book. I need to do this with my bind and
apache book too.
Matt.
-Original Mes
I have a flat text file that is about 820mb I need to import into a database
that has the dates in the format MM-DD-. MySQL requires dates with the
year first and when I try importing test chunks of the data all I get is
zero's in the date field because of the dates being in the wrong format.
Hi!
Then it looks like a problem in the communication or in your client test
program.
The following error
> Commands out of sync; You can't run this command now (85 occurences)
means that you have issued C API commands to a single MySQL connection in a
wrong order.
If your application has s
Hello
Im using OleDB from my ASP pages and I have a problem with queries with count(*) and
group by statement. I had the same problem with ODBC but i Solved it by setting the
"Change BigInt to Int" and the "Return all rows" option. Now I changed to OleDB for
better speed but I don't know
how t
Hi!
I have a most peculiar problem with a corrupt table.
My situation:
I have a mysql server running with several databases, one of them a log
database that only have one table with several attributes. I have lots
of inserts into this table which grows continuously, now the table size
is about 4
Dear mysql,
Join today for FREE and a chance to win a $100 Shopping Spree at The DHS Club Outlet
Center!
A FREE membership in the DHS Club means saving money on everything you buy at The
ClubShop Mall Affiliate Stores because you receive REBATES on ALL your purchases! FREE
Members also save u
Hi,
Is there any MySQL equivalent command for the Oracle 'prompt' command (which
writes out some text).
Thanks in advance,
-- Sebastien Guillemin
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
Bill Kurland writes:
> Thanks for the reply.
>
> gcc and g++ are both version 2.95.3
>
> I've tried installing three different binaries, one from the mysql site
> and
> two different versions from the Bull site. All failed with different
> problems
> on this machine so I tired them all on a di
Johan Wahlström writes:
> Hello Everyone!
> This happens when i try to compile with gcc 3.1 (redhat) on my redhat 7.2
> installation. (yes i have upgraded to 3.1 from the
> "default" 2.96 version). I get the same result with 3.0.1 also from Redhat.
>
> any ideas ?
>
> regards, Johan
>
Just cha
Johan Wahlström writes:
> Hello Everyone!
> This happens when i try to compile with gcc 3.1 (redhat) on my redhat 7.2
> installation. (yes i have upgraded to 3.1 from the
> "default" 2.96 version). I get the same result with 3.0.1 also from Redhat.
>
> any ideas ?
>
> regards, Johan
>
Just cha
Hi,
I think that adding .;Extended Properties="OPTION=16400" to your ADO
connection string should do the trick.
Cheers,
Bruce
-Original Message-
From: Mattias Persson [mailto:[EMAIL PROTECTED]]
Sent: 08 January 2002 13:29
To: [EMAIL PROTECTED]
Subject: OleDB
Hello
Im using OleDB
Hi,
My table has 3 columns: id, name, timestamp.
When I use the MySQL command line client,
(a) insert into table values(1,'xxx') fails for insufficient number of
values.
(b) insert into table values(1,'xxx',null) succeeds.
1. The MySQL manual states that "The column is not speci
http://www.essencomp.com/unsubscribe.asp"; method=post>
http://www.essencomp.com/images/image1.jpg";
border=0>
Hi!
> "aravindgorthy" == aravindgorthy writes:
aravindgorthy> Hai
aravindgorthy> While setting up the replication environment i am
aravindgorthy> getting the following error in the master ..what might
aravindgorthy> be the problem
aravindgorthy> 020108 13:20:00 Slave thread: error conne
jds writes:
> hi!
>
> i'm running 3.23.47 w/ mysql gui1.7.5-2 on win2k
>
> to config innodb, i edited the my.ini (with some help from heikki...thanks!)
>
> and learned on win my.cnf and my.ini cannot co-exist.
>
> now i'm ready to install mysqlgui to set up my admin, users, etc...
>
> my ques
* Osnat Rabi
> My table has 3 columns: id, name, timestamp.
>
> When I use the MySQL command line client,
> (a) insert into table values(1,'xxx') fails for
> insufficient number of values.
I don't know if this will help you, but this is valid:
insert into table set id=1, name='xxx';
-
Matthew Darcy writes:
>
> Hi,
>
> my laptop is running windows 2000 and is called jaguar.
> I have mysql running on a linux server called jordan.
>
> when I fire up mysqlui and tell it to connec to jordan as root I get
> prompted for a password. I enter the password (that I have tested and is
>
[EMAIL PROTECTED] writes:
>
I'm getting seriously sick of the amount of spam on this list.
I don't know what MySQL employee is responsible for managing
this list, but assuming that there is such a person, could
he/she _please_ do something about the problem? When every
other list owner can fig
EDA Peach writes:
> Hi Gerald,
>
> Sorry ... the OS is Solaris 7, running on a Sun Ultra
> Sparc 5. I downloaded the Sun Solaris 2.7 Sparc
> static binary of MySQLGUI 1.6
> (mysqlgui-solaris-2.7-sparc-static-1.6.gz). I
> gunzipped the file and attempted to execute it and got
> this error messag
We run MySql on our Freebsd server, and on our Win2K server.
We have several clients, and would like to store the databases in the
clients' root directory. Is this possible?
Thanks!
-
Before posting, please check:
http://w
I prefer
'MySQL' by Michael Kofler (Apres ISBN 1893115577)
D Bamud wrote:
>
> Which is the **best, easy, compact** book available on MySQL. Delhi India.
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.
>From show status (in mysql 4.0.1)
| Com_select | 192446|
| Questions| 121881|
Why are there more selects than the total number of questions? Is
that correct?
There are of course Insert, deletes and other Com_ variables as well.
I can provide the whole list
There are two things you can do when running MySQL for other people.
One: Use GRANT and let every one know about but not see each others
databases.
Two: Run more than one copy of MySQL on your sever...this also means that
they can be set up for each persons needs
Hope this helps...
Simon
--
Rezal wrote:
> hello,
> i got a really long text to put in mysql
> n when i use longtext field, it isnt enuff
>
> Can u help me pls ??
>
> thx in advance
> feroze
Sheesh! Over 4 GB in a single row? That doesn't make much sense.
Why not store the text in a file on the filesystem instead?
And jus
Bonjour,
Any idea ?
I will try to make the server crash one more time and tell you if I
find the query.
Regards,
Alex.
020108 9:43:58 InnoDB: Started
/opt/mysql/libexec/mysqld: ready for connections
InnoDB: Error: undo->id is 2860816
InnoDB: Assertion failure in thread 54 in file
Thanks - but my real question is where is this data stored on my system? Do I have
control to locate the databases for each client in different locations?
Mike
Simon Green wrote:
> There are two things you can do when running MySQL for other people.
> One: Use GRANT and let every one know abo
Reported to SpamCop.net
At 15:54 2002-01-08, Carl Troein [EMAIL PROTECTED] [RegSoft/mysql] wrote:
>[EMAIL PROTECTED] writes:
>
>>
>
>I'm getting seriously sick of the amount of spam on this list.
>I don't know what MySQL employee is responsible for managing
>this list, but assuming that there i
Each time that I reboot and logon to my windows 98 server, WinMySQLAdmin
starts and
then starts mysqld. I do not want this behavior (acting like a service).
What do I need to do to prevent this, including uninstalling WinMySQLAdmin,
which I have
not figured out how to do? When I remove my.ini f
Just take the shortcut out of the startup menu
-Original Message-
From: Dan Jordan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 10:04 AM
To: [EMAIL PROTECTED]
Subject: Prevent WinMySQLAdmin from auto startup when windows 98 reboots
Each time that I reboot and logon to my w
I'm having difficulty handling data and time with access. I'm using the ODBC
driver from the MySQL site to link the tables, and I can view and manipulate
the data. the problem comes when I save a time, it is displayed incorrectly
in access. Is this a known problem? If so, how do I work around this
Hello all. I have a database which is around 10million rows. The
structure is as follows:
id int(11) NOT NULL- Auto Increment
address char(90) NOT NULL
status char(2) NOT NULL
country char(2)
state char(2)
areacode char(3)
...about 40 char(1) fields.
I have an unique index on address,
Alex,
looks like a memory overwrite. A trx undo log object contains a random
field.
Did you do anything special with the database when this happened?
Regards,
Heikki
Innobase Oy
.
Bonjour,
Any idea ?
I will try to make the server crash one more time and tell you if
Can I have different instances of winmysqladmin start instanciating
different mysql's? i want to run one for the stable version, and one for
mysql 4.0
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
Correction on the query: SELECT count(*) as count FROM userdata WHERE
status = 'A';
Sorry.
-Original Message-
From: Greer, Darren (MED)
Sent: Tuesday, January 08, 2002 10:20 AM
To: '[EMAIL PROTECTED]'
Subject: General Query time question
Hello all. I have a database which is around 1
Greer, Darren (MED) writes:
> Correction on the query: SELECT count(*) as count FR
OM userdata WHERE
> status = 'A';
Ah. That does make a difference. MySQL is of course
forced to go through all of your data, counting the
number of rows with status 'A'. I don't believe an
index would do you much
Personnaly I found no particular spam on this list, in the beginning of the
year I found article dated to the 01/01/2003 and not the 01/01/2002, this
message was refused cause it doens t contain
words like sql
I thinks that my mail client wich doesn work well (hum outlook).
a+.
---
You are correct, they are simple Y/N fields. I am not familiar with the
process you mentioned, but will do some digging. If you have any
information you could give me that doesn't require too much of your
time, I would appreciate it.
Thanks,
Darren
-Original Message-
From: Bogdan Stan
Hi,
Would like to know if there is a "preferred" way of setting up the data
directory for mySQL. The default for a database would be in C:\mysql\data.
Is this the preferred way or should this be set up in another directory
outside of the mysql directory? Does moving the data directory affec
Hi,
We are running MySQL version 3.23.43 on one of our servers and have some
stability
problems the occur about every 1-2 days. When it happens everythings keeps
working
but the load goes up to about 80. After stopping and restarting MySQL
everything
goes back to normal (load average about 0.5).
I didn't think/read far enough. One more attempt is due.
> > Correction on the query: SELECT count(*) as count FR
> OM userdata WHERE
> > status = 'A';
I didn't see that it was on that column you had an index,
so forget I said 'of course'. Have you used EXPLAIN to
figure out if the index is act
On Mon, Jan 07, 2002 at 10:43:57PM -0600, Jeff Williams wrote:
>
> We have been using LDAP for our user database for some years. We
> are now getting into MySQL, and I would like to be able to grant or
> deny access within MySQL based on LDAP user information, rather than
> having to maintain a s
#!/your/path/to/perl
open(OLD, "yourbigfile.txt");
open(FIXED, ">newfile");
while ($line = )
{
$line =~ s/(\d{2})-(\d{2})-(\d{4})/$3-$1-$2/g;
print FIXED $line;
}
Michael
On Tue, 8 Jan 2002, Jeremy Johnstone wrote:
>
> I have a flat text file that is about 820mb I need to import into a d
Hi all,
I'm doing some experimenting with debian, has anybody created any .deb
packages for MySQL?
TIA,
John
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Jean-Luc Fontaine writes:
> I would need those to finish the on-line help in my mystatus and myvars
> moodss modules for the 4.0.1 server.
> Please let me know if this is not the right place to post this.
>
[skip]
>
> I also take this opportunity to wish a very successful new year to the
> M
SELECT count(distinct ip) FROM pole_voti
It does'nt work. Why ?
PhpMyAdmin says: You have an error in your SQL syntax near 'distinct ip)
FROM pole_voti' at line 1
Why ?
Where is the error ?
Ilic.
-
Before posting, please c
is WinMySQLAdmin in your Windows START folder?
-Original Message-
From: Dan Jordan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 10:04 AM
To: [EMAIL PROTECTED]
Subject: Prevent WinMySQLAdmin from auto startup when windows 98 reboots
Each time that I reboot and logon to my w
Elgaard Sorensen, Karsten writes:
> Hi All.
>
> Has anybody from the MySQL source distribution successfully build a working MySQL ?
>
> I have done it using Compaq's C and C++ compiler - But I would like to have build
>instructions when using GNU C.
>
> Regards and thanks,
> Karsten Elgaard S
Dear Friends,
I am trying to develop an application with Kylix
ver.1, MySQL ver.11.15 distrib 3.23.41 for suse linux
(i686).
I am using MySQLConnection object to connect my MySQL
database server (and with so :
libmysqlclient.so.10.0.0). But I found some ridiculous
problem :
1. Have setup/determ
Hello Prabu,
Is it really nessesary to use proprietary Kylix environment (is it
using Pascal as a core language?) to write your application?
I'm not a specialist in Kylix but why don't you look into possibility
of using open source programming languages and editors?
For example, using just a plain
Roel Van den Bergh writes:
> After a long day of trying and reading all sorts of manuals and faqs and
> newsgroups
> I still can't create tables with the mySQLgui (1.7.5.2 windows) running in
> win 2000 pro standalone feature
>
> I can read the test database (empty of course)and the users dbase
>
Hi,
gcc and the libstdc++ are already loaded. libstdc++
is in /usr/local/lib should it be somewhere else?
Please advise. Thanks.
Regards, Mike
--- Sinisa Milivojevic <[EMAIL PROTECTED]> wrote:
> EDA Peach writes:
> > Hi Gerald,
> >
> > Sorry ... the OS is Solaris 7, running on a Sun
>
If I move the status to another table, and then wanted to get a count of
everyone who is of status 'A', how would that be any quicker? Would I
join the tables?
-Original Message-
From: Carl Troein [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 11:34 AM
To: [EMAIL PROTECTED]
Ken Menzel writes:
> >From show status (in mysql 4.0.1)
> | Com_select | 192446|
> | Questions| 121881|
>
> Why are there more selects than the total number of questions? Is
> that correct?
>
> There are of course Insert, deletes and other Com_ variables as
%% John Cichy <[EMAIL PROTECTED]> writes:
jc> I'm doing some experimenting with debian, has anybody created any .deb
jc> packages for MySQL?
Go to http://www.debian.org, on the left menu bar pick "Debian
Packages", then in the search box enter "mysql" (make sure the
distribution is set corr
Hi Back!
>
> Hi!
>
> This is a bug that we shall soon sort out ...
OK Great, just wanted to make sure you knew about it, or that find
out what I did not understand. (So which is the correct number?)
>
> You are evidently using our BK tree ...
Well, not on that one, that is 4.0.1-alpha from
I don't have MySQL on the computer I am on to test this but you might try
rewriting it this way:
select count(distinct(ip)) from pole_voit
Original Message Follows
From: Ilic <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: count(distinct
Date: Tue, 8 Jan 2002 18:47:43 +0100
SELEC
On Sun, Dec 16, 2001 at 09:49:29AM -0600, Philip Molter wrote:
> On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote:
> : On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote:
> : >
> : > So, could you give me some advice that if it is feasible ? Or show
> : > me your successful ca
Dennis Jacobfeuerborn writes:
> Hi,
>
> We are running MySQL version 3.23.43 on one of our servers and have some
> stability
> problems the occur about every 1-2 days. When it happens everythings keeps
> working
> but the load goes up to about 80. After stopping and restarting MySQL
> everything
EDA Peach writes:
> Hi,
>
> gcc and the libstdc++ are already loaded. libstdc++
> is in /usr/local/lib should it be somewhere else?
> Please advise. Thanks.
>
> Regards, Mike
>
It could be anywhere you like as long as that directory is in LD_LIBRARY_PATH.
--
Regards,
__ ___
Through the responses, links, and a little concern (and a really smart and
helpful web
Host, he did most of the hard stuff), I got MyODBC working like a charm.
Made up a file DSN and can use it in Visual C++, Visual Basic, and Access.
Also thanks to whomever put MyODBC out there...
database,sq
The syntax is: SELECT DISTINCT
http://www.mysql.com/doc/S/E/SELECT.html
Xi2
-Original Message-
From: Ilic [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 9:48 AM
To: [EMAIL PROTECTED]
Subject: count(distinct
SELECT count(distinct ip) FROM pole_voti
It does'nt work. Why ?
P
Hi Simon,
I appreicate your help.
Our server is a Solaris 5.6 server. After I cd to the mysql bin directory
bindir=/usr/local/bin and connect to mysql server by using mysql or mysqladmin, the
server shows me mysql not found and mysqladmin not found. Can you give my some clue?
You have much
At 09:04 08/01/2002 -0700, Dan Jordan wrote:
Hi!
Go to start Menu and remove the Icon of WinMySQLAdmin.
Regards,
Miguel
>Each time that I reboot and logon to my windows 98 server, WinMySQLAdmin
>starts and
>then starts mysqld. I do not want this behavior (acting like a service).
>
>What do I n
On Mon, Jan 07, 2002 at 11:36:54PM +0100, Marco Frazzoli wrote:
> Hi!
>
> I need to syncronize two indentical MySQL databases.
>
> The A database is on a server permanently connected to the Internet
> trough an ADSL connection, while the B database is on a server
> equipped with an ISDN connectio
from your bindir type:
./mysql
-Original Message-
From: Cindy Yu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 12:07 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: RE: RE: Mysql connection problem
Hi Simon,
I appreicate y
The server is not telling you that mysql is not found.
The shell is telling you that mysql is not found because the the current
directory
is not included in the PATH searched by the shell.
try ./mysql
or
/usr/local/bin/mysql.
Cindy Yu wrote:
>Hi Simon,
>
>I appreicate your help.
>
>Our serve
Dennis Jacobfeuerborn <[EMAIL PROTECTED]> writes:
> We are running MySQL version 3.23.43 on one of our servers and have some
> stability
Where did you get that? The MySQL site?
> Some info about the system:
> Dell PowerEdge 8450
> 4 x Xeon 700
> 4GB of RAM
> Intel GBit e
My suggestion (using a bigint and flagging the bits instead of using 40
char(1) fields) is only valid if you don't use any of those fields in WHERE
clauses in SELECT's. Not that you wouldn't be able to retrieve the entries
based on the respective field, but I don't think it would be indeed faster
Which is the fastest way to add FULLTEXT index to a database table with
1.500.000 rows ?
Please also reply to my E-Mail address.
Regards Jacob
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Jeremy,
Apart from this perl of wisdom, how about defining two columns: one a 'temporary' text
field and the other the
'real date column - as proposed, and importing the date-data into MySQL in the
temporary-text field (and leaving
the other/real one empty). Then copy the data out of the tempor
Hi.
I am using MySQL 3.23.44-MAX. with InnoDB
I have create two tables (one of them parent, other child).
All seems Ok. But when I am trying to insert new record into the table I am getting key
violation.
It happened when I am trying insert null value into field that have foreign key.
(column c
At 09:31 08/01/2002 -0700, John Meyer wrote:
Hi!
>Can I have different instances of winmysqladmin start instanciating
>different mysql's? i want to run one for the stable version, and one for
>mysql 4.0
Unlucky no. By the way the Windows Server currently doesn't have
support for to run several
Hi,
I have a table that contains something like follows:
id prop_name status action_date
prop_type address
1 name1 ok 2001-12-12
1 addy1forname1
2 name2
Hi Gary,
Finally I can access the server. You are my hero. I am new to mysql. It takes me a
month to try it.
Thank you very very much!
Cindy
>>> <[EMAIL PROTECTED]> 01/08 11:14 AM >>>
from your bindir type:
./mysql
-Original Message-
From: Cindy Yu [mailto:[EMAIL PROTECTED]]
Sent: T
Is there a way I can filter OUT records referenced in another table?
With Subselects it would be this, but I'm using 3.23:
select
a.*
from
a
where
a.id not in (select id from b)
You get the idea.
-
Before posting, please
Hi everyone,
I yould like to write a database server using MySQL. Before I begin,
I would like to know:
1. Is this possible to write, in C, a Macintosh client to this MySQL
server application?
2. Even if we already use Linux and Windows NT servers, is this a
good alternative to write the MySQL
On Tue, Jan 08, 2002 at 10:04:40AM -0500, Michael D. Stackhouse wrote:
> We run MySql on our Freebsd server, and on our Win2K server.
>
> We have several clients, and would like to store the databases in the
> clients' root directory. Is this possible?
Under UNIX, all of the separate databases
Serge Thibault writes:
> Hi everyone,
>
> I yould like to write a database server using MySQL. Before I begin,
> I would like to know:
>
> 1. Is this possible to write, in C, a Macintosh client to this MySQL
> server application?
>
> 2. Even if we already use Linux and Windows NT servers, is th
Hello,
No there's no thread in my application,
the program use fork but of course a new connection is create after each fork()
Today before running another test I do the following
- drop then create the tables
- increase the limit for opened file from 1024 to 4096
I run a test for 2
>Description:
Empty table returned when qureying for "show databases;" right
after installation. It shows a table with 10 rows, with empty fields in
each, and writes in the total, 11 databases.
When using a newly created database, doesn't show created tables (on show tables),
what can be the probl
At 16:50 08/01/2002 +, Los Morales wrote:
Hi!
>Hi,
>
>Would like to know if there is a "preferred" way of setting up the data
>directory for mySQL. The default for a database would be in C:\mysql\data.
>Is this the preferred way or should this be set up in another directory
>outside of the
select a.* from a left join b on a.id = b.id
where b.id is null;
Ken Kinder wrote:
>
> Is there a way I can filter OUT records referenced in another table?
>
> With Subselects it would be this, but I'm using 3.23:
>
> select
> a.*
> from
> a
> where
> a.id not in (select id from b)
>
Ilic writes:
> SELECT count(distinct ip) FROM pole_voti
>
> It does'nt work. Why ?
What's your MySQL version? Check the docs to see what version is
required for count(distinct). I think it was added in 3.23.early,
so it might be time to upgrade.
//C
--
Carl Troein - Círdan / Istari-PixelMa
Greer, Darren (MED) writes:
> If I move the status to another table, and then wanted to get a count of
> everyone who is of status 'A', how would that be any quicker? Would I
> join the tables?
Communication error - reattempting.
I meant that if you want to get the count of the number of 'A's
Hi,
I've got a table with a 5 milion records and with 10 records adding
every day.
My problem is that when I try to delete old records from this tables at
some point I receive the following error
ERROR 1034: Incorrect key file for table: 'logs'. Try to repair it.
and the query execution stop
make sure mysql owns the database directory and all its files.
[EMAIL PROTECTED] wrote:
>>Description:
>>
>Empty table returned when qureying for "show databases;" right
>after installation. It shows a table with 10 rows, with empty fields in
>each, and writes in the total, 11 databases.
>When u
1 - 100 of 129 matches
Mail list logo
