Nick,
Tuesday, April 09, 2002, 5:21:00 PM, you wrote:
NS> Is there a way to store files in MySQL? Looking to store somthing like a
NS> zip file in the databaseand be able to retrieve/download it from something like
ASP.
Yes, you can store files in the BLOB fields. You can find some info
about B
Hello,
I have simple question.I have installed on my computer WinNT 4.0, Apache 1.3.14, PHP4
(4.0.4pl1), MySQL MAX 4.0.1. There's problem with char set win1250. I don't know how
can I link this char set. Script with this row $spojeni = MySQL_Connect("localhost");
sends an error Warning: MySQL
I purchased a book entitled "PHP3 programming browser-based Applications" it
came with a cd that contained a copy of MySql-3.22.16a-gamma for any linux
distribution. Anyhow, I am having problems installing the software on my SuSe
7.1 linux box. Basically, there are eleven steps that the autho
I purchased a book entitled "PHP3 programming browser-based Applications" it
came with a cd that contained a copy of MySql-3.22.16a-gamma for any linux
distribution. Anyhow, I am having problems installing the software on my SuSe
7.1 linux box. Basically, there are eleven steps that the autho
Hi,
I am geeting an error Unexpected
Exception: java.io.IOException message given: Unexpected end of input stream
Is there any limitation on the length of the query string (In mm.mysql
driver?)? Can any one help me out to avoid this error.
LOG:
SELECT
PURCHASE_ORDERS.ORDER_ID,PURCHASE
I have a performance question between having
a single database for all tables or splitting up tables
into multiple databases.
The hosting service I use charges extra for multiple databases.
Using PHP/MySQL for website.
I currently have 12 tables in one database. Are there any
performance advant
On Wed, 10 Apr 2002 [EMAIL PROTECTED] wrote:
> I use MySQL server replication last month, but currently I stopped using
> it...coz for some reason
>
> 1.my master server is running on windows 98 platform, I cant prevent
> it from hanging-up
> 2.my slave server is running on windows 98 al
ERWIN may be able to reverse engineer via an ODBC
connection. Particularly, ERWIN can infer relationships via explicit
foreign key constraints, or via similar column names, or indices.
You should have started with model. Kudos to your boss for calling you on it.
At 09:14 PM 4/9/2002 -0700,
Check the Contributed Software page:
Contributed software - http://www.mysql.com/downloads/contrib.html
APIs
Clients
Web Tools
Performance Benchmarking Tools
Authentication Tools
Converters
Using MySQL with Other P
To start MySQL, are you using, minimum, the following?
./safe_mysqld &
2.4.2 Problems Starting the MySQL Server
http://www.mysql.com/doc/S/t/Starting_server.html
2.4.3 Starting and Stopping MySQL Automatically
http://www.mysql.com/doc/A/u/Automatic_start.html
C:~
-
On Wed, 10 Apr 2002 03:59:22 +
"saraswathy saras" <[EMAIL PROTECTED]> wrote:
> hi everybody,
>
> i have problem with storing chinese word to databaseall the chinese
> automatic change to code like this 算盘。 its not only
> waste the space, also i have problem to display it...sometime, some
Check the documentation:
6.2.6.1 Storage requirements for numeric types
http://www.mysql.com/doc/n/o/node_365.html
C:~
-Original Message-
From: Son Nguyen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 6:30 PM
To: [EMAIL PROTECTED]
Subject: Range of MEDIUMINT,
The "web application" is running in an environment *outside* of the server,
compared to your context, which may be 'root@localhost', for instance.
The browser's context, then, might be '[EMAIL PROTECTED]'; thus, you will
need to add an entry to m,ysql.user table.
C:~
-Original Message-
hi everybody,
i have problem with storing chinese word to databaseall the chinese
automatic change to code like this 算盘。 its not only
waste the space, also i have problem to display it...sometime, some of the
word not complete and also display symbols.is there anybody can help me?
Please
I use MySQL server replication last month, but currently I stopped using
it...coz for some reason
1. my master server is running on windows 98 platform, I cant prevent
it from hanging-up
2. my slave server is running on windows 98 also, I cant prevent it
also from hanging-up
3. if
> I need to know how many total reviews are in my table for each category
> name, im using this query and it doesn't work:
>
> SELECT SUM(name) AS articletotal WHERE category = 'Processors'
Try
SELECT count(name) AS articletotal FROM tablename WHERE category =
'Processors'
Sincerely,
Craig Vi
i got a MySQL database that my supervisor wats me to do an ER diagram
for. The problem is that there is no/not much documentation on this
database. Also one cannot draw an ER-Diagram by looking at the mySQL-
Database, since there is no way (i know of) i can defining logical
relationships especi
When a slave crashes or reboots, it should start replicating from where it
left off--at least ours do work that way. The current replication state
is saved in master.info on the slave and when it starts up again, it
should read that file and resume reading the binlog on the master where it
left o
It seems that an internet connection from a browser to my unix/apache hosted
mysql database presents itself as some user to whom I haven't yet given
permissions because the calling web page gives up without a whimper. I have
generous permissions for 'root', 'nobody' and 'localhost'. The perl scrip
G'day Son Nguyen
> Do anybody knows the range of MEDIUMINT, and BIGINT type to use
> when I do the create table in mySQL ?
>From the manual at http://www.mysql.com/doc/C/o/Column_types.html
MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL]
A medium-size integer. The signed range is -8388608 to 8388607
I have two mysql servers in a machine. OS is linux and system is dell.
I ran the servers in a separate datadir, socket and port yesterday. But
after six hours from the start two of them corrupted accidently.
I ran two servers from remote terminal. And there was no problem until
I exited from the
Do anybody knows the range of MEDIUMINT, and BIGINT type to use
when I do the create table in mySQL ?
Son Nguyen
sql, query
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
-
Do anybody knows the range of MEDIUMINT, and BIGINT type to use
when I do the create table in mySQL ?
Son Nguyen
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
-
Benjamin Pflugmann <[EMAIL PROTECTED]> writes:
> Hello.
>
> First, key_buffer=16M seems a bit low for me with 13 million rows
> (well, depends on the indexes, and how much free memory you have, of
> course).
1 gig, plenty free.
> If I am not mistaken, sort_buffer/tmp_table_size are the one mo
Hey Guys,
What is the command to add up the amount of rows in a total?
I need to know how many total reviews are in my table for each category
name, im using this query and it doesn't work:
SELECT SUM(name) AS articletotal WHERE category = 'Processors'
mysql
Thanks!
--
Thanks, but what I need to do is have
make install install everything into /home/turner/mysql/test then I'll
check everything out to make sure it is how I want it and last I'll copy it all
to /usr/local.
Any way to do this
./configure --prefix=/usr/local (default)
make
make install prefix=/ho
On Tue, Apr 09, 2002 at 05:30:06PM -0700, David Turner wrote:
>
> I would like to make install to my home directory but can't seem to get it to
> work.
>
> make install prefix=/home/turner/mysql/test
>
> It keeps wanting to install to /usr/local even though I pass the
> prefix parm.
./configu
I would like to make install to my home directory but can't seem to get it to
work.
make install prefix=/home/turner/mysql/test
It keeps wanting to install to /usr/local even though I pass the prefix parm.
Thanks, Dave
-
Be
Hello.
First, key_buffer=16M seems a bit low for me with 13 million rows
(well, depends on the indexes, and how much free memory you have, of
course).
If I am not mistaken, sort_buffer/tmp_table_size are the one mostly
needed for this query, I think. Btw, you can get more info about the
query wi
Hi.
For what I know, MySQL always reads a whole row if it has to read the
row at all. So, no, column order should not matter at all.
With MyISAM tables, indexes are in a seperate file, build their own
way. So no, also no influence. I don't know enough about InnoDB to say
something for sure, but
Hi.
Is there a chance that you make this behaviour dependend on the --ansi
switch? I never used foreign keys until now, but from the theory I
would expect that a missing "not null" declaration on a FK declaration
should either be implicitly assumed or result in an error - at least
on insert.
I m
On Mon, Apr 08, 2002 at 01:32:59PM +0200, ddd wrote:
> HI,
>
> I want to insert into db 200.000.000 records of type (int6,int6)..
>
> the structure is:
> CREATE TABLE word_page (
>IDword mediumint(6) NOT NULL default '0',
>IDpage mediumint(6) NOT NULL default '0',
>KEY IDword (ID
On Mon, Apr 08, 2002 at 08:25:01AM -0700, MySQL Newsgroup wrote:
> 1. Use PostgreSQL.
Why?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 61 days, processed 1,654,104,995
On Tue, Apr 09, 2002 at 10:15:12AM +0200, paul wrote:
> Hello all,
>
> I have setup a replication between two MySQL v4.01a servers on
> FreeBSD, which works really fine. The only problem is that since we
> have MANY updates on the master database, the bin-logs grow very
> fast. We need to do a ma
Heya:
in openBSD I have a cli interface for simple i/o to mysql database.
Written in C.
it works perfectly.
On Darwin and OS X it won't compile.
It gives the following errors.
$ cc -lmysqlclient -I/usr/local/mysql/include testmy.c linklist.c
/usr/bin/ld: Undefined symbols:
_mysql_close
_mysql_e
I have one query, that basically reads from one table of 13 million rows,
groups it by two fields, and inserts into a rollup table. The result set
ends up being about 31,000 rows. This runs in about 2 minutes which is
acceptable. However, I add an additional group by field, which will probably
Yes there is.. You can use LIMIT keyword to do so. For example to get the
records between 3 and 5, you could issue the statement:
SELECT * FROM content ORDER BY id LIMIT 2, 3;
See: http://www.mysql.com/doc/S/E/SELECT.html
Gurhan
-Original Message-
From: lance turner [mailto:[EMAIL PROT
After executing a query such as:
SELECT * FROM content ORDER BY id
I there a SQL query for skipping ahead a certain number of records?
Or should this be done as part of the initial query? If so, how?
thanks,
lance turner
-
B
Argh. my email got prematurely sent, sorry.
mySQL C++ API is available at
http://www.mysql.com/downloads/api-mysql++.html (along with a quick
tutorial)
Mike
-Original Message-
From: Mike Grabski [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 5:00 PM
To: 'Guy-Maurice Lepoutre'
Hi !!
> -Original Message-
> From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 1:39 PM
> To: Guy-Maurice Lepoutre; [EMAIL PROTECTED]
> Subject: Re: Creating a mysql database usinc VC++
>
>
> On Tuesday 09 April 2002 2:30 pm, Guy-Maurice Lepoutre wrote:
You can, using the c++ api
-Original Message-
From: Guy-Maurice Lepoutre [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 4:30 PM
To: [EMAIL PROTECTED]
Subject: Creating a mysql database usinc VC++
Hello,
I wondered if there is a way to create a mysql
database using Visual C++
On Tuesday 09 April 2002 2:30 pm, Guy-Maurice Lepoutre wrote:
> Hello,
>
> I wondered if there is a way to create a mysql
> database using Visual C++ 6.0. I don't want the
> database to be registered, I want the program to
> create the database for me.
Certainly. If by no other way, execute a ba
Hello,
I wondered if there is a way to create a mysql
database using Visual C++ 6.0. I don't want the
database to be registered, I want the program to
create the database for me.
Thanks a lot for your help.
__
Do You Yahoo!?
Yahoo! Tax Center - on
When compiling Mysql on a Dec 3000 OSF1 V4.0 I get the following error:
...
net_serv.cc:421" macro ' thr_alarm' used with to many {3} args
Make[3]: [net_serv.o] Error 1
I've used this to configure, but changes the O3 to O like other
documentation has said to do:
env CC="cc -pthread" C
Hi !!!
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 12:40 PM
> To: [EMAIL PROTECTED]
> Subject: MyODBC on win98
>
>
> hi,
> i'd like to know which ODBC driver is most suitable, fast and reliable for
> win98.
> I tried myodbc 2.5
Hi !!
> -Original Message-
> From: Ralph Walther [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 12:43 PM
> To: [EMAIL PROTECTED]
> Subject: download latest odbc-driver
>
>
> hi,
> if i try to download the latest odbc driver i get a file with 43k. what
> is wrong ? the origin
On Tuesday 09 April 2002 2:13 pm, Andrew Hazen wrote:
> Hi,
> Can I use the MD5 function in the where clause, as in:
>
> Select * from table where md5(column)=value
>
I see no reason why not but note that you are likely MUCH better off storing
column as an MD5 hash, computing the MD5 of val
Hi,
Can I use the MD5 function in the where clause, as in:
Select * from table where md5(column)=value
spam filter: mysql
Andrew Hazen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Kathy,
Tuesday, April 09, 2002, 5:43:23 PM, you wrote:
KR> I am using Linux 7.2 OS.
KR> I think reseting the root password fixed it. Because I was no able to log
KR> in.
Ok, try to reset root password according to step-by-step instruction
in the manual. Don't forget execute FLUSH PRIVILEGES _bef
Sorry, this came out ugly. I misinterpreted the list filter's
comments, and thought it would post my original message if I replied
to it, but instead it posted my reply including its warning.
Here's my original question, which is indeed about MySQL, although it
does not contain the words "SQL" o
hi,
if i try to download the latest odbc driver i get a file with 43k. what
is wrong ? the original file on
http://www.mysql.com/downloads/api-myodbc-3.51.html is over 602K...
what have i to do?
-
Before posting, please check
References: <[EMAIL PROTECTED]>
From: Scott Gifford <[EMAIL PROTECTED]>
Date: 09 Apr 2002 15:40:38 -0400
In-Reply-To: [EMAIL PROTECTED]'s message of "Tue, 9 Apr 2002 21:28:35 +0200"
Message-ID: <[EMAIL PROTECTED]>
Lines: 33
User-Agent: Gnus/5.0807 (Gnus v5.8.7) Emacs/20.7
MIME-Version: 1.0
Content
hi,
i'd like to know which ODBC driver is most suitable, fast and reliable for
win98.
I tried myodbc 2.50.39, but the dll was faulty, i had to replace it by the
2.50.36(on win2k!).
On win98 now am using the latest 3.51.01, but it has slown down the machine
so much, it's incredible.
So now am using
Hi!
>From the changelog of 3.23.50:
* We suppress the FOREIGN KEY check if any of the column values in the
foreign key or referenced key to be checked is the SQL NULL. This is
compatible with Oracle, for example.
It is conceptually a bit strange that we first declare a FOREIGN KEY
constraint, b
FOREIGN KEYs by themselves make it faster and easier to validate that your
code is correctly maintaining referrential integrity.
They also let O/R mappers do more of the work in generating code for
accessing your data (Blatant Plug: http://freshmeat.net/projects/easyorm/ --
EasyORM is an O/R mapp
> -Original Message-
> From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 12:48 PM
> To: Christopher Thompson; [EMAIL PROTECTED]
> Cc: Rance Hall
> Subject: Re: mySQL and innoDB
>
>
> I am just testing mySQL so I will be able to use it instead
> of Oracle S
Carl,
when it runs out of disk space the auto-extend feature prints to the MySQL
error log a complaint that disk space has run out, and stops extending the
file.
If you do not give it more free disk space, InnoDB behaves as if it would
have a fixed size data file. That is, you will get the 'Tabl
On Tuesday 09 April 2002 11:47 am, Alain Del Giust wrote:
> I am just testing mySQL so I will be able to use it instead of Oracle
> Sybase ...
>
> I am not saying a PK can be NULL wich is impossible
> But a FK can be NULL and I'd like to know how to do that with mySQL
I do not see this as being a
I am just testing mySQL so I will be able to use it instead of Oracle Sybase
...
I am not saying a PK can be NULL wich is impossible
But a FK can be NULL and I'd like to know how to do that with mySQL
A concrete example could be:
table employee
column 1 : employee_id - primary key
column 2 : e
Hi,
Try with SELECT VEERSION() from mysql client.
- Original Message -
From: Jianping Zhu <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 9:55 AM
Subject: How to check which version of mysql is installed
>
> I have a
Well, I know I'm gonna catch flak for this, but oh well, here goes anyway
I send an off list mail to Alain to ask for some more specific information about what
he is trying to do so that we can find a way to do it.
But this I will say to the whole list...
What is the point of setting up a refe
At 10:14 -0700 4/9/02, Jim Dickenson wrote:
> >> This still leaves the question as to when version 3.23.49a will
>be compiled
>>> for Mac OS X, instead of version 3.23.47.
>>
>> I always compile my own. Is there some reason you don't do that?
>
>
>There are many messages on this list that say
On 4/9/2002 9:41 AM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 9:31 -0700 4/9/02, Jim Dickenson wrote:
>> On 4/8/2002 7:25 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
>>
>>> At 17:52 -0700 4/8/02, Jim Dickenson wrote:
I am having problems getting the "load data local infile" working.
On Tuesday 09 April 2002 11:07 am, Alain Del Giust wrote:
> "if you have a foreign key constraint, that field must be one of the values
> of the referenced column and that column, being an index, is never NULL"
>
> OK so my understanding is that it is impossible with mySQL to do such
> things wich
"if you have a foreign key constraint, that field must be one of the values
of the referenced column and that column, being an index, is never NULL"
OK so my understanding is that it is impossible with mySQL to do such things
wich are basic with at least:
Oracle
Sybase Adaptive Server Enterprise
... but the key NULL does not exist on the table a, but it should!!!
Adib.
Alain Del Giust wrote:
> Nope
>
> insert into b values ('BBB',null);
> here:
>BBB is PK of table b
>null is FK of table b referencing table a
>
> for example
> insert into b values ('BBB','aaa');
> works well
>
well, your right about one thing, I did misread the order of your SQL statement, but
if you have a foreign key constraint, that field must be one of the values of the
referenced column, and that column, being an index, is never NULL
so inserting NULL into a properly configured foreign key colum
At 9:31 -0700 4/9/02, Jim Dickenson wrote:
>On 4/8/2002 7:25 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
>
>> At 17:52 -0700 4/8/02, Jim Dickenson wrote:
>>> I am having problems getting the "load data local infile" working.
>>>
>>> I am running Mac OS X 10.1.3 build 5Q110 with all available u
Nope
insert into b values ('BBB',null);
here:
BBB is PK of table b
null is FK of table b referencing table a
for example
insert into b values ('BBB','aaa');
works well
Alain
- Original Message -
From: "Rance Hall" <[EMAIL PROTECTED]>
To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[E
On 4/8/2002 7:25 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 17:52 -0700 4/8/02, Jim Dickenson wrote:
>> I am having problems getting the "load data local infile" working.
>>
>> I am running Mac OS X 10.1.3 build 5Q110 with all available updates
>> installed.
>>
>> I had installed version
The "insert into b values ('BBB', NULL)" statement should fail under the conditions
you describe, BBB was not inserted into the A table, and therefore the foreign key
constraint fails as it should.
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
Hi all,
I am pretty new to mySQL actually I started yesterday.
mySQL with innoDB handles integrity constraints.
I tried :
create table a (
id varchar(3) not null,
primary key(id) )
TYPE=INNODB;
insert into a values ('aaa');
create table b (
id varchar(3) not null,
a_id varchar(3),
i
The server does not shutdown. It just stops responding.
Best Regards
Tommy Jensen
http://www.sc-resources.net
- Original Message -
From: "Miguel Angel Solorzano" <[EMAIL PROTECTED]>
To: "ServiceCenter resources" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 7:
I am playing around with portable sql queries (mysql, oracle and
postgres). When executing:
ipplan=> BEGIN;
BEGIN
ipplan=> INSERT INTO area (areaaddr, descrip, customer) VALUES
(16777216, 'kjshdf', 1) ;
ERROR: Cannot insert a duplicate key into unique index
area_areaaddr_key
ipplan=> SELECT cust
Hi,
I been using mysqlimport for a long time with no problems.
But today when I try (as root)
mysqlimport admin /usr/local/systems/admin/data/person.txt -p
I get
mysqlimport: Error: Can't get stat of
'/usr/local/systems/admin/data/person.txt' (Errcode: 13), when using
table:
person
even thou
On Monday 08 April 2002 10:09 pm, Daniel Jarrett wrote:
> i'm building a table in MYSQL that has about 30 fields..
>
> is this inefficient to have a large number of columns?
Not necessarily, no. Often, it is more efficient.
> if anyone can direct me to some good info on efficient design tips
>Description:
The mysql-test-run script uses 'time -p' to time the test scripts on
line 782 of the script. The -p option on this version of Tru64 is
broken though and causes the test script(s) to fail. Since -p is the
the default option for time on this version of
I have a redhat 7.1 server, I want to get rid of the installed mysql
server. How can check which version is installed and how to get rid of it?
Thanks
Jianping Zhu
Department of Computer Science
Univerity of Georgia
Athens, GA 30602
Tel 706 5423900
---
Wild cards do work, but you have to make sure you use the right type. SQL
uses % and I believe _ as
wild cards. I know if you wish to use them in SELECT statements it would
look like: SELECT *
FROM pet WHERE name LIKE "b%" this would return anything from pet where
the name starts with ab.
Go look
I am using Linux 7.2 OS.
I think reseting the root password fixed it. Because I was no able to log
in.
I'm not really running any queries to the mysql database that why i'm not
sure whats causing this problem.
I also cant figure out why when I type mysql it doesnt doesnt use the
password and I alw
Hello everyone
I want to alter 50 tables, and for each the names start with the string
'mak'
Is there an SQL query, so that I can do the change in one command.
I have tried using wildcards - they don't seem to work in SQL.
Thanks in advance.
Aman
__
Is there a way to store files in MySQL? Looking to store somthing like a
zip file in the databaseand be able to retrieve/download it from something like ASP.
Thanks
-Nick
-
Before posting, please check:
http://www.mysq
Hello everyone
I want to alter 50 tables, and for each the names start with the string
'mak'
Is there an SQL query, so that I can do the change in one command.
I have tried using wildcards - they don't seem to work in SQL.
Thanks in advance.
Aman
_
>From my limited experience. I believe your gonna have to split that one
field of alpha and numeric into two fields one for the alpha info and one
for the numeric info. Then you can sort the information the way you want.
Mike
- Original Message -
From: "Luc Foisy" <[EMAIL PROTECTED]>
To:
Heiki,
I have a question concerning the new auto-extending function (which sounds
really cool by the way!). How does it handle the case where it runs out of
disk space while expanding? Will it gracefully handle this scenerio or will
some sort of recovery be necessary?
Carl McNamee
Systems Admi
GOLDEN,
Monday, April 08, 2002, 11:09:36 PM, you wrote:
GS> Would you help me, how to install, setup, and configure MySQL in my server
GS> with O/S windows 2000 server and IIS v. 5
Installation on Windows is covered in the manual, please check
following links:
http://www.mysql.com/doc
Barry,
Monday, April 08, 2002, 8:33:02 PM, you wrote:
BB> I have a system here based on Red Hat's 7.2 distribution and I am wanting to
BB> get MySQL up and running. After browsing your web page it seems that I will
BB> have go to a different version of gcc. Would I be safe to go to the latest
B
Chris,
Tuesday, April 09, 2002, 3:22:00 PM, you wrote:
CL> Still having this trouble with mysql.. Running the mysql_install_db renders
CL> this...
CL> Preparing db table
CL> Preparing host table
CL> Preparing user table
CL> Preparing func table
CL> Preparing tables_priv table
CL> Preparing colu
LeTortorec,
Tuesday, April 09, 2002, 12:17:06 AM, you wrote:
Leoen> I have a table with the following fields:
Leoen> id=autoincrement, int (11)
Leoen> ts_h=decimal
Leoen> ts_pid=int (11)
Leoen> ts_day=text
Leoen> There is a unique record where ts_pid=60 and ts_day="20020328000
Kathy,
Monday, April 08, 2002, 10:10:04 PM, you wrote:
KR> Can anyone tell me how can I uninstall mysql. I have done it again. I have
KR> messed up my permission.
KR> I dont know what is is that i'm doing that makes me loose my previleges.
KR> I keep getting the access denied error
Before un
Kannan,
Tuesday, April 09, 2002, 7:54:07 AM, you wrote:
K> You need to create a user mysql and also create a group mysql and add the user
K> to the group..You will find this in the installation docs..
Using commands of your OS ...
It is described in the MySQL manual in the section 2.2.7 Install
VR> Ryan,
VR> Thursday, March 28, 2002, 7:22:47 AM, you wrote:
RC>> I'm working on a MySQL permissions problem, and would welcome some
RC>> suggestions and/or comments, or to be pointed in the right direction. The
RC>> goals I have are:
RC>> b) Eliminate anony browsing of db's.. and ideally el
Sent: Tuesday, April 09, 2002 2:14 PM
Subject: Re: TIMESTAMP(14) or Bigint ??
> David,
> I could be wrong but since bigint isn't a date or time oriented data
> type I imagine this would be completely useless to you unless you are
> storing unix timestamps.
In fact i'm looking to a way to st
Sent: Tuesday, April 09, 2002 2:14 PM
Subject: Re: TIMESTAMP(14) or Bigint ??
> David,
> I could be wrong but since bigint isn't a date or time oriented data
> type I imagine this would be completely useless to you unless you are
> storing unix timestamps.
In fact i'm looking to a way to st
Hi,
I use all this in the same order and i don't have any problems:
CHECK TABLE
IF (CHECK TABLE!=OK)
{
REPAIR TABLE
}
// i don't use analyze tables
OPTIMIZE TABLE
Before to perform this commands, you must be sure is not any users connected
(show full processlist;)
Hi Richard
I'm writing a web application in PHP with a MySQL backend. I'm a novice at
both PHP and MySQL having started with both about November last year and I'm
also new to programming at large so please excuse any question which may
seem obvious.
The foreign keys are to be used to enforce ref
Hey guys,
Still having this trouble with mysql.. Running the mysql_install_db renders
this...
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
At this point the script locks
David,
I could be wrong but since bigint isn't a date or time oriented data
type I imagine this would be completely useless to you unless you are
storing unix timestamps. You also have the option of using datetime data
types. I'm not quite sure what you are asking nor what difference it makes
Luke,
How exactly will the foreign keys save you time? Please explain.
Ric.
- Original Message -
From: "Luke van Blerk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 9:17 AM
Subject: InnoDB tables
> Hi everyone,
>
> I've been reading up about InnoDB tab
MM.MySQL-2.0.12, a JDBC driver for MySQL was released yesterday. It can be
found at http://sourceforge.net/mmmysql/
Changes include:
- General code cleanup.
- Added getIdleFor() method to Connection and
MysqlLogicalHandle.
- Relaxed synchronization in all classes, shoul
1 - 100 of 114 matches
Mail list logo
