Hi,
Not sure if this is a PHP of a MySQL question, so I am sending it to both
groups. Basically I have a list of numbers with two decimal places in the
MySQL database, but I only want to display some of them with the decimal
points.
i.e.
70 (not 70.00)
87
51.5
46.75
12
29
5.5
-1
45
I know it's
Hello.
On Tue 2002-12-10 at 21:30:21 -0800, [EMAIL PROTECTED] wrote:
> Hello,
>
> I am wondering about the case where a client sends
> mysql_query("commit")
> but never gets a response.
>
> Is the transaction complete, or not? Perhaps the "commit" was lost in the
> network -- but, on the othe
Yes, you certainly needs to chown the files to the specific user id's for
filesystem quota to count the files in the user's quota.
This will solve your quota needs, although I see many potential problems:
- The mysql daemon needs to have access to the files.
An easy solution is to chgrp mysql t
Hello Paul,
I am only lobbying, not demanding.
Paul Dubois wrote:
> Mmm, how do you know how much effort it would be?
> Have you implemented it?
Ok. IMHO it would be relatively easy for MySQL to implement, judging by my
experience dealing with Monty and his source code (specifically, the myisam
Hello.
On Tue 2002-12-10 at 16:05:05 -0800, [EMAIL PROTECTED] wrote:
> I am just working on mySQL and create two tables, defined licenseID is
> the primary key in license_info, and foreign key in license_data.
> But I tested it didn't work the way as like in Oracle delete cascade or
> update casca
Hello.
On Tue 2002-12-10 at 13:50:04 -0800, [EMAIL PROTECTED] wrote:
>
> Would like to ask people's thoughts on whether Perl or
> PHP has higher performance with MySQL. I've heard
> rumours that DBI is slower than the PHP MySQL driver.
> What's your experience?
The speed difference (if any) is so
At 11:00 PM 12/10/2002 -0600, Paul DuBois wrote:
Yes, a single bulk insert will be faster.
Also, the reason your "multiple statements separated by semicolons"
approach fails with a syntax error is that the client server
protocol does not allow you to send multiple statements in the
same string.
Hello,
Iam compiling custom2.cc from 'examples' :
"g++ -I /usr/include/sqlplus custom2.cpp -I /usr/include/mysql -lsqlplus
-lmysqlclient -Wno-deprecated "
Receive compile errors with stock datatype. Iam unable to find stock in any
of the including
libraries. Can someone put some light on this?
Hello.
On Tue 2002-12-10 at 05:59:00 -0800, [EMAIL PROTECTED] wrote:
> 2 questions...
>
> My tutorial db has a number of tables in it... some
> with data... some with no records.
>
> 1 - How can I ask MySQL to tell me the number of
> records in my tables?
> ..a) all at once? Meaning one command
Hello.
As a side note, did you try the precompiled binary for HP-UX already?
http://www.mysql.com/downloads/mysql-3.23.html
On Mon 2002-12-09 at 08:22:44 -0800, [EMAIL PROTECTED] wrote:
> Benjamin,
>
> Thanks for you information, now I tried to use "gcc"
Which version?
> compile:
> CC=gcc CXX
Hello.
On Sat 2002-12-07 at 13:35:03 -0500, [EMAIL PROTECTED] wrote:
>
> I found that kill -9 seems to be the only way to kill the hung process.
> I'll see if I can find another way.
OK. Sorry about my over-reaction, but it was not obvious from your
mail that nothing else worked. Rather a bit to
Hello,
I am wondering about the case where a client sends
mysql_query("commit")
but never gets a response.
Is the transaction complete, or not? Perhaps the "commit" was lost in the
network -- but, on the other hand, perhaps the server committed the
transaction and the reply was lost in the net
Hello.
On Sat 2002-12-07 at 10:14:57 -0800, [EMAIL PROTECTED] wrote:
> I have the binlog files stored to a separate drive (actually a partition on
> a drive other than the raid array for the tables). When this partition
> becomes full, mysql's load average goes from 1.5 to 25 and stays there unti
At 13:23 +1100 12/11/02, Stephen Brownlow wrote:
"Egor Egorov" <[EMAIL PROTECTED]> wrote on December 05, 2002:
What do you mean "disable database"?
Ask the MySQL server to Flush it, then not access its tables until further
notice.
You can't "turn off" the database..
Can this please be wr
At 15:39 -0800 12/10/02, Matt Solnit wrote:
===
Bug report -- MySQL v4.05a, binary distribution
===
--
Machine specs:
--
Compaq Presario desktop
Windows XP Professional SP1
.NET Framewo
Well hows it spoes to work with disk qoutas if u dont chown it to the user
id??
/Steve
- Original Message -
From: "Dean Harding" <[EMAIL PROTECTED]>
To: "'Steven Adams'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 7:32 AM
Subject: RE: Quota Support
> Why w
At 15:07 -0500 12/10/02, Michael She wrote:
Apparently, aren't bulk inserts faster?
I'm currently looping my insert statements, but from what I read, a
single bulk insert should be faster?
Can anyone confirm this?
Yes, a single bulk insert will be faster.
Also, the reason your "multiple sta
Hello,
BTW the ^ symbol means "search at the very beginning of the string"
or maybe SELECT * FROM `table_name` WHERE Email REGEXP "(^[a-z0-9]+)\@(.*)
this puts the name in $1 and the domain in $2, if you are running
the select from a perl script -
:-)
Jim
-Original Message-
From: Rober
"Egor Egorov" <[EMAIL PROTECTED]> wrote on December 05, 2002:
>
> What do you mean "disable database"?
Ask the MySQL server to Flush it, then not access its tables until further
notice.
> You can't "turn off" the database..
Can this please be written? It offers big benefits for little effort.
Try starting mysqld with /etc/rc.d/init.d/mysqld.
And if you want to start it at boot, link to /etc/rc/d/rc3.d(or
rc5.d)/S98mysqld or something like that. RedHat has a program to write the
link for you, but I cannot remember what that is, sorry
Regards
Richard KHOO Guan Chen
On Tue, 10 Dec
I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi
in a WinXP box, mostly using InnoDB tables.
Is there a way to know wich rows are lockedin a table? is there a function
that returns if a row is locked, or the rows locked in a table? It can be
done with a UDF?
My questio
I'm developing a site using MySQL and JSP (with Resin).
Everything seems to be jolly the first few times I load a page, but then MySQL just
crashes.
My system is:
- Hardware: Celeron 500, 128MB RAM
- Mandrake 9.0 vanilla
- Resin 2.1.5 (installed as per resin documentation, configured with Apach
Ok finally found the answer after many hours of searching :) Here is the
MySQL query that works great!
SELECT * FROM table_name
WHERE Email NOT
REGEXP "^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}"
Thanks to all that replied!
Rick
"Keep away from people who belittle your a
Hello Richard,
At 05:06 PM 12/10/2002 -0800, Richard Baskett wrote:
>SELECT * FROM `table_name` WHERE Email REGEXP "^[@]";
>But I am doing something wrong, because it's just not working :)
You are searching for an Email field that begins with an @.
Some alternatives:
SELECT * FROM `table_name
> Date: Tue, 10 Dec 2002 11:38:40 -0800
> From: "Grant Cooper" <[EMAIL PROTECTED]>
> Subject: Building Web Pages
> To: "MySQL mailing list" <[EMAIL PROTECTED]>
> Message-id:
<000a01c2a083$bfe3c310$040a0a0a@donatev49iknkl>
> MIME-version: 1.0
> Content-type: text/plain; charset=iso-8859-1
> Content
I would like to search an email address field for all values that do not
have a '@' in them. How would I go about doing this?
So far this query is what I have:
SELECT * FROM `table_name` WHERE Email REGEXP "^[@]";
But I am doing something wrong, because it's just not working :)
Thanks!
Rick
Hello Mike,
The short answer: use Perl, Python, Ruby, etc.
You are pressing the boundaries between a query language (SQL) and a
programming/scripting language (Perl, Python, Ruby, etc.). Scripting
languages as these already have those capabilities and can easily connect
to MySQL an many other d
John,
> Am I mistaken or does 2002-02-31 translate into February 31, 2002?
I see it now -- right there on Page 646 of the MySQL Manual:
| Note that MySQL does no checking whether the date is correct.
| If you store an incorrect date, such as '1998-2-31',
| the wrong date will be stored. If th
I am just working on mySQL and create two tables, defined licenseID is
the primary key in license_info, and foreign key in license_data.
But I tested it didn't work the way as like in Oracle delete cascade or
update cascade.
Did I do something incorrect?
mysql> create table samDB.license_info (
Hello,
The following sql query works very well in version 4.0.1-alpha-nt. However
it returns a null set with the data provided in aBetterLimo.sql in all later
versions (the last one tried was 4.0.5-beta. I hope that this is enough
information. If you would like anymore please feel free to conta
===
Bug report -- MySQL v4.05a, binary distribution
===
--
Machine specs:
--
Compaq Presario desktop
Windows XP Professional SP1
.NET Framework SP2
Problem descript
>Description:
followed instructions in manual to remove existing files in data directory and
replace. on doing so, get errors when i try to start using "sudo safe_mysqld
--user=mysql &". error log reads:
---
021210 17:05:07 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_pat
>Description:
I configure with the line shown at the bottom. There are no erros. I make, with the
following command:
make -s -j 2
There are no erros. Some warnings, but docs say those are to be expected.
However, when I run 'make test' I get the following:
=== be
Hi,
When trying to use 'LOAD DATA LOCAL INFILE' with Apache2.0.43 (running a
module) and MySQL 3.23.53, it returns the error the command is not
supported. This is because the function is disable for security issue, but
when I tried to start mysql with 'c:\mysql\bin\mysqld-nt --local-infile=1'
it s
Matt,
- Original Message -
From: ""Matt Allen"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, December 10, 2002 8:10 PM
Subject: safe_mysqld will not start correctly
>
> Could someone please tell me how to fix this problem:
what happened before this? Did mysqld c
Look up SUBSTRING_INDEX in the mysql manual.
select SUBSTRING_INDEX(colX,' ',-1) from table
is what I think you want. This will return everything after the first
space found. May want to stick an if(...) construct in there for where
you don't want the rows without the spaces (see below).
Then
>From: "amit parikh" <[EMAIL PROTECTED]>
>
>i install binary version of the mysql .
>i skipped first 2 stage while installing (that is creating user & group) and directly
>run binary script file.
>
>when i run this command, i got following error.
>>mysql -u root mysql
>>ERROR 2002: Can't connect t
RE: Bug in GROUP BY/CASE/MAX?
Well, according to my reading/understanding of SQL ANSI'92,
MAX/MIN/SUM/AVG are supposed to eliminate the NULLs from the
set before doing the appropriate calculation...
Bob Diss, [EMAIL PROTECTED]
===
Hi,
In one of my tables I have a column which contains a combination of a string
(characters only), a space and a 1 or 2 letter combination. The string has no
fixed lenght. Like:
abcd ef
bcdefgh i
etc
Now I want to remove the 1 or 2 letter combination from this column into
another col
In the last episode (Dec 10), 'Bob Diss' said:
> RE: Bug in GROUP BY/CASE/MAX?
>
> More info -- it seems that if I change the 'NULL' to ''
> (i.e. the empty string) in the CASE statements, I get the
> result I'm looking for. That is, the query:
>
> mysql> select max(case when col = 1 then val el
Hi,
Would like to ask people's thoughts on whether Perl or
PHP has higher performance with MySQL. I've heard
rumours that DBI is slower than the PHP MySQL driver.
What's your experience? Does anyone know of any
benchmark data comparing mod_perl and mod_php working
with mySQL? Thank you very much.
What is the MAX of a known and an unknown value?
It would be unknown or NULL
'Bob Diss' wrote:
RE: Bug in GROUP BY/CASE/MAX?
More info -- it seems that if I change the 'NULL' to ''
(i.e. the empty string) in the CASE statements, I get the
result I'm looking for. That is, the query:
mysql> sel
RE: Bug in GROUP BY/CASE/MAX?
More info -- it seems that if I change the 'NULL' to ''
(i.e. the empty string) in the CASE statements, I get the
result I'm looking for. That is, the query:
mysql> select max(case when col = 1 then val else '' end) as color
from t group by row;
returns the
> 1 - On a Linux/Apache box,
>
> when you create a MySQL db with tables, etc,
>
> Where does MySQL store the files associated with the
> db?
Generally, /var/lib/mysql. Check your my.cnf
>
> 2 - On subsiquent db's, does MySQL store those files
> in the same directory or each db in a seperate fo
SELECT ... WHERE Category <> 'others'
UNION
SELECT ... WHERE Category='others'
> -Original Message-
> From: Tariq Murtaza [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 10, 2002 7:12 AM
> To: Fred van Engen
> Cc: [EMAIL PROTECTED]
> Subject: Re: Select and Sort?
>
>
> Thanks for h
Hi,
You can check that if the server is running by
executing this:
Show variables like "datadir%"
from mysql.
Bye,
--- Robert Citek <[EMAIL PROTECTED]> wrote:
>
> At 05:35 AM 12/10/2002 -0800, tmb wrote:
> >1 - On a Linux/Apache box,
> >when you create a MySQL db with tables, etc,
> >Where do
NuSphere, or Macromedia Dreamweaver MX.
NuSphere comes with mysql, php, apache, and a few other goodies, this
is a PHP IDE, no GUI to it but very powerful, and it works on both Linux
and Windows.
Everyone should know what Dreamweaver is, but the new MX has extensions
for php too :)
Joe
-Ori
Why would you need to chown it? Your user's won't need to touch the
file at all, so it should be happy being owned by mysql...
I don't know, maybe it won't work... I'm not much of a Unix person -
I've never touched unix since I left university :)
Dean.
> -Original Message-
> From: Steve
Hi,
I have two problems.
1. The link for downloading MySQL 3.23.53a HP-UX 11.11 is incorrect, it
points to the 10.20 download.
2. The download says MySQL 3.23.53a HP-UX 11.11 but I need support for HP-UX
11.00 with the 11.11 port work on 11.00 or am I out of luck?
Cheers,
Jo
Oh yeah, sql, que
Macromedia Dreamweaver or Microsoft Frontpage would be the best
choice. However, they are both expensive.
Macromedia Dreamweaver MX has some database tools built into allow you to
build simple data driven webpages.
At 11:38 AM 12/10/2002 -0800, Grant Cooper wrote:
Does anyone know of a packa
Apparently, aren't bulk inserts faster?
I'm currently looping my insert statements, but from what I read, a single
bulk insert should be faster?
Can anyone confirm this?
At 02:49 PM 12/10/2002 -0500, Fernando Grijalba wrote:
Why do you have to do it that way?
Could you do it in a loop?
Do
I saw the same behaviour when the mysql database did not exist in the
directory listed by "Starting mysqld daemon with databases from
/var/lib/mysql". If the RPM installation put the db somewhere
besides "/var/lib/mysql" you may need to edit the /etc/my.cnf file
to specify the correct loca
> Does anyone know of a package that computer novices can use to build simple
> web pages. Even if they know nothing of HTML?
>
> I'm using mysql and I figure there might be something out there all ready
> built. This is for a small college that teachers can use to put on there
> stuff.
>
typo/g
Hi,
I have problem with charset (MySQL + Delphi).
--
SET CHARACTER SET cp1250_latin2;
SELECT * FROM en1 WHERE en1 LIKE 'worm';
--
This query works right in PHP and command line (Linux, Windows),
but in Delphi7 (Kylix3)
I'm trying to setup mysqld on our new server, and I'm having trouble getting
mysqld to run. I use:
> safe_mysqld &
and these lines are entered into /var/log/mysqld.log:
021210 14:47:11 mysqld started
021210 14:47:11 Can't start server : Bind on unix socket: Permission denied
021210 14:47:11 D
Why do you have to do it that way?
Could you do it in a loop?
Do Until rst.EOF
dbConn.Execute("INSERT STATMENT");
Loop
JFernando
** sql **
-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: December 10, 2002 13:55
To: Fernando Grijalba
Cc: MySQL Help
Subject:
Does anyone know of a package that computer novices can use to build simple
web pages. Even if they know nothing of HTML?
I'm using mysql and I figure there might be something out there all ready
built. This is for a small college that teachers can use to put on there
stuff.
This is a Cartesian product, not a join.
You may have intended to join on vendor_number,
but they are not the same number of digits.
James E Hicks III wrote:
Is this query legal?
select distinct purchase_orders.header.vendor_number as number,
vendor_master.address.sequence_name as name from pur
Brian Reichert wrote:
Step 3: run that actual invocation of mysqld, with all of it's
arguments, without redirecting the output anywhere. This is, to
say, avoid this at the end:
>> $err_log 2>&1
As an aside to that, I invoke mysqld directly as well, but from
supervise's run script. See ht
Ervin,
- Original Message -
From: "Ervin Gerke" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 8:53 PM
Subject: RE: InnoDB crash?
> Heikki,
>
> That's all mysqld reported in err log. In fact I wasn't able to do a
> check table since mysqld d
Is this query legal?
select distinct purchase_orders.header.vendor_number as number,
vendor_master.address.sequence_name as name from purchase_orders.header,
vendor_master.address where purchase_orders.header.branch = 10
With these DB's
# Database : `purchase_orders`
# -
Bug in GROUP BY/CASE/MAX?
I'm seeing a strange result when I group rows and using CASE and
MAX() to select the column I'm interested in (typical pivot-table
operation). Here's my sample case:
mysql> -- create table
mysql> create table t (row int not null,
col int not null,
Hi,
That is how I currently submit my statements, but can't I go:
Hi, that is how I execute my current statements.
But can't I submit multiple statements like:
"INSERT INTO tblname(fld1) VALUES(val1);INSERT INTO tblname(fld1)
VALUES(val1);"?
If I submit multiple statements I get a SQL error.
Why is mysqldump grossly inefficient. I thought this was the standard to
backing up a mysql database. I use dump / restore to back up my hard drive.
Would this be a better option to do a separate dump on the mysql database?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTE
On Tue, Dec 10, 2002 at 01:28:13PM -0500, Lefevre, Steven wrote:
> Hey folks -
>
> Linux newbie here.
>
> I have RH 8.0 installed on a machine. I did an RPM installation of MySQL
> 3.23 (or whatever the current 3 series is).
>
> When I try to start the safe daemon, I get this:
>
> [root@server
>Description:
Com_select not increment when used QUERY_CACHE and if query exists in cache
>How-To-Repeat:
1. enable QUERY_CACHE
2. Run 2 equal SELECT statment
>Originator:Andrew Sitnikov
>Organization:
Infonet Ltd.
>Severity: non-critical
>Category: mysql
>Class:
Before I get 1000 RTFMs,
I found on google references to an error file. I did a search (after
rebuilding the 'locate' database) and found no error file! :(
Also, no results returned on the mysql mailing list archive.
- Original Message -
From: "Lefevre, Steven" <[EMAIL PROTECTED]>
To: <
Hey folks -
Linux newbie here.
I have RH 8.0 installed on a machine. I did an RPM installation of MySQL
3.23 (or whatever the current 3 series is).
When I try to start the safe daemon, I get this:
[root@server ]# /usr/bin/safe_mysqld
Starting mysqld daemon with databases from /var/lib/mysql
021
Could someone please tell me how to fix this problem:
021210 12:50:49 mysqld started
021210 12:50:52 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 2785410520
InnoDB: Doing r
Have you try this:
dbConn.Execute("INSERT INTO tblname(fld1, fld2) VALUES(val1,
val2),(val1,val2),(val1,vla2);")
JFernando
** sql **
-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: December 10, 2002 12:08
To: Fernando Grijalba
Cc: MySQL Help
Subject: RE: ADO Bulk In
>From: Paul DuBois <[EMAIL PROTECTED]>
>
>At 16:04 -0800 12/9/02, tmb wrote:
>>
>>I thought MySQL created a seperate directory for each
>>db & put each db's files in their respective folder...
>
>That's correct.
>
>However, a small complication to my answer:
Another small complication: the individ
Harald Fuchs wrote:
ORDER BY name = "Others", name;
As a more generic alternative, consider adding a smallint 'extrasort'
column (default 0), then you simply assign extrasort -1 (or more) to
force things near the top and 1 (or more) to artificially put things at
the bottom (depending on sor
Carl,
- Original Message -
From: "Carl McNamee" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, December 10, 2002 6:36 AM
Subject: RE: Question about SLAVE STOP
> I know that the slave will honor transactions but how does that effect the
> STOP SLAVE command? Based
Same table, but it shouldn't matter right?
I'm getting a SQL syntax error once I start combining my statements
together. If I submit the statements separately they're OK.
At 09:59 AM 12/10/2002 -0500, Fernando Grijalba wrote:
Are the inserts to the same table or different tables and columns?
Using the sql:
alter table foo add index dex( keycol1, keycol2, keycol3 );
causes a Error 1030 with the annotation "table handler error 12". The particular table
involved has about 15 entries, contains 10 or so varchar() fields with a record
size of O(500) bytes. The table is decla
Ervin,
the assertion in page0page.c line 450 means InnoDB could not move index
records from a page to another page though it always checks that there
should be enough space. I have not seen this assertion fail before.
Did mysqld print a srack trace to the .err log? Can you send me the whole
error
Dear Amit,
> "update lotjobtemp set duedate = (select duedate from
> importparameters);"
In MySQL, you need 2 queries for this:
SELECT @var:=duedate FROM importparameters;
UPDATE lotjobtemp SET duedate = @var;
Most probably, you will want to use a WHERE clause for both statments.
To make this
Hi,
> is there a way to remotely grab the databases (ie mysqldump)
> and have it
> place everything in a different file for every database? or
> has anyone
> written a script to do something like this?
There's propably a more refined way to do this, but this simple hack
should do the trick.
(
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* On Tue, Dec 10, 2002 at 11:04:01AM -0500, [EMAIL PROTECTED] wrote:
>
> I am trying to find the best way to backup my 4.7GB
> database and have unfortunately found out the hard way
> that mysqldump is grossly inefficient. Since 4 web sites
> rely on
Hi.
I have a MySQL database running on a remote web server.
I have a text data file sitting on my PC here.
I want to get the data from the text file to the database and am having
difficulties! I log onto the database and I'd like to issue
LOAD DATA LOCAL INFILE "c:/thedata.txt" INTO TABLE theta
I am trying to find the best way to backup my 4.7GB database and have unfortunately
found out the hard way that mysqldump is grossly inefficient. Since 4 web sites rely
on
the data, shutting it down to copy it is not a good option either. Has anyone used
mysqlhotcopy? The perl doc says it is s
Hi,
I'm planning to use two-way replication for two MySQL-hosts that can't
see each other most of the time. There will be a synchronisation
everyday via ISDN.
Box A is master & slave of box B and v.v.
As long as nothing goes wrong that's fine.
I'll have daily mysqldumps of the db content, so
I am trying to find the best way to backup my 4.7GB database and have unfortunately
found out the hard way that mysqldump is grossly inefficient. Since 4 web sites rely
on
the data, shutting it down to copy it is not a good option either. Has anyone used
mysqlhotcopy? The perl doc says it is s
Paul DuBois wrote:
It may be that the person was thinking of the InnoDB tablespace.
The InnoDB storage handler manages all InnoDB tables within a single
tablespace, no matter which database they come from. But even so,
each database has its own directory, and InnoDB tables do have a .frm
file in
On Sun, Dec 08, 2002 at 12:06:53PM -0800, Richard Reina wrote:
How do I switch from MYISAM to InnoDB? Are there any negative
implication in swithing?
ALTER table TYPE=InnoDB;
It will take twice as much disk space or thereabouts and not support
full text queries.
SQL
--
Michael T. Babcoc
Hi ng!
1. Can i create a database or table and restrict the size of the
database (table)?
2. Can mysql generate a warning when the size of the database almost
reaches the maximum size i previously defined?
3. Can mysql generate a warning when the partion on which the database
is stored runs o
I am having a terrible time getting a text file imported.
I've been working on this for about a week and finally have
given up.
Hi,
I am trying to get a file called mactable.txt imported into a table,
OUI,
which resides in a database called MACTABLE.
Here are the commands that I am using with th
is there a way to remotely grab the databases (ie mysqldump) and have it
place everything in a different file for every database? or has anyone
written a script to do something like this?
dbserver having databases mysql, db1, db2
and creating backup files
mysql.sql
db1.sql
db2.sql
and at differ
Are the inserts to the same table or different tables and columns?
JFernando
** sql **
-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: December 9, 2002 14:56
To: MySQL List
Subject: ADO Bulk Inserts
Hi All,
Does MySQL allow for Bulk Inserts via ADO?
I can get a
At 05:35 AM 12/10/2002 -0800, tmb wrote:
>1 - On a Linux/Apache box,
>when you create a MySQL db with tables, etc,
>Where does MySQL store the files associated with the
>db?
If the database is named foobar, then usually in /var/lib/mysql/foobar
>2 - On subsiquent db's, does MySQL store those fil
At 05:10 PM 12/9/2002 -0500, Beauford.2003 wrote:
>I mentioned in my previous email that I am using PHP, and I have also tried
>putting quotes around $var (many different ways) with no better results.
>REGEXP just gives a syntax error when I do this.
Below is an example of using PHP and MySQL wit
On Tuesday 10 December 2002 07:44, Jason Brooke wrote:
> That's a client-only option, we're not actually having any troubles with
> clients ignoring anything in the binary log - the problem I'm describing is
> that when a database is not first explictly selected, the master refuses to
> write the
On Tuesday 10 December 2002 11:32, Angus Fraser wrote:
> Thankyou Egor
>
> Sorting by the auto_increment_column does return rows in the order they
> were added but I cant get it to do it for two tables.
DATETIME or TIMESTAMP column contains the time row was inserted.
> UNION may work but I am ru
On Tuesday 10 December 2002 12:02, amit parikh wrote:
> i install binary version of the mysql .
> i skipped first 2 stage while installing (that is creating user & group)
> and directly run binary script file.
>
> when i run this command, i got following error.
>
> >mysql -u root mysql
> >ERROR 20
On Tuesday 10 December 2002 07:48, Amittai Aviram wrote:
> Sorry! I meant UPDATE, not INSERT!
>
> UPDATE administrators SET id =
> (SELECT id FROM faculty
> WHERE lastName = "Jones")
> WHERE ordr = 1;
You can use multi-tables updates from 4.0.2
In earlier versions use programming languages.
On Monday 09 December 2002 16:26, Kekette wrote:
> I played with mysqlimport because I must transfer a db from msql to mysql.
> I have 1.600.000 records to transfer. Everything's perfect except when I
> finished the import, I have Warning:16. All the records were transfered.
> So, my question is:
show databases.
-Original Message-
From: Will Standley [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 10:36 AM
To: MySQL List
Subject: How to get MySQL to list current db's ?
I have two sample MySQL db's running on a local Linux box w/Apache...
Once I enter "mysql" from the
2 questions...
My tutorial db has a number of tables in it... some
with data... some with no records.
1 - How can I ask MySQL to tell me the number of
records in my tables?
..a) all at once? Meaning one command to list...
tbl_1 6 records
tbl_2 3 records
tbl_3 0 records
etc
1 - On a Linux/Apache box,
when you create a MySQL db with tables, etc,
Where does MySQL store the files associated with the
db?
2 - On subsiquent db's, does MySQL store those files
in the same directory or each db in a seperate folder?
thanks - tmb
___
Hi All!!
I am writing a .sql file. I want to execute this file
at runtime.
One of the queries is :-
"update lotjobtemp set duedate = (select duedate from
importparameters);"
This query generates an error as
"ERROR 1064: You have an error in your SQL syntax near
'select duedate from impor
tpar
1 - 100 of 114 matches
Mail list logo
