I'm trying to compile a program using C API. I get the following errors:
/usr/lib/mysql/libmysqlclient.a(my_open.o): In function `my_open':
my_open.o(.text+0x14): undefined reference to `open64'
/usr/lib/mysql/libmysqlclient.a(mf_format.o): In function `fn_format':
mf_format.o(.text+0x208): unde
Sorry, my previous post is wrong...
I say that mySQL JDBC doesn't support autocommit! It's wrong it
doesnt't support NOT autocommit; you have to use setAutocommit(true);
Connection cnn = null;
try {
Class.forName("org.gjt.mm.mysql.Driver");
cnn =
Hello list,
I created a user in mysql, here is his definition:
GRANT USAGE ON *.* TO 'admin'@'localhost' IDENTIFIED BY PASSWORD 'BLAblaBLA'
GRANT SELECT, INSERT, UPDATE, CREATE, DROP ON MyTable.* to 'admin'@'localhost' WITH
GRANT OPTION
that means that this user can grant select, insert, update
>If there is a function to sum values, why there isn't one to sum strings
>i.e. concat strings. Or how should i use it?
You use concat to put two strings together.
How it works? Thats why people like me always have a manual or a reference
guide lying around.
Not much fun typing it.
Bye,
B.
I have installed mysql 3.23.36 for the first time ever
I did the test (ok)
I ran the bench mark and could not load DBI
I installed DBI 1.14
And Data Showtable 3.3
Then tried to install (Msql-Mysql-modules-1.2215)
Perl Makefile.pl worked fine
I run make and this is what it ends with:
make[1]: Ent
Hi, I have those tables:
CREATE TABLE citys (
id mediumint(8) unsigned NOT NULL auto_increment,
name varchar(100) NOT NULL,
UNIQUE id (id)
);
CREATE TABLE route (
id mediumint(8) unsigned NOT NULL auto_increment,
id_from mediumint(8) unsigned DEFAULT '0' NOT NULL,
id_to mediumi
I have installed mysql 3.23.36 for the first time ever
I did the test (ok)
I ran the bench mark and could not load DBI
I installed DBI 1.14
And Data Showtable 3.3
Then tried to install (Msql-Mysql-modules-1.2215)
Perl Makefile.pl worked fine
I run make and this is what it ends with:
make[1]: Ent
Hi there
I have managed to follow your instructions, I have used the BDB source files
from the Unix download (build_win32 directory). And I have used the Windows
Source Files for MYSQL. Everything appears to compile correctly without any
errors, however when trying to do a "net start mysql" I get
>Description:
My disc was full when I tried to restart mysql. The error log filled up
with:
Innobase encountered a problem with file /var/lib/mysql/ib_logfile0.
Disk is full. Try to clean the disk to free space
before answering the following: How t
mysql:
hi ,i am a user in china.Now i have a problem that i cound't find
mysql-3.22.30.tar.gz in the site www.mysql.com.
I think you can tell me where i can download it . Thanks!
yongqiang tao
[EMAIL PROTECTED]
Hi all.
Does anyone know for sure if MaxSQL backward
compatible with MySQL. I know this may be a silly
question but i have come across developments which are
not backward compatible and want to make sure.
If you also know of articles which states this then
please let me know as well. Thanks.
___
Help ! Does anyone have a clue ?
tried to run configure on Ultra SPARC/Solaris 2.7
GNU binutils and libtool latest version, gcc 2.95.2
environment variables:
CC=gcc
CFLAGS=-O6
CXX=gcc
CXXFLAGS=-O6 -felide -constructors -fno-exceptions -fno-rtti
at the command line:./configure --prefix= --
Hi. I have a 3.23.22 test db running on Linux 6.2. I am able to start the
database in log mode.
I also have a 3.23.28 production db running on Linux 6.2. When I start this
database in log mode, there is no indication that logging is running. There
are no .index or .nnn files anywhere. Do you
At 00:27 24/04/01 +0200, Warren van der Merwe wrote:
Hi!
Below the instructions that I sent some time ago, only change the
version mentioned by the new ones that you have.
Regards,
Miguel
Assuming that you have on hand:
- The db-3.2.9 source stuff
- The MySQL 3.23.36 source stuff
- The VC++ 6.0
Hi there
I have both the patched source for BDB and the Win32 source for MySql. So
now the next logical step is to compile them right? So I compile them, but
one thing is lurking in the back of my mind, how do I set the MYSQL up to
use the BDB table type? When I try and create a table and set the
the name you are getting is random. you want:
create temporary table t1 as
select distance, min(speed) fastest_speed
from table1 group by distance;
select table1.name, table1.distance, table1.speed from
table1, t1
where table1.distance=t1.distance
and table1.speed=t1.fastest_speed;
P.S. I think
Hi all,
I'm new to this list, and would like to post a question.
I have a database with one table with a TEXT field where we save HTML files.
This table is Updated and Selected from a Servlet Applicacion, using JDBC.
Some TEXTs have a size of arround 60Kb. For records with this size (or
arround
Hi
SQL troubles:
I have a table containing 4 columns: "name" - string, "distance"-
double,
"speed" - time and "id" - AUTO_INCREMENT (Primery key)
I want a list of the fastest (speed) runner (name) of each distance and
the
speed.
I use:
select name, distance, min(speed) from table1 group by distanc
Hi,
Mysql ran for 6 days.. It is a website
with heavy traffic.
/usr/libexec/ld-elf.so.1: /usr/local/libexec/mysqld: Undefined symbol
"strtoull"
010423 23:18:08 mysqld restarted
/usr/local/libexec/mysqld: ready for connections
What is this function
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Aigars Grins" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 10:51 PM
Subject: Re: Re: Reg. determining version
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the f
Hello,
On a NT4/Apache server, we have a php application that uses the following
syntax to open a connection :
$connect = mysql_connect("$serverhost","$serveruser","$serverpass");
mysql_select_db("$serverdb",$connect);
$mysql_link = $connect;
Since we upgraded to the latest version of mysql, th
Hi there,
I'm using mysql 3.22.27. How can I force mysql to use index's in my select
statement?
When I use explain to see what the optimiser is doing I see that its using the
wrong index. When I try to use the USE INDEX(KEY1,KEY) i get a syntax error.
Any ideas
Thanks,
Pat
Pat Militzer
Tec
It will run just fine, you need the patched version if you want transaction
support.
ryan
> Hi there
>
> I have managed to download the "Berkeley for Windows" installation,
however
> I have noted that MYSQL will not run without a patched version of
> berkeley's. Where can I obtain such a instal
Type "perror #error_num" at the prompt, you can get what the error codes
mean from there.
ryan
> Hello,
>
> A few days ago I asked if anyone knows the numeric values of the
> Mysql error codes. Nobody responded, so I looked through the source
> code to find the answer. This info would be valu
At 21:28 23/04/01 +0200, Warren van der Merwe wrote:
Hi,
>Hi there
>
>I have managed to download the "Berkeley for Windows" installation, however
>I have noted that MYSQL will not run without a patched version of
>berkeley's. Where can I obtain such a installation to run on Windows?
Download our
Ken Menzel wrote:
>
> Bonjour Hassan,
> Il y a une liste français du MySQL que je viens de trouver.
> Peut-être ça t'aide.
> [EMAIL PROTECTED]
>
> En Plus, il y a php-france,
> envoyez un mail à [EMAIL PROTECTED]
>
> Je suis un participant tous les deux. J'espère que je t'y verra!
>
> Amica
On Mon, Apr 23, 2001 at 02:29:00PM -0400, Ken Menzel wrote:
> Load balancing, because I can't run two servers on the same port
> either!
Right.
> I have to use say 3307, 3308, 3309 and then do at least DNS round
> robin, what do you think Jeremey?
DNS round robin on affects hostnames, not port
On Mon, Apr 23, 2001 at 08:37:31PM +0100, Aigars Grins wrote:
> When using there is defined a:
>
> MYSQL_VERSION_ID
>
> It's defined as something like:
>
> 32235
>
> I guess this is representing version 3.33.35.
>
> Is this the 'right' way of determining version? I want to do somethi
On Mon, 23 Apr 2001, Eugene Reuter wrote:
> I installed mysql 3.23.36 binary version for OpenServer 5.0.5. According to
> MySql documentation this version supposes to support BDB-tables. But if I
> try to create Type=BDB tables I get MyIsam. If I look into my variables I
> see have_bdb = No.
> How
Hi,
When using there is defined a:
MYSQL_VERSION_ID
It's defined as something like:
32235
I guess this is representing version 3.33.35.
Is this the 'right' way of determining version? I want to do something like
an ifdef to incorporate support in my code for different versions of My
Hi there
I have managed to download the "Berkeley for Windows" installation, however
I have noted that MYSQL will not run without a patched version of
berkeley's. Where can I obtain such a installation to run on Windows?
Kind Regards
Warren
~
Warren van der Merw
Hello,
A few days ago I asked if anyone knows the numeric values of the
Mysql error codes. Nobody responded, so I looked through the source
code to find the answer. This info would be valuable if, for
example, you wanted to programmatically handle certain types of
errors.
In the source dis
Bonjour Hassan,
Il y a une liste français du MySQL que je viens de trouver.
Peut-être ça t'aide.
[EMAIL PROTECTED]
En Plus, il y a php-france,
envoyez un mail à [EMAIL PROTECTED]
Je suis un participant tous les deux. J'espère que je t'y verra!
Amicalement,
Ken
--
Load balancing, because I can't run two servers on the same port
either! I have to use say 3307, 3308, 3309 and then do at least DNS
round robin, what do you think Jeremey? Anybody on your end have a
better idea? Doesn't sound to me like the best solution. I have
heard of people trying to m
At 01:56 23/04/01 -0700, Van wrote:
>hassan el forkani wrote:
> >
> > j'ai eu le meme probleme mais en environnement de développement, ce que je
> > sait c'est que ca dépend du characterset de votre base de donnée faut
> > demander à votre hebergeur le characterset (dans les "environnement
> > var
"Marc S. Bragg" wrote:
> How does one redirect mysql to a data directory location different than
> the default. . . . and if possible, only for a particular database.
>
>
You can find the 'official' notes on how to relocate tables or entire
databases at:
http://www.mysql.com/doc/S/y/Symboli
Hi,
I have a table that keeps track of when certain articles go up on the
site. It has a field called featureStart, which is a unix timestamp. The
features stay on the site until the next feature replaces them, so there
is no featureEnd. If one feature started on Apr 23 and another one is
schedul
Hi,
I use this code to connect to a mySQL 3.23.36:
Connection cnn = null;
try {
Class.forName("org.gjt.mm.mysql.Driver");
cnn =
DriverManager.getConnection("jdbc:mysql:///", ,
);
cnn.setAutoCommit(false); // doesn't support autocomm
taxt/plain
How does one redirect mysql to a data directory location different than
the default. . . . and if possible, only for a particular database.
--
Marc S. Bragg
[EMAIL PROTECTED]
Bialecki & Bragg, PC
p: 610-444-7508
f: 610-444-7548
http://www.chescolawyers.com/BB
"Chester County Legal Services" - "F
On Mon, Apr 23, 2001 at 10:33:48AM -0400, Ken Menzel wrote:
>
> Hi Tim, and everyone, I am moving this discussion to the main list
> (since I have questions others might be able to answer. I copied
> the entire (short) thread so people can catch up.
[snip]
> Hmmm sounds like fun, I am going to
Not understanding excactly why you'd need a random string, I'd suggest doing a simple
password() call on each row's recipient
ALTER TABLE ADD COLUMN rand_string char(16) NOT NULL;
UPDATE my_table SET rand_string=password(email);
This gives you a 16 char long (I think) random string.
Sending thi
I'm looking for a way to create a temporary table containing a sub part of
the master table...
I know that I can use :
CREATE TEMPORARY TABLE tbl_name [(create_definition,...)]
[select_statement]
but i'm working on a script that must create tables with the same
"create_definition" that the ma
Hi!
Not sure if this will be useful as well. Searched the MySQL manual and
found this page. It mentions a bit about restarting MySQL and resetting the
root password.
http://www.mysql.com/doc/A/c/Access_denied.html
Hope it helps!
Sam.
- Original Message -
From: "Ken Menzel" <
hello lists,
i want to use the nested set model to store a tree structure in a database.
the normal way i do this looks like this:
My table looks something like this:
ID LEFT RIGHT NAME
11 14 Root
22 7Thema 1
33 4Thema
I was told that i need to create mysql-logon.sock so that mysql will start
running
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To re
On Mon, 23 Apr 2001, New Style MySQL Personnel wrote:
>
> Please anyone. I really need some ideas.
> I copied my database files made with 23.29 to 23.26 and now I get this. I
> chowned mysql.mysql and chmoded 660.
> The location of the databases is good because I have some other databases
> crea
Use merge tables, or two separate queries.
"Wix,Christian XCW" wrote:
>
> Hi
> I have two similar tables. (table1 & table2). They contain the columns
> "name", "distance" and "date". Table1 is year 2000 and Table2 year 2001.
>
> I need to get the total distance for each name.
> For year 2000 I
You don't.
Privileges can be set for a column in a table, but not by record.
Mark van Brenk wrote:
>
> Greetings, and I'm sorry if this is a topic that's already been covered, but I've
>read over about 100 of the past mails and can't find something similar.
>
> How do I GRANT UPDATE to specifi
Install gmake.
Lana Conan wrote:
>
> First of all sorry for my English, I hope it would be good enougth to be
> understood.
>
> I am trying to instal mysql on a digital unix os.
>
> First I had problem with the ./configure
> it prompted this message
>
> checking for cc++... no
> checking fo
Hi,
> mysql> use lumina;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Didn't find any fields in table 'absences'
> Didn't find any fields in table 'admins'
> Didn't find any fields in table 'classe
chown -R mysql /var/lib/mysql
New Style MySQL Personnel wrote:
>
> The location is good because I have some other databases created with 36
> and they work fine. I copied ALL the database's files to /var/lib/mysql
> where the others are and I get this error. Any idea?
>
> On Mon, 23 Apr 2001,
>From the very fine manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.htm
l#Resetting_permissions
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "jessica" <[EMAIL PROTECTED
Hi,
A client has had some sort of disk failure and several files from one of
my projects disappeared or were corrupted along with some system
files I have replaced the files from my own backups and have the
web/php based interface working again, but I get the following when
trying to access m
Please anyone. I really need some ideas.
I copied my database files made with 23.29 to 23.26 and now I get this. I
chowned mysql.mysql and chmoded 660.
The location of the databases is good because I have some other databases
created with 36 and they work fine. I copied ALL the database's files t
> It's a bad habbit to cc to a list.
Ooops. Sorry.
> >Of course "left join". And "group by" moreover. But how?
> >For the "group by" i need a sum-like function, which joins the strings.
>
> Hmmm, something like concat() you mean?
>
I tried it. Doesn't works.
Without group by i have this set:
id
-Ursprüngliche Nachricht-
Von:Kamil
Gesendet am:Montag, 23. April 2001 17:52
An: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Betreff:problems with SQL UPDATE
I have a problems with SQL UPDATE statements within an Java programm which
establish a connection to
Hi Eugene,
The binary version do not yet have BDB or Innodb support yet. You
will need to compile your own version using --with-berkeley-db in
order to use those features. I believe there are notes in the manual
on how to compile this for SCO, but I don't know if BDB has been
ported to SCO y
It's a bad habbit to cc to a list.
>Of course "left join". And "group by" moreover. But how?
>For the "group by" i need a sum-like function, which joins the strings.
Hmmm, something like concat() you mean?
Bye
B.
mysql, query
---
Hi Tim, and everyone, I am moving this discussion to the main list
(since I have questions others might be able to answer. I copied the
entire (short) thread so people can catch up.
1) Is there anyone currently running multiple mysqld's on FreeBSD
with success?
2) How much is this 'overhead'
I have MYSQL 3.23 and php on a Win2k box running on IIS5. I must copy the
database to a Solaris machine that uses php running on Apache. Can you help
me on how to handle this issue.
Your help would be greatly appreciated,
John
Hi! It looks like I found a strange behaviour of the MySQL (3.23.36 on
windows and linux). Probably it's due to my own mistake but I really
can't catch what's up.
Look:
I have two tables linked w/ the 'one-to-many' relation. They look like
follows:
mysql> describe MessageType;
+-
I've made a stupid error. While logged in as root I was deleting
records from the user table. Someone was talking to me while I was
entering a command and I didn't realize what I entered until it was too
late. I entered:
delete from user where user='root';
I immediately used an insert statemen
Of course "left join". And "group by" moreover. But how?
For the "group by" i need a sum-like function, which joins the strings.
> >how can i get a recordset constains all records (or records matching a
where
> >exp.) from the Table1 with the c values from the Table2, like this:
> >
> >uidnam
Steve Werby wrote:
>
> "Martin E. Koss" <[EMAIL PROTECTED]> wrote:
> > I started a table with a varchar filed of 11 characters for a column that
> > would hold data such as 0.27; 11; 0.6; 1; 5; 7.5; 11.2; etc
> > I wasn't sure if a 'number' field would work. Now I want to list the
> values
> > in
I installed mysql 3.23.36 binary version for OpenServer 5.0.5. According to
MySql documentation this version supposes to support BDB-tables. But if I
try to create Type=BDB tables I get MyIsam. If I look into my variables I
see have_bdb = No.
How can I get it work?
Eugene
---
Sven Heising wrote:
>
> Hi list,
>
> I'am new in this php and mysql-stuff so i need al lil bit support...
>
> this is my problem:
> $result = mysql_query("select * from $dbtable where $wonach like
> '%$first_name%' ");
>
> $wonach is a var which is set in a html form if i want to search
Hello,
Does any of you know how much columns a MySQl table can handle? Is it
fixed or does it depends of some parameters (fields' datatypes, RAM, total
table size...)?
Thanks
DELAUNAY Antoine
-
Before posting, please check:
This sounds more like a OS problem then a MySQL problem.
I don't know much about HPUX.
Bye,
B.
>Hi folks,
>
>Thought I'd see if I have a common problem before I do a bug report. I am
>trying to install the binary file for HP/UX 10.20 on a HP/UX 10.20 785
>series computer. As the error mess
Dear me -
me writes:
> I am hoping to find somebody who provides low budget mysql and php access.
Buy yourself a copy of "Web Techniques" magazine and browse the
advertisements.
Yours - Billy
-
Before postin
Hello to all,
i want to properly export Data from a MySQL Table with columns that contain
Thai and Latin characters and import this data to an Oracle Table with UTF8
characterset.
Who can give me some advice.
Where can i find detail MySQL-Information concerning this problem?
Thanks in advace.
Bonjour,
J'utile le 'characterset default' de MySQL et je n'ai acune probléme
avec mysql. Si'l te plait, donne ça un coup, D'abord on a besoin
d'un ligne de commande de mysql liée à le serveur en question. (comme
mysql -uusername -pmotdepasse -hhôte.domaine )
You should not need to escape fr
>how can i get a recordset constains all records (or records matching a where
>exp.) from the Table1 with the c values from the Table2, like this:
>
>uidnamecs
>-
>1user1'50 - twenty-three - the reason of life'
>2user2'twenty-three - 303 rulz'
>3user3
Hi
In my opinion I would imagine Merged tables would do what you wanting. Refer
to the MYSQL manual.
Thanks
~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Cell (083) 262-9163
Office (031) 767-0249
> -Original Message-
> From:
I'm having trouble building the mysql323-server port (3.23.36/7). I am
running Freebsd 3.5 on an i386.
The build breaks during the sql/share/Makefile with the following error:
/bin/sh ../libtool --mode=link c++ -DDBUG_OFF -O -pipe
-felide-constructors -fno-rtti -fno-implicit-templates
-DMYSQLD_
Hi folks,
Thought I'd see if I have a common problem before I do a bug report. I am
trying to install the binary file for HP/UX 10.20 on a HP/UX 10.20 785
series computer. As the error message is about memory problems the following
info may be of interest. The tar file is on a volume with 30,0
The location is good because I have some other databases created with 36
and they work fine. I copied ALL the database's files to /var/lib/mysql
where the others are and I get this error. Any idea?
On Mon, 23 Apr 2001, B. van Ouwerkerk wrote:
>
> >I copied my database files made with 23.29 to 2
Create a merge table of the year 2000 and year 2001 tables as follows.
Then run your select on the merged table.
You can then drop the merge table if you don't need it anymore.
CREATE TABLE table3 (name, distance, date) TYPE=MERGE UNION=(table1,table2);
SELECT name, SUM(distance) FROM table3 GR
Original Message -
From: "Warren van der Merwe" <[EMAIL PROTECTED]>
Subject: MSACCESS v.s. MYSQL
> I am looking at alternate databases and have been testing with MYSQL for
> some days now. I have noticed a couple distinct differences in some of the
> SQL statements, but have managed to
For example i have 3 tables (really i have to make it with 6 tables, but...)
So 3 tables:
Table1
uid| name
1user1
2user2
3user3
Table2
iduidc
1150
2123
3142
4223
52303
Table3
idctxt
123'twenty-three'
242'the
Dear All,
How do I create random string for each row in a mysql table? and mail the
same each recepient in the respective row.
Thanks
Love and regards
Prasad
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi,
I am hoping to find somebody who provides low budget mysql and php access.
Thank you very much for any suggestion
Andonny
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
Hi
I have two similar tables. (table1 & table2). They contain the columns
"name", "distance" and "date". Table1 is year 2000 and Table2 year 2001.
I need to get the total distance for each name.
For year 2000 I would do this:
select name, SUM(distance) from table1 group by name;
How do I do it f
Nicola Sabbi writes:
> HI,
> I have the following table:
>
>
> desc keywords_news;
> ++--+--+-+-+---+
> | Field | Type | Null | Key | Default | Extra |
> ++--+--+-+-+---+
> | id_keyword | int(11) |
ryc writes:
> I have a auto increment field in a table and after doing a few operations
> the flag has gone away. This is using mysql 3.23.36 on OpenBSD. Here is how
> it happened:
>
> I am using perl with DBI to interface with mysql. I have been inserting
> "NULL" into this field to allow mysql
William Dan Terry writes:
>
> When you say the bug is in the linker, do you mean in the linker app
> itself or how I'm using it? In terms of the static zlib, don't I have that
> covered with
>
> gcc -static metamgrd.o sock.o cfgfile.o cfgitem.o err.o -o ./metamgrd \
> -lstdc++ -L/usr/lib/mysql
Greetings, and I'm sorry if this is a topic that's already been covered, but I've read
over about 100 of the past mails and can't find something similar.
How do I GRANT UPDATE to specific columns in specific records?
Example:
I've got a table "u" which covers complete data on each user for the
[EMAIL PROTECTED] wrote:
>
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query
>
> If you just reply to this message, and include the
Hi list,
I'am new in this php and mysql-stuff so i need al lil bit support...
this is my problem:
$result = mysql_query("select * from $dbtable where $wonach like
'%$first_name%' ");
$wonach is a var which is set in a html form if i want to search one row
it is no problemselecting works
Hi all,
I was just fiddling around with some indexes on a table and decided to do an
EXPLAIN for a query I was trying to optimize. I got a peculiar message
output, and I'm not sure what it's trying to tell me!
This is what I got:
mysql> explain select min(impression), max(impression) from event
First of all sorry for my English, I hope it would be good enougth to be
understood.
I am trying to instal mysql on a digital unix os.
First I had problem with the ./configure
it prompted this message
checking for cc++... no
checking for cl... no
checking whether the C++ compiler (gcc ) wo
hassan el forkani wrote:
>
> j'ai eu le meme probleme mais en environnement de développement, ce que je
> sait c'est que ca dépend du characterset de votre base de donnée faut
> demander à votre hebergeur le characterset (dans les "environnement
> variables") du serveur mysql ou votre base est he
Hi there,
I'm having a problem on my complicated query.
My question is similar to the question in a couple of emails earlier in
this mailing list which subject's is "complicated query".
I got 3 tables below.
table
++--+
| id | name |
++--+
| 1 | fumi |
| 2 | ali |
| 3 | ton
>I'm new to MySQL and I've recently installed MySQL
>(MySQL-3.23.36-1.src.rpm) and it's running ok. But, I noticed that it
>seems to be consuming so much of my hard disk space. Is this normal? I'm
>wondering if anyone encountered this problem before or can advise wat I
>can do abt it?
I don't kn
Hi there
I am trying to find out how the Berkely DB stuff works when running MYSQL on
windows. How do I create a transactional table?
Regards
Warren
~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Cell (083) 262-9163
Office (031) 767-02
>I copied my database files made with 23.29 to 23.26 and now I get this. I
>chowned mysql.mysql and chmoded 660. What's wrong?
Perhaps or.. the location of your database is different.. or.. you
didn't copy everything.. including subdirectories.
Solution: check the location and if you copie
> For connecting I have given the user as root and no password in the PERL
> scipt.
You NEED to provide the password otherwise you can't get any data out of
the database.. If you didn't entered a password for the mysql root user you
need to do it ASAP..
>Is there any way to connect
I copied my database files made with 23.29 to 23.26 and now I get this. I
chowned mysql.mysql and chmoded 660. What's wrong?
mysql> use lumina;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any field
HI,
I have the following table:
desc keywords_news;
++--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| id_keyword | int(11) | | PRI | 0 | |
| id_new
Hi,
You must install MyODBC in your Unix system, and the MyODBC module for
windows.
Once it is done, make a new connection trought this module whit de ODBC
default fort, the machine name, user, pass and database.
It was all I did and it worked correctly
Javier
1 - 100 of 104 matches
Mail list logo
