Hi,
I am a newbie to Mysql.
I would like to know how to create a table with
variable length records?
i have an object with following variables:
varchar v, int a, int b, int c.
and i want to store variable number of such objects
into the rows.
varchar v is the primary key.
the entries in the
My computer didn't explode i just wrote that to get attention. My question
is this - I have a database with a table which looks like this -
CREATE TABLE sites
(
ID INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30) NOT NULL,
keywords VARCHAR(200) NOT NULL DEFAULT 0,
description VARCHAR(200) NOT NULL
hi
i am attaching a log file which was generated by the server in starting up mysql
could any please tell me what exactlly the problen is
log file
=
010427 18:25:29 mysqld started
010427 18:25:29 /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld:
Hi,
Since you have over 10,000 member ids it depends on
the exact appln that you have.
If the length of the SQL query increases above a
certain length (i am not sure abt the exact figure),
an error is thrown saying query too complex.
such wont be the case in your former method.
but,
if there
Hi can anyone, please help me!!!
I need to put a MySQL database onto my website???
What do I have to do to make this work???
Is it just 1 file that I have to upload, or do I
have to do something more?
My web-service-provider, have enabled my
website, so that it can run a MySQL database???
Hi,
Ok, the first bug (incorrect COUNT, etc. for MERGE and individual tables)
was fixed some time ago. Though, it is possible that you found another bug,
the probability is low.
I thought I might be encountering actual bugs in the code in my 3.23.32
version. I'd taken a look at the changelog
Hello everyone:
After I have successfully installed mysql server 3.23.37 and connect
to it and do some operations.but I have found that there is a security
hole that other users can use mysql database !!!.
And I have started the server like that:
bin/safe_mysqld -Sg
then
mysqlgrant all
http://www.slackware.com/ (IMHO the best distro)
Other distros:
http://www.suse.com/
http://www.debian.com/
http://www.mandrake.com/
http://www.redhat.com/
etc
A google for download linux would have answered the question for you, BTW.
HTH
Jon
-Original Message-
From: johnd
So would anyone explain to me how can I setup up a good privileges of
mysql server.Thx
Take a look at the manual. It's all there.. as far as I remember..
Bye,
B.
-
Before posting, please check:
I agree with u slack rules, you download slackware and I believe some
other distros too at ftp.cdrom.com
have fun
On Tue, 1 May 2001, Jon Haworth wrote:
http://www.slackware.com/ (IMHO the best distro)
Other distros:
http://www.suse.com/
http://www.debian.com/
http://www.mandrake.com/
[EMAIL PROTECTED] writes:
So, I'd really like to have mysql working on OS X and while there were a
few people trying it out and having difficulty, I have yet to see any
posts of total success.
I'm an experienced MacOS programmer, but I have little experience on
Unix -- so I'm way
hi,
i have a process running in daemon
to maintain a database connection
i am using mysql_ping
before every query
the program is having large memory leaks
is it because of mysql_ping
what happens to previous mysql handler
is it freed or re used
pls reply
munish
Start the server.
Siomara Pantarotto wrote:
Hi all,
When I try to execute mysqlshow under linux I get this message:
$ mysqlshow
mysqlshow: Can't connect to local MySQL server through socket
'/tmp/mysqld.sock'
(111)
$
However when I do the same under NT it works fine
E:\Program
You need to add the table joining information the the where clause so
the join only returns properly joined records.
EX: where ta.id=tb.id
Paul Van Slyke wrote:
Thanks for the response!
The two tables contain different types of information which are related
by a foreign key (orginally
1. Read the manual
2. Read the manual
3. get a book on SQL
Selvin Sakal wrote:
My computer didn't explode i just wrote that to get attention. My question
is this - I have a database with a table which looks like this -
CREATE TABLE sites
(
ID INT NOT NULL AUTO_INCREMENT,
name
Well, if you have to ask, then you are not ready.
You need to discuss this with your ISP.
Thay may have an implementation doc that shows you what you need to do.
In the mean time, get a box, Linux, MySQL, Apache, and PHP.
Read the manuals on all these, and pay special attention to the apache
Stop the server, then myisamchk the index.
Carina C. Zona wrote:
MySQL 3.23.33:
This morning, one of my tables suddenly reported index corruption. I locked
the table, fixed with myisamchk -o, unlocked, and thought the problem was
solved. But it keeps on re-corrupting (I'm not even
First, you don't have an index on 'b', and second, you don't have 'b' in
the where clause, so it would not use it if it had one.
It needs to sort the result set before it can apply the limit.
ryc wrote:
I have a fairly large table (greater than 4mil rows) that I would to preform
a query
hi.
a link to the relevant section of the manual might be more helpful.
http://www.mysql.com/doc/F/u/Fulltext_Search.html
-ravi.
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 9:25 AM
To: Selvin Sakal
Cc: [EMAIL PROTECTED]
Subject: Re:
On Tue, 1 May 2001, Gerald Clark wrote:
1. Read the manual
2. Read the manual
3. get a book on SQL
Selvin Sakal wrote:
My computer didn't explode i just wrote that to get attention. My question
is this - I have a database with a table which looks like this -
CREATE TABLE sites
Mysql does not own its own files, so it can't open them
chown -R mysql /usr/local/mysql/var
or
chown -R mysql /var/mysql
whichever is correct for your system.
aditya shanker wrote:
hi
i am attaching a log file which was generated by the server in starting up mysql
could any please tell
Hello everyone. I am new to this list and hope it's the right one for
my question. This may be really obvious, but I can't seem to figure it
out...so here's the problem:
I have a table that stores network incident report information, IP
address, dates, type of incident, report name, etc. I am
Why not start with the table of contents.
I might have been more helpful, but
I don't think trying to cover lazy with cute is a good approach to life.
Ravi Raman wrote:
hi.
a link to the relevant section of the manual might be more helpful.
Please record the following bug identified on the MySQL server:
1. Hardware: SUN Ultra 10
2. Operating system: Sun Solaris 2.7
2. MySQL server version: 3.23.33
3. Error description:
- The following SQL statement returns incorrect results when is executed
using the 'mysql' client: SELECT
Your mysql database (a system db with the access privileges) has a table called host
which has amongst other files, one called host.frm
It seems that mysqld doesn't have permission to read this file.
Check that the mysqld owner and this file's owner are the same and change accordingly.
regards,
This is straight from 7.7.1 of the MySQL manual:
*
If any column in a table has a variable length, the entire row is
variable-length as a result. Therefore, if a table contains any
variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer
than three characters are changed to
On Mon, 30 Apr 2001, ryc wrote:
I have a fairly large table (greater than 4mil rows) that I would to preform
a query like:
SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50;
I have an index on the table INDEX1( a,b,c );
When running the query as is, it takes around
I installed only mysql-3.23.32-1.7.i386.rpm -- at
ftp://ftp.redhat.com/redhat/linux/7.0/en/os/i386/RedHat/RPMS/ there is no
mysql-client, so I thought maybe the client was included in the same
package. Now that you mention it, I just noticed that in the 7.1 directory
there is a
Hi
Try
select from_days(to_days(curdate())-1);
+-+
| from_days(to_days(curdate())-1) |
+-+
| 2001-04-30 |
+-+
1 row in set (0.00 sec)
Simon
On Tuesday 01 May 2001 14:45,
You are doing a text compare, and they have to match exactly,
including leading zeros after the dots.
You might look at storing them as integers. MySQL has to functions
INET_ATON() and INET_NTOA() to convert them back and forth to strings.
Erica B. Tanner wrote:
Hello everyone. I am new to
This works for me. You will have to translate the javascript to whatever you are using
...
SQL = insert into myTable(field2, field3, field4) values(dat2, dat3, dat4)
var dataConn = Server.CreateObject(ADODB.Connection);
dataConn.open(MM_soCalData_STRING);
var rs1 = dataConn.Execute(SQL); //
I think he may be trying to put a variable number of *fields* in each
record. This of course cannot be done directly. If that is what he wants
he will need to have his own program merge/parse the data into a fixed
number of MySQL fields (columns).
On Tue, May 01, 2001 at 09:53:21AM -0400, Tim
On Tue, 1 May 2001, Thalis A. Kalfigopoulos wrote:
On Mon, 30 Apr 2001, ryc wrote:
I have a fairly large table (greater than 4mil rows) that I would to preform
a query like:
SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50;
I have an index on the table INDEX1(
Hi,
I'm currently writing my final year thesis and i'm in need for some
information on the efficiency of MySQL. If anyone knows a good site, book,
paper etc ... pls let me know. I'm wondering how many request MySQL server
can resolve per second and that kind of things.
Thanks in advance,
Raf
have
returned
20010430.
No, it returned the right value. current_date returns a date of the format
'2001-05-01'. When you do arithmetic on it, it's converted to an integer.
20010501 - 1 = 20010500 so it gave the currect value. If you want to
subtract one day from a date do this:
SELECT
that you use DATE_ADD, I'm quite sure what you have found
is not a bug
20010501 - 1 = 20010500
MySQL sees CURRENT_DATE as the value 20010501 and performs your subtraction
as requested, if you want to subtract a day from today I suggest
DATE_ADD( CURRENT_DATE, INTERVAL -1 DAY )
Or the previously
?
Aurelian:
I suggest that you use DATE_ADD, I'm quite sure what you have found
is not a bug
20010501 - 1 = 20010500
MySQL sees CURRENT_DATE as the value 20010501 and performs your subtraction
as requested, if you want to subtract a day from today I suggest
DATE_ADD( CURRENT_DATE, INTERVAL
I have a table which contains a date column and an order_number column. I
need to formulate a query syntax to return the total number of orders for
each day in a given month (if any). Can someone help me with the syntax
please as I've been stumbling around with it all day without success.
Many
pls don't tell me how I could do this with perl; there's a req for sh.
Have got a bunch of small multi line files that I thought I was reading in ok:
/usr/local/apache/htdocs/rpts/rvd
The first word of ea file is the only thing that makes it in.
Cheers...
pushcontent()
{
SECTIONID=4
THETITLE=$1
Hello Aurelian,
I do the same thing but use the following code and it works fine.
SELECT @myvar := DATE_SUB( CURRENT_DATE, INTERVAL 1 DAY) ;
Edward
5/1/2001 6:45:19 AM, Aurelian Dumitru [EMAIL PROTECTED] wrote:
Please record the following bug identified on the MySQL server:
1.
On Tue, 1 May 2001 09:43:47 -0400 (EDT), Shawn Cummings
[EMAIL PROTECTED] wrote:
I'm looking for an online message forum or mailing list that deals with
Perl/mySQL. Most of the sites I've found are outdated and unused.
Any pointers greatly appreciated.
check out DevShed at
I have a fairly large table (greater than 4mil rows) that I would to
preform
a query like:
SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50;
I have an index on the table INDEX1( a,b,c );
When running the query as is, it takes around 4seconds. If I omit the
DESC
Hi!
On May 01, Basil Hussain wrote:
Hi,
Ok, the first bug (incorrect COUNT, etc. for MERGE and individual tables)
was fixed some time ago. Though, it is possible that you found another bug,
the probability is low.
I thought I might be encountering actual bugs in the code in my
Raf Geusens [EMAIL PROTECTED] wrote:
I'm currently writing my final year thesis and i'm in need for some
information on the efficiency of MySQL. If anyone knows a good site, book,
paper etc ... pls let me know. I'm wondering how many request MySQL server
can resolve per second and that kind
On Tuesday, May 1, 2001, at 04:42 AM, Sinisa Milivojevic wrote:
[EMAIL PROTECTED] writes:
So, I'd really like to have mysql working on OS X and while there
were a
few people trying it out and having difficulty, I have yet to see any
posts of total success.
I'm an experienced MacOS
Thanks to all for the suggestions!!
Turns out, if I use a regular expression instead of a text compare I get the desired
result!! :)
Thanks!
Erica
Gerald Clark wrote:
You are doing a text compare, and they have to match exactly,
including leading zeros after the dots.
You might look at
Ok I was thinking that you had to tell LAST_INSERT_ID the table you wanted
to get the last insert id from. What if you run a web site and you have 10
tables in a database, how can you tell what the last insert id of table 6
was?
Thanks,
Graeme
Because you included a from clause, you got one
Ok now I understand -- it's on a per-connection basis =)
thanks,
graeme
- Original Message -
From: Graeme B. Davis [EMAIL PROTECTED]
To: Gerald Clark [EMAIL PROTECTED]; Braxton Robbason
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, May 01, 2001 1:09 PM
Subject: Re:
hi,
I was reading the manual for the full-text search. It
is really interesting to have a search engine embedded
into the database itself!!!.
Mysql uses the criterias defined by the mysql
developers. Is it possible for the user to specify the
the criteria in his/her program and mysql rank the
Hello,
Has anyone experienced and/or solved this problem on a Linux / Apache / MySQL system?
I'm trying to call mysqlimport remotely over CGI using perl's system command, to
upload and import csv files. Basically everything works except for setting the
'--fields-optionally-enclosed-by'
tyler writes:
cut
Ok. Here's the output to the screen:
./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
Installing Slave Databases
Starting MySQL daemon
Loading Standard Test Databases
Starting Tests
TEST
hi.
your table looks something like this:
table1
-
date(date)
order_number int(6)
...i wasn't sure if order_number is referring to a order table
somewhere...
if there are multiple rows for each day, and you want to add up
order_number for each day, use:
select
On Tue, 1 May 2001, Graham Nichols wrote:
I have a table which contains a date column and an order_number column. I
need to formulate a query syntax to return the total number of orders for
each day in a given month (if any). Can someone help me with the syntax
please as I've been stumbling
I have 2 tables with identical structures. The following sql statement works
fine:
insert into table_2 select * from table_1
but if I attempt to say
insert into table_2 select fieldname_1 from table_1
or any combination of selecting specific fields to be put into the other
table, I get
On Tue, 1 May 2001, ryc wrote:
I have a fairly large table (greater than 4mil rows) that I would to
preform
a query like:
SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50;
I have an index on the table INDEX1( a,b,c );
When running the query as is, it
Does anyone know how to set or change the priority of the mysql service in
Windows-2000 Pro. It runs by default as normal and I would like to make it
low. There doesn't appear to be a command line option or config file option
for this. In addition, I can't change the priority of the service in
Howdy all...
I've run into a strange date problem as of midnight, May 1, 2001 on my
i686 Linux machine running mySQL 3.23.37.
For some reason, queries can no longer compare dates properly:
mysql select count(*) from hit where date NOW()-1135560;
+--+
| count(*) |
do publish any improvements you suggest :)
On Tue, 1 May 2001 10:26:05 -0700 (PDT)
sagar tamhane [EMAIL PROTECTED] wrote:
hi,
I was reading the manual for the full-text search. It
is really interesting to have a search engine embedded
into the database itself!!!.
Mysql uses the
Hi Suzanne,
When you say:
insert into table_2 select * from table_1
alls fine. All the records and fields will get
copied.
But when you say:
insert into table_2 select fieldname_1 from table_1
you are just selecting fieldname_1 from table_1
while
table_2 consists of fieldname_2
It appears that in order to install MyODBC I have to install a compiled
MySQL version so that I will have the shared client libraries, include
files, 'thread-safe-client' and libmysqlclient installed as a shared
library. Is this correct?
Thanks,
bernie lasalle
I have been having repeated problems with mySQL 3.23.36 on Linux (Red Hat
6.0, 2.4.3 kernel).
I think I've got traced the problem but I don't know how to fix it...
At some point after being started one or more of the mySQL threads hang with
the ps status of 'D' (my research suggests this can
I actually read the readme for DBD ;) and found what looks like the cause of
the problem below:
The Error means... that your linker doesn't include libgcc.a. You have
the following options:
a) Either recompile Perl or Mysql, it doesn't matter which.
The important thing is that you use the same
Hello;
I have looked throught MySQL's website and to no avail, was unable to find a
document that has a detailed description of the configurable build options.
ie. --sharedstatedir --localstatedir --datadir
If anyone could point me to a relevant document or web page, I would be
greatful
I've got two mysql servers on two different boxes, both running Linux (Red
Hat 6.2) with 2.2.18 kernels. Both are recent, fresh installs of Mysql
3.23.37, but have data from older 3.23 versions.
For the last week, any time the database does any kind of data loading,
(multiple inserts and
Description:
There are several problems running the mysql-test-run script from
the installed directory if you are installing from a source
distribution.
e.g., if you do as the manual suggests (4.7.1 Quick Installation
Overview)
shell groupadd mysql
shell useradd
I currently have Mysql .36 loaded on RH6.2 intel, installed from tar. How
do I remove the .36 version so I can install the rpm version .37??
This is not an upgrade, I need to replace or recompile mysql - Is there a
Un-Install process to remove the 36 version?
Thank You in advance,
ChrisB
Hi,
I am running a MySQL server on a nice machine (dual pIII 1gHz/1g ram), with
RedHat 7.0. Currently, I am using the rpm version of mysql, which is
3.23.37.
Our database is large, and getting larger, with several tables approaching
the 1gig mark. In addition, the database will be moving to
how does a user set his own password in mysql? I have searched through the archives,
and have found only the 'st password..' command. this does not work. In my case, there
are more then just one host in the user table and the set password command only
changes the localhost entry, leaving me
I am running MySQL (3.23.27 at this point) with Apache1.3.12 and PHP3 on
a PC running Redhat 6.0. My problem has survived upgrades of all
components from earlier versions.
Every PHP page has at least one query to a MySQL database for session
tracking (home-rolled code, not PHPLib or anything
Upgrade to 2.4.4. 2.4.3 had some rwsem issues.
--
Vibol Hou
KhmerConnection
http://khmer.cc
-Original Message-
From: Hunter Hillegas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 2:20 PM
To: mySQL List
Subject: mySQL Hangs with Status 'D'
I have been having repeated problems
I do believe I have these dependencies, why am I getting these errors?
Running RH6.2 / INtel
/mysqlrpm -i MySQL-3.23.37-1.i386.rpm
failed dependencies:
/bin/sh is needed by MySQL-3.23.37-1
/bin/sh is needed by MySQL-3.23.37-1
/usr/bin/perl is needed by MySQL-3.23.37-1
Description: on start, MySQL creates a socket (mysqld.sock), in the /tmp directory by
default, and tries to start
by opening socket mysql.sock. this might be a configuration error. the
following fix worked.
How-To-Repeat:
try to start mysql by running ./safe_mysqld
Fix:
Hi everyone,
I'm trying to backup all the databases from Server_A to Server_B.
I'd issue mysqldump command in server_A to backup every single database, as below :-
mysqldump -uusername -ppassword databases_name file_name
In server_B, i create a new database using the command
Dont use mysqldump to import. Use mysql. I can't remember the exact
syntax, but reference mysql.com for mysqldump, then in the syntax example
for that, they show you how to import it.
Ryan Shrout
Production Manager
Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
(859) 653-3341
-
What is the syntax for UPDATING the results of this select statement? I am
using mySQL 3.22.27
select service.servdef from service, account, user where
account.number=user.account and user.number=service.user and
(service.servdef = 1) and (account.customerof = 6 or account.customerof = 7
or
why not just use the LOAD DATA INFILE option?
Bombardier Systems Consulting wrote:
HELP!!!
I sent a message to this forum a couple of days ago about a problem that I
am having with MySQL 3.23.37 (and now 36) running under RedHat 7.1.
I am trying to use the mysqlimport utility and
Dear Friends ,
The basic problem I face in the new project is to convert the previous Stored
Procedures in MS SQL Database into My SQL . How to Replicate the same in My SQL .
The Front End is VB 6.0 . The Back End previously was MS SQL . Now Client want it to
be in My SQL . Please send the
On Tue, May 01, 2001 at 04:46:39PM -0700, Bryan Coon wrote:
Our database is large, and getting larger, with several tables
approaching the 1gig mark. In addition, the database will be moving
to a dedicated node on a beowulf cluster.
Cool... :-)
For our users, we are not particulary
- Original Message -
From: Bombardier Systems Consulting [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 01, 2001 10:07 PM
Subject: Re: What do I do now?
Thanks!
I assume that I can put that command into a script and feed it to
mysql -options filename
Thanks
79 matches
Mail list logo