Hi there
I've an Sun Ultra Enterprise 2 desktop that is running a new (Patched)
build
of Solaris 9 with GCC3.2, GNU Binutils (latest) and a few packages like
GNU
Make, GNU sed, GNU tar from sunfreeware
PATH is /usr/sbin:/usr/bin:/usr/local/bin:/usr/ccs/bin:/usr/ucb
LD_LIBRARY_PATH is
Hi there
I've an Sun Ultra Enterprise 2 desktop that is running a new (Patched) build
of Solaris 9 with GCC3.2, GNU Binutils (latest) and a few packages like GNU
Make, GNU sed, GNU tar from sunfreeware
PATH is /usr/sbin:/usr/bin:/usr/local/bin:/usr/ccs/bin:/usr/ucb
LD_LIBRARY_PATH is
So do u mean like this
user home dir = /home/web/users/xxx
then u symlink /home/web/users/xxx/mysql/database1
/usr/local/mysql/lib/database1
chown -R xxx.xxx /home/web/users/xxx/mysql/database1
Wouldent mysql get permissions errors like that?
/Steve
- Original Message -
Hi all!!
I want to Execute an SQL file say c:/Exec.sql through
Java. Hence I need to execute the Mysql command
source c:/Exec.sql. I tried to run the command using
the executeQuery(String sql)function of the Statement
Interface, but it generates SQLException as Syntax
Error.
How do I do it?
What version of MySQL do you use? autoextend is supported since
3.23.50 and 4.0.2
Ahaa, I am using 3.23.49 (came with rh7.3).
Close but no cigar :)
--
ers
-
Anders Nygård
-
Before
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.
UNION may work but I am running ver 3.23.53a so UNION is not available is
there another way to do this in SQL or is it a job for the PHP code to sort
the
Hello,
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 to local MySQL server through socket
Hi All,
I am wondering how to do that.
Suppose we have data like this below
ID Category
-
1 Software Engg
2 Engg
62 Commerce
87 Ecommerce
45 physics
95 chemistry
6 biochemistry
7 math
5 Others
I want to achieve recordset like below (sorting category by Name and
On Tue, Dec 10, 2002 at 03:32:13PM +0500, Tariq Murtaza wrote:
I want to achieve recordset like below (sorting category by Name and
including 'Others' at the end),
I want to do that by single query ;), any idea???
IDCategory
6 biochemistry
62
Thanks for help.
here is another solution for that...
SELECT if (Category = 'others', '999', 0) as priority, ID, Category FROM
TableName
ORDER BY priority, Category
Tariq
Fred van Engen wrote:
On Tue, Dec 10, 2002 at 03:32:13PM +0500, Tariq Murtaza wrote:
I want to achieve recordset like
On Tue, Dec 10, 2002 at 04:12:22PM +0500, Tariq Murtaza wrote:
Thanks for help.
here is another solution for that...
SELECT if (Category = 'others', '999', 0) as priority, ID, Category FROM
TableName
ORDER BY priority, Category
That's right. It has the same problem regarding
Well, I still don't know what was causing the problem exactly, but there
was something in WindowsXP Pro that was killing my connection. I
discovered this by borrowing a notebook computer and putting it on the
same network (running WinXP Home) and sure enough, EVERYTHING worked
(well, I had to use
Got this one after a power failure.
My system is Redhat 7.3, kernel 2.4.18-18.7.x, MySQL-4.0.5a-beta-Max.
Let me know if you need any more information.
err.log reads:
021210 14:00:41 InnoDB: Started
/usr/sbin/mysqld-max: ready for connections
021210 14:00:43 InnoDB: Assertion failure in
Have you looked if there is a problem with page0page.c ?
Simon
-Original Message-
From: Ervin Gerke [mailto:[EMAIL PROTECTED]]
Sent: 10 December 2002 12:07
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: InnoDB crash?
Got this one after a power failure.
My system is Redhat 7.3,
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
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
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
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
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: is
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.
--
For
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 2002: Can't
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
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
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 with
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 files
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
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
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
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
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.
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
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
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
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
-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 the
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.
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
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
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
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?
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 on
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 sort
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 individual DB
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
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
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
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:
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:
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 ]#
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
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.
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,
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`
#
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 died
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 21
As an aside to that, I invoke mysqld directly as well, but from
supervise's run script. See
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
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.
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:
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 Do
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
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.
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
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
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
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,
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: Steven
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
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 does MySQL
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 help.
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 folder?
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
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
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.
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 else ''
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
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]
===
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 to local MySQL
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
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 crash?
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
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:
===
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_path'
===
Bug report -- MySQL v4.05a, binary distribution
===
--
Machine specs:
--
Compaq Presario desktop
Windows XP Professional SP1
.NET Framework SP2
Problem
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
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 (
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
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
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
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
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`
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
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
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
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
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.
You can
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: Robert
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
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 would you
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
1 - 100 of 114 matches
Mail list logo