To add:Table db.user does not exist. means you need to read 4.16 of the
manual "Post Installation". You need to install the grant tables using
mysql_install_db.
- Original Message -
From: "Seung-woo Nam" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 03, 2001 23:54
Hi!
I have a tests database that has questions (one table is "questions" and a
field in this table is "uid" and another field is "question")
there is also a Testerator table in my tests database, which organizes
questions by section and keeps track of test number (as field "Quid")
SO I would
Description:
There is a bug (or undocumented feature?) in libmysqlclient - if
function "strend()" is defined in client code, client will fail
to connect to database with "MySQL client run out of memory"
message.
How-To-Repeat:
#include mysql/mysql.h
#include stdio.h
void
Hi!
As we have underlined so many times on all our mailing lists, 2.96 can
not be used for the building of MySQL++. It is a very buggy compiler.
Use 2.95.2.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
Dear sir,
I installed mysql on my apache server.
However when I want to access the mysql database through my perl scripts.
Following error occurs while running the scripts :
install_driver (failed) : perhaps a module that DBD::mysql requires has not been
fully installed.
Could you
Hi,sir.
I use Mysql 3.23.25 on linux-kernel 2.2.16-3,Pentium III 651 MHz,Memory 516M.
I have many table and many client connect.
And I have error "Too many connection"(edit max_connections)
Now I use default value of server variables.
I want maximun performance.How I must set
Hi,
MySQL lets you do a select without any tables,
i.e., without the from-clause.
So,
select 3;
returns one row, one column, value 3.
To put a value into a variable (you mean the @a -style variables?),
you can either
select @a := 3;
or
set @a := 3;
And yes, if you want to do it the
Hi,
let supose that I have next columns in Mysql database
q1a, q1b, q1c and Gender with next values (5 rows)
q1a (1,3,5,7,9)
q1b (1,2,3,4,5)
q1c (1,6,7,8,9)
Gender (1,1,2,2,1)
which gives the table
id q1a q1b q1c Gender
1 1 1 1 1
2 3 2 6 1
3 5 3 7 2
4
Description:
checking whether struct tm is in sys/time.h or time.h... time.h
checking size of char... 0
configure: error: No size for char type.
A likely cause for this could be that there isn't any
static libraries installed. You can verify this by checking if you have libm.a
in /lib,
I have a master and slave server, both running mysql-3.23.29-gamma.
When I set up a second slave running mysql-3.23.33, it logged these
errors:
010304 10:18:50 mysqld started
/opt/local/mysql/libexec/mysqld: ready for connections
010304 10:18:51 Slave: connected to master '[EMAIL
On Friday 02 March 2001 18:22, Boulat Khakimov wrote:
Hi guys,
I'm wondering why you prefered mySQL overe Postgres , they are both open
source,
and accorting to many people Postgres is more powerful and stable than
mySQL.
Trivial installation and update on my Linux Redhat box thanks to the
I am tring to connect remote Mysql DB from local machine.
Do I have to use MyODBC to connect linux server and linux client?
Before 3 days, I used "mysql_connect("..","host ip",...)".
I failed, the error msg is "host ' ' is not allowed to connect".
From manuals, I read that I must use
Do you know how to import TXT file into mysql DB?
Because of big size txt file, I cannot input data into DB manually.
Is there easy way to solve that problem?
Thanks a lot.
I have the exact problem. I wonder why the file size is 0 of the file mysql.sock?
I
Hi!
Socket file specified is : /var/lib/mysql/mysql.sock
which on my system%2
Do you know how to import TXT file into mysql DB?
Because of big size txt file, I cannot input data into DB manually.
Is there easy way to solve that problem?
Thanks a lot.
Hi
I am a 5th year student of University of Technology in Poznan (Poland). I would like
to use MySQL in commerce project (Internet Auction). I will develope my Auction in
Linux. Have I buy a licence from you ??? How many it cost. Pleace answer me, it is
very important for me.
Thank you.
I cannot seem to get this database program to work correctly. I am asking for any
help I can get. I need to start this asap.
Charles Hagen
[EMAIL PROTECTED]
Hi All!
I just posted a note about having problems creating temporary tables.
However, I JUST realized (and empirically verified) that my problem of not
being able to create temporary tables is that I didn't use an ID with the
CREATE permission enabled. I am a bonehead.
Thanks again!
Cheers!
- Original Message -
From: "Sinisa Milivojevic" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, March 04, 2001 7:32 AM
Subject: Re: Problems building mysql++
Quinn Wilson writes:
I am trying to build mysql++, I am doing something wrong but I don't
know
Lets see if anyone can help me out:
I have these 3 tables in a MySQL 3.22.27 Database and i'm running this query:
SELECT supplier.id,supplier.company_name,supplier.contact_name,supplier.address_street,
supplier.address_city,supplier.address_state,supplier.address_zip,supplier.phone_business,
Description:
AARGGGgg
your documentation is simply wrong. NONE OF THE USER PERMISSION materal makes sense.
I am read ing here
http://www.mysql.com/doc/D/e/Default_privileges.html
and
http://www.mysql.com/doc/A/d/Adding_users.html
and I follow
Description:
Unclear documentation on how user permissions work. I've been using databases for
about a year and have experience with Postgres and Oracle.
How do I add a new user?? How do permission work?? I've spent an hour now and I
still get:
ERROR 1044: Access denied for
Quick searches of Google and the MySQL page didn't turn up anything, so I'll ask here..
Here's what I have:
I have a table that among others, have fields called 'section_id' and 'parent_id'. The
section_id is the id of the "self" section, and the parent_id is the id of the section
that "owns"
Hi there...
Very new to Databases
I have been learning ASP over the last few months and have no come to start
using databases
My web host is WebFusion, who use a MySQL system for their database, where
as I at home use MS Access2000...
I've got it all set up so that I can export from
Hello,
I have the following query:
"SELECT thara_plane.id,thara_plane.nam
e,thara_plane.nick,thara_plane.bodytext,thara_category.category "
."FROM thara_plane,thara_category,substring(thara_plane.bodytext,225) as
bodytext "
."WHERE ((thara_plane.category = thara_category.id)) "
."ORDER
Hi.
On Tue, Feb 27, 2001 at 04:49:33PM -0800, [EMAIL PROTECTED] wrote:
Can MySQL help with generation of ALPHANUMERIC unique identifiers ?
ID's that use the full ASCII char range create more possible combinations with the
same # of characters which can be important when squeezing into
Description:
Unable to compile on a 64bit Solaris 7 machine with gcc.
How-To-Repeat:
./configure
configure output snipped
checking size of char... 0
configure: error: No size for char type.
A likely cause for this could be that there isn't any
static libraries installed. You can verify
Hi,
Do you mean case insensitive when you do a like?
a like is case insensitive, to make it sensitive do a LIKE BINARY 'abc',
or use CLIKE (from memory, might be wrong).
Robin
-Original Message-
From: Carfield Yim [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 10:42
To: '[EMAIL
You'd probably be better off having rank and votes fields in the actual
album_detail table. Whether you choose to maintain the individual votes in
the album_ranks is another story. Let's say you rank an album from 1 to
10 - the rank would then be calculated like this:
$uservote = 8.5 // this
Hi,
A few days ago, I asked the list about a SELECT statement. I received 2
replies that didn't really work but helped me think about the problem some
more. In my database I have 4 tables. For this one query, I am matching up
data from 3 of these tables and then displaying them on a website.
DOn't ask me to explain this, I am not that smart. But here is what I
have found out. I was trying to configure mysql using gcc as the C
compiler and C++ compiler. Configure kept failing when it got to
checking gcc as the C++ compiler. When I checked the config.log it
failed trying to excecute
(sorry for my english, I am from Russia)
I have a problem this MySQL on my linux (2.2.14) server.
In some pretty day after reboot MySQL-server (3.22.25) stopped to answer on
any exposure.
I tried to do something and after all remove it completely and install
again - nothing happens.
I install
hi,
i have a problem
i have a database table created with the statement:
CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT, message
text, username varchar(100), UNIQUE id (id);
I insert records with:
INSERT INTO chatmessages (message, username) VALUES ('this is my
On Mon, 5 Mar 2001 16:28:56 +0900, "Cho Bum Rae" [EMAIL PROTECTED] wrote:
check into the LOAD DATA, this should handle it for you.
Manual: http://www.mysql.com/doc/L/O/LOAD_DATA.html
Do you know how to import TXT file into mysql DB?
Because of big size txt file, I cannot input data into DB
Hello all,
I am brand new to MySQL. I have very limited experience with SQL type
databases. MySQL appears to be a very elaborate product capable of many
things. I've glanced at the documentation before writing this. I have 2
very general question to all you 'experienced' MySQL users.
Question
What am I doing wrong?
The goal is to count the number of entries which match the account
preferences.
The results are correct, but the times are so far off...
mysql select count(*) from STLOUIS left join ClientSTL
- on STLOUIS.Dwell=ClientSTL.Dwell where ClientSTL.account='pruitt';
dear Sir,
It's so exiting receive your mail. For months it's the first and perhaps
the only mail I receive. Thank you.
There are quetions remain:
Isn't it the complete 3.22 package I installed ? I've read several
text books about Mysql, that they don't mention the Mysql-devel
package, and the
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API program which catched from the MySQL tutorial, it
chokes at the end of compile process . the program is as follows:
#include stdio.h
#include mysql.h
#define def_host_name NULL
#define def_user_name
on 3/5/01 12:28 AM, Cho Bum Rae at [EMAIL PROTECTED] wrote:
Do you know how to import TXT file into mysql DB?
Because of big size txt file, I cannot input data into DB manually.
Is there easy way to solve that problem?
Cho:
Look at mysqlimport, which comes with mysql. It is well documented
At the moment all anyone can do is point you to the manual at
http://www.mysql.com/doc/I/n/Installing.html. Given how easy this is to
find from www.mysql.com, we must assume you have already read it and
therefore are having some sort of problem not covered by it - perhaps you
could explain what
Hello mysql,
Hi, I have a table "Invoices", and i want to do something like
this..
every 15 of every month, i need to open every registry of invoices..
take the price of each record and crete a new record with that price
* 1.21 (I'm from argentina, and we pay some taxez :)
How can i
Have a look at mysqlimport and 'LOAD DATA INFILE' in the manual. Your
question doesn't provide the format of the text file, so it's hard to
pinpoint an exact solution...
http://www.mysql.com/doc/L/O/LOAD_DATA.html
http://www.mysql.com/doc/m/y/mysqlimport.html
On Sun, 4 Mar 2001, Cho Bum Rae
the following is quite odd, maybe i'm doing something wrong..
mysql drop database planhouse-broke;
ERROR 1064: You have an error in your SQL syntax near '-broke' at line 1
mysql show databases;
+-+
| Database|
+-+
| jeffdavis |
| kermit |
|
Hi,
I'm fairly new to MySQL and unix. I have installed mysql on redhat 6.2 without too
many problems. I am changing my o/s to FreeBSD 4.2 and have installed mysql after many
hours of grief. I have mysql set to start at boot time and this seems to work well.
The problem I have is that I can't
hi,
i'm writing a book (wrox publishers) which uses mysql for the sample
database.
i seem to have encountered a problem with an SQL query.
its a simple voting application, with a candidate table, and a vote table:
create table candidate (
candidatenumber integer not null auto_increment,
Jonathan Dugan wrote:
your documentation is simply wrong. NONE OF THE USER PERMISSION materal makes sense.
I am read ing here
http://www.mysql.com/doc/D/e/Default_privileges.html
and
http://www.mysql.com/doc/A/d/Adding_users.html
and I follow what is says:
shell mysql -u root mysql
Charles, you need to be more descriptive about exactly what
problem you're having. Spell out your hardware, OS, MySQL
version, etc., and describe what isn't working.
Charles L. Hagen [[EMAIL PROTECTED]] wrote:
I cannot seem to get this database program to work correctly. I am asking for any
Hi,
it would be nice to have a replicate-ignore-table for the Master also!
It works fine, but if one has to replicate only certain tables of a db
it would be good to have this.
It is not enough to have this on slave only, because we do not want to
send the data of whole databases across the
Hello All,
Was wonder if any knows of a Perl equivalent to the PHP's version of
phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP
installed, and frankly, to lazy to do all the typing thru telnet session! :)
TIA,
Mickalo
Mike(mickalo)Blezien
I have a column in my maildb table that I need to encrypt using the Password
feature. The users and the passwords are stored in another table in the
database, I would like to just rip them out of the non-encrypted fields
(radcheck.UserName, and radcheck.Value) and place them into the
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API program which catched from the MySQL tutorial, it
chokes at the end of compile process . the program is as follows:
#include stdio.h
#include mysql.h
#define def_host_name NULL
#define def_user_name
I`m trying to find the best method to match records between two tables in a
MySQL database. But it must match atleast once, so here is a scenario for you
to think about.
Member - Job, Salary, Location
Jobs - Job, Salary, Location
All values will be enum sets in both tables as follows
Job =
February 1, 2001 marks the start of the African American History Minute
Webcast tour. The tour will visit more than 150 historically significant
African American locations across the country and make them available to you
via streaming video.
Absolutely Free
In addition to providing
ping!
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2001 03:04
To: MySQL (E-mail)
Subject: Just Checking
Hi,
I someone sees this, can they respond, because I have received nothing from
the list for 30 hours +. It's now 16:00 NZ Time, 03:00 GMT on
Well, if you have everything setup right.. this is easy to do in SQL.
Lets say you have your root table:
create table root(
id integer unsigned not null auto_increment,
description varchar(50),
key root_key (id)
);
and your sub categories:
create table subcats(
Robb
Exact error messages would be good at this point and it may be possible that
their version of MySQL may not fully support the command you are trying to
perform although with an UPDATE TABLE I would hope this unlikely.
I think you probably need to provide:-
SQL statement you are trying to
An RPM installation indicates that you might be installing on some
version of Linux. Could you specify the platform, the operating system,
the Mysql release Number so
that people with the experiece that you need will able to respond. My
experiece is with SusE Linux 7.0 and release Mysql-3.23.32-1
OK, here is the story.
I have a PII Linux RedHat 7.0 server. I installed the Mysql package that
comes with it and also the dependent applications as specified.
I try to start the mysqld and it gives me an OK and then I status it and
it says
mysqld dead but subsys locked
I am asking
on 3/3/01 4:54 PM, Jonathan Dugan at [EMAIL PROTECTED] wrote:
and I follow what is says:
shell mysql -u root mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
It sounds like you've _already_ set a root password, so you need to specify
it:
mysql -u root -p
Greetings Jonathan,
There are a couple of ways that you can add a user. the best way is to grant
that user permissions on an existing database. If the user does not exist
then it will be created. That's the way I do it because then I don't have to
beg my ISP for insert/update permissions on the
Alec
Exact matches on float values are notoriously unreliable - the problem with
the math is that it can often turn out the value at something like :-
123.539
which won't produce an equality match.
For this you would probably better use a DECIMAL field.
On Sat, 03 Mar 2001 19:51:04 -0500, Alec Solway [EMAIL PROTECTED] wrote:
Try using DECIMAL, this works best for monetary values in my experience.
I'm having some trouble with the following:
I have a sample table that has one record where price == 123.54, however
select * from gpl where
I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the tarball
for Solaris and the RPM for Linux. The BDB tables work as expected on
Solaris, but they did not not work under Linux. What I'm seeing is that I
can create a BDB just fine. However, attempting a rollback results in:
check the archive, someone answered that one this weekend.
Cal
http://www.calevans.com
-Original Message-
From: Joris Kluivers [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 04, 2001 5:56 AM
To: [EMAIL PROTECTED]
Subject: insert + AUTO_INCREMENT
hi,
i have a problem
i have a
Joris Kluivers wrote:
hi,
i have a problem
i have a database table created with the statement:
CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT,
message text, username varchar(100), UNIQUE id (id);
I insert records with:
INSERT INTO chatmessages
Because
TINYINT has a MAX VALUES of 127
pre the mysql docs:
TINYINT[(M)] [UNSIGNED] [ZEROFILL]
A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.
if you unsign the column, you can get to 255
I would use something larger, because you will have more than 255
john1 wrote:
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API program which catched from the MySQL tutorial, it
chokes at the end of compile process . the program is as follows:
#include stdio.h
#include mysql.h
#define def_host_name NULL
I would make the select statement look like this
SELECT Candidate.FIRSTNAME, Candidate.LASTNAME, count(Votes.VoteNumber) ,
count(select votenumber from Votes)
FROM Candidate LEFT OUTER JOIN Votes ON Candidate.CANDIDATENUMBER =
Votes.CANDIDATENUMBER
GROUP BY Candidate.FIRSTNAME,
I think you really need another couple tables, even though your just writing
a sample.
You probably need a table named 'election' and one named
'electionparticipants'
Your election table would contain things like the date of the election, the
total number of votes cast, etc.
The
Hello
Is there a place or book where a newbie can gather information on
indexes?
Section 12.4 of the manual is your friend. "EXPLAIN SELECT foo" will
tell you what indexes are used in doing your "foo" query.
cheers
--
TS
Hello
Please excuse my ignorance, I am very, very new to databases and escpecially
MySql.
I have a couple of questions that I would be most grateful if someone could
answer for me.
1. I have a Cobalt Raq4 with mysql 3.22.32 installed. I also have a Win98
machine with 3.23.33 installed. I have
Please add /usr/local/mysql/bin in your PATH.
dwayne I'm fairly new to MySQL and unix. I have installed mysql on redhat 6.2 without
too many problems. I am changing my o/s to FreeBSD 4.2 and have installed mysql after
many hours of grief. I have mysql set to start at boot time and this seems
"MikeBlezien" wrote:
Hello All,
Was wonder if any knows of a Perl equivalent to the PHP's version of
phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP
installed, and frankly, to lazy to do all the typing thru telnet session! :)
MysqlTool
Looks pretty good
Hi,
Check for open64 in the archives for the last month, and you will find your
answer (which is to upgrade your gcc).
Regards
Quentin
-Original Message-
From: john1 [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 6 March 2001 4:47 a.m.
To: [EMAIL PROTECTED]
Subject: C API problem
dear
Hello,
I'm reading this list for some time and checked the FAQ, archive
but i haven't found any hints ...
I have an own written app which is using a 'kind of database' to
calculate the difference between two (or more) events which can
happen between tens or hundreds of seconds.
Now i want to
Hello
-Original Message-
From: Jon Haworth [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 11:09 AM
To: 'Quentin Bennett'; MySQL (E-mail)
Subject: RE: Just Checking
ping!
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2001 03:04
March 5, 2001
Dear Prospective Colleague,
I will be deeply in debt to anyone who helps me find an internship in Chemical
Engineering for the summer of 2001. I am a Chemical Engineering student at the Cooper
Union in NYC, and I can successfully perform the following scientific assays: Light
SELECT with two (or one) of the three fields - probably with loads of OR's
after the intial search returns 0 rows.
Messy maybe but I don't see any other way.
You can't use a SELECT like you are currently using with fields of the same
name in different tables - I'm surprised you are not
I'm working on the following select statement and have a few problems:
select if(contact.comp_name, contact.comp_name, concat(contact.first_name,
' ', contact.last_name)) as name, if(substring(radacct.username,1,4) =
'brow', lcase(trim(leading concat(substring_index(radacct.username,'-',1),
Hello,
I'm new to mySQL, and I need a binary release for Solaris x86. Unless
somebody knows why I can't compile the source. I'm using the GCC
compiler version 2.95.2.
Here is my configure script:
CC=gcc CFLAGS="-O6 -fomit-frame-pointer -DHAVE_CURSES_H" \
CXX=gcc \
CXXFLAGS="-O6
Hi!
"Jeremy" == Jeremy Hansen [EMAIL PROTECTED] writes:
Jeremy We're doing some mysql benchmarking. For some reason it seems that ide
Jeremy drives are currently beating a scsi raid array and it seems to be related
Jeremy to fsync's. Bonnie stats show the scsi array to blow away ide as
Hi!
"Mike" == Mike Black [EMAIL PROTECTED] writes:
Mike Here's a strace -r on IDE:
Mike 0.001488 write(3, "\214\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56
Mike 0.000516 fdatasync(0x3)= 0
Mike 0.001530 write(3, "\215\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) =
create table root(
create table subcats(
create table subsections(
And now I need 230 levels, huh :).
How about a simple tree structure ?
hth
pa
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Gossamer Threads (http://www.gossamer-threads.com) has an near identical
knockoff written in perl calles mysqlman
- Original Message -
From: "MikemickaloBlezien" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 05, 2001 10:53 AM
Subject: phpMyAdmin equivalent
Hello All,
On Mon, 5 Mar 2001 10:13:29 -0600
"Johnny Withers" [EMAIL PROTECTED] wrote:
Well, if you have everything setup right.. this is easy to do in SQL.
Lets say you have your root table:
[...]
and your sub categories:
[...]
and your final category:
[...]
now you can simply join all
I consider this a bug... other might not.
I have:
.my.cnf:
---
[client]
password
host = mysql.rollanet.org
[mysql]
verbose
---
If I type "mysql" by itself, everything works fine. But if I try to use
"-ppassword" on any tool, it fails. I think that "password" in the config
shouldn't
Would like to install this with cxx not gcc! Made the following adaptation
to website documentation for section 4.12.6:
CC="cc -pthread"
CFLAGS="-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all -arch
host"
CXX="cxx -pthread"
CXXFLAGS="-O4 -ansi_alias -ansi_args -fast -inline speed
On Mon, Mar 05, 2001 at 11:27:54AM -0600, Stephen Faustino wrote:
I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the
tarball for Solaris and the RPM for Linux. The BDB tables work as
expected on Solaris, but they did not not work under Linux. What
I'm seeing is that I can
I am trying to install DBD::mysql on a server which does not have mysql on it. ( The
script will be accessing a mysql
database on another server). The problem is, when I try to install dbd::mysql I am
asked several questions.. one of
which being: what is the path to mysql? I don't have a
Yes, I specified that the table should use the BDB table handler, but it
does not appear that the table was created as a BDB table. The following
are the results of my sessions on Solaris and Linux:
Solaris:
mysql create table test (x int) type = BDB;
Query OK, 0 rows affected (0.46 sec)
mysql
Hello,
Michael Widenius wrote on Monday, March 05, 2001:
I wonder from where the fdatasync() is comming; MySQL is not doing
those (if you are not running mysqld with --flush)
The call is either a fsync or an fdatasync that is done by Berkley DB on the
transaction log.
Regards,
Chris
On Mon, Mar 05, 2001 at 10:34:38AM +0100, Piotr Szybiak wrote:
I am a 5th year student of University of Technology in Poznan
(Poland). I would like to use MySQL in commerce project (Internet
Auction). I will develope my Auction in Linux. Have I buy a licence
from you ??? How many it cost.
In some RDBMS there is something called ROLLBACK.
However, I am not sure if MySQL does support features such as ROLLBACK,
If mySQL doesnt support ROLLBACK then you need to do a recovery from your
previous backups.
On Sat, 03 Mar 2001, Pål Wester wrote:
When you delete somthing... is there
show variables showed that have_bdb is no, and none of the bdb variables are
there. So does this mean that BDB is NOT compiled into the binary included
in the Linux RPM, or does it mean that I need to add the necesary
BDB-related variables to /etc/my.cnf?
Stephen L. Faustino
Senior Software
Hi,
Your main problem will be in storage - datetime fields are only down to the
second, so you will have to store the times as integers, and then do your
own arithmetic on them.
If you stored the time as ('unix time' * 100) + hundreths, then you could
probably still do some arithmetic using the
To all adventure motorcyclists
First I know that a lot of you didn't request information from me and if
you would prefer not to hear from me again please reply to this mail with
unsubscribe in the subject field and you will be removed from this list.
For those of you who are interested in taking
Hello,
I was using C API under mysql-3.22.32. and I was forced to reinstall the mysql servr.
Unfotunately I found only the version 3.23.23.
Thw big problem is that the same sources give me under Mysql C API 3.33.23 the
following
message link error:
In function my_compres_alloc my_compress. o
After install a new proxy (wingate) here I couldn't connect to mysql server remote
in any client machine, only in the machine were is the proxy. Mysql returns error
10065. I tryed to find the error description at the manual and at the site, but I
didnt find. What is error 10065? The person
hello there,
i am a novice, so bear with this rather trivial question.
how do i turn off the column-headers for select statements in mysql??
couldn't find any help with the online manual.
waiting.
praveen
-
I was looking through my website and everything was fine and then all of a
sudden I got this error:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
It was working fine, and now for some reason won't connect? Any suggestions
how to fix this and why it would
1 - 100 of 135 matches
Mail list logo