020206 15:11:47 mysqld started
/usr/pkg/libexec/mysqld: ready for connections
020207 1:02:00 Error in accept: Too many open files
020207 1:06:19 Error in accept: Too many open files
020207 1:10:37 Error in accept: Too many open files
020207 1:14:56 Error in accept: Too many open files
Oops i was a bit hasty, this problem occurs after the mysql has been running
for a little while, kill the mysql and restart it and it can run just fine
again for a while.
Terkel
-Original Message-
From: Terkel Olsen
Sent: 7. februar 2002 09:24
To: '[EMAIL PROTECTED]'
You probably either need to increase the ulimit on file descriptors for that
process, or increase the total number of file descriptors for the kernel.
020206 15:11:47 mysqld started
/usr/pkg/libexec/mysqld: ready for connections
020207 1:02:00 Error in accept: Too many open files
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 2:22 PM
To: Chetan Lavti
Subject: Re: insertion problem !!
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the
hi,
I have two tables as :
please concentrate on domain_id and INDEX
Create table ls_domain
( domain_id INT(4) UNSIGNED AUTO_INCREMENT ,
domain_addr VARCHAR(80),
domain_name CHAR(50) UNIQUE KEY,
domain_port INT(6) UNSIGNED,
domain_ip VARCHAR(15),
created_by VARCHAR(40),
created_date
Hai ,
is there any support of sys_date in mysql which is strong feature in oracle
8.x . i am using MYSQL 3.23 server version .
With Warm Regards
[EMAIL PROTECTED]
JIN INformation Systems(P) Ltd
Voice : 5275300/5097603/5097604/5281822 ext 218
www.jinis.com
With Warm Regards
[EMAIL PROTECTED]
Hi all
How can I take info from one table and print it into a txt file.
the table is (NAME)
and all the names in it I want to print out to a file name virtusertable.
Thanx
Christo
sql,query
-
Before posting, please
hi,
i'm running a big query across a table containing more than 137 million rows comparing
them to another one with about 4000 rows and i'm wondering how long it will still
take...
is there a way to see how many operations have been made and how many are left?
as you can see it already took
Chetan,
the type of the column user_id is different in your two tables: in the
parent table it is UNSIGNED, but signed in the child table. The internal
storage format of a signed integer is different from an unsigned integer.
That is why adding the child row fails.
I changed now InnoDB-3.23.48
Placed At :
Hi all...
I was curious to know if mysql replication would be possible based on specific
rows in
a table rather than the replicating the whole table..
I have a set up which has slaves spread across geographically. and my master has
a
Hi!!!
I am using the Mysql JDBC Driver 2.0.11. I am trying to use the methods
getImportedKeys(), and getExportedKeys()
But it returns an empty result set.
I am using Innodb tables.
Thanks
Amit
-
Before posting, please
Hello,
I am evaluating mySQL 4.0.1-alpha on Redhat Linux 7.2 (RPM version). I am
playing with the new fulltext search features and I have a question
regarding the syntax...
I have created a fulltext index on a field 'Notes'. I'd like to search for
records that have words starting with
Howto backup databases MySQL direct to a Tape Backup.
André Sartori
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hi,
Now(), sysdate().
Anvar.
At 03:02 PM 07/02/2002 +0530, you wrote:
Hai ,
is there any support of sys_date in mysql which is strong feature in oracle
8.x . i am using MYSQL 3.23 server version .
With Warm Regards
[EMAIL PROTECTED]
JIN INformation Systems(P) Ltd
Voice :
Hai,
Where? Here!
is there any support of sys_date in mysql which is strong feature in oracle
8.x . i am using MYSQL 3.23 server version .
Short answer: RTFM 6.3.4 Date and Time Functions
Don't have an Oracle book with me, please refresh my memory of the exact output from
sys_date/you
Check that your file size limit on your machine is more than the
usual 4GB. I have a 23 million row database, and it translates
into 3GB data file, 3GB index file. 1 billion records would never
fit. My record length is about 300 bytes.
If you need more than a 4GB data file, you should check
Not sure if thius is supposed to go here but my version of MySQL
mysql status;
--
mysql Ver 11.15 Distrib 3.23.45, for pc-linux-gnu (i686)
the GRANT command errors out when the domain name has a '-' dash in it.
mysql grant Select, Insert, Update, Delete on X.* to [EMAIL
Hi Christo,
How can I take info from one table and print it into a txt file.
the table is (NAME)
and all the names in it I want to print out to a file name virtusertable.
Would SELECT ... INTO OUTFILE 'file_name' suit you?
(MySQL manual: 6.4.1 SELECT Syntax)
Regards,
=dn
Shankar Unni writes:
And one big reason not: no native Windows port. Or Mac port (though that
has probably changed with OS/X - anyone working on that?).
Cygwin is dandy, but I definitely don't trust a database that uses cygwin
as an emulation layer underneath for basic file accesses..
Re: sql query
Hi,
I want to dump the contents of one table in to another table
which has the same structure in MySQL, with just one column type changed
from VARCHAR to TEXT. Whats the best way to do this?
Paul
-
How is possible to pass a long query to MySQL server with php?
I mean i.e a create table statement with more than 400 chars.
Have I to use shorter create and then alter?
Thanks
Makis
-
Before posting, please check:
Have you tried just putting the querys into a variable and pass the var
along to mysql_query() ? Did it not work?
---
Alain Fontaine
Consultant Developer
VAlain S.A.
Tel: +32-4-2522950
---
-Original Message-
From: savaidis [mailto:[EMAIL
Hello Paul,
Why don't you just use mysqldump to dump the data to a textfile, and then
insert the data from the textfile into your new table?
---
Alain Fontaine
Consultant Developer
VAlain S.A.
Tel: +32-4-2522950
---
-Original Message-
From: Paul
Christo:
Write a query that does what you want to a text file called
virtusertable.sql:
USE databasename;
SELECT name FROM tablename;
Then run the query from the command line (mysql -uusername -p
databasenamevirtusertable.sqlvirtusertable.txt)
Gerald Jensen
- Original Message -
From:
Hi Paul,
I want to dump the contents of one table in to another table
which has the same structure in MySQL, with just one column type changed
from VARCHAR to TEXT. Whats the best way to do this?
Would INSERT...SELECT suit you?
=dn
I want to dump the contents of one table in to another table
which has the same structure in MySQL, with just one column type changed
from VARCHAR to TEXT. Whats the best way to do this?
Would INSERT...SELECT suit you?
=dn
Yes, but it's a big table. Is there a way to do this
Hi All,
To Update current version on my new Redhat LINUX server I uninstalled MySQL
3.23.26 rpm and installed all MySQL3.23.47 rpms.
When I tried to connect through
shell mysql -u root mysql
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2).
Please let me
Hi all,
I would like to know what means the following error in my application:
General SQL Error
[MyODBC][ODBC 3.51 Driver][mysqld-3.21.33b-log]parse error near
'`id`,`dia`,`mes`,`ano`,`pernormal`,`pernoturno`,`totdia`,`local`,`descricao`'
at line 1.
My application was developed in
sreedhar,
Thursday, February 07, 2002, 9:41:24 AM, you wrote:
s Hi ,
s I am already using MySQL 3.23.26, which is available by Redhat LINUX 7.1
s If I would like to update to newer version I found the following
s What is MySQL-MAX.
s RedHat packages (rpm)
s MySQL 3.23.47 Server (i386)
Claire,
Thursday, February 07, 2002, 12:35:07 AM, you wrote:
CF I want to select all entries in my table that in a column with given
CF dates findes all dates inbetween $from_date - $to_date. (These are
CF vars that the user supplies from the HTML-page). I don't know how to set
CF up the
JP,
Wednesday, February 06, 2002, 11:58:49 PM, you wrote:
JA Amendment to that last post
JA I don't think the daemon is starting properly, because I can't run a
JA mysqladmin version - I just get a hung cursor.
JA Does anyone know if there's something that would be stopping mysqld from
Christo,
Thursday, February 07, 2002, 11:52:06 AM, you wrote:
CR Hi all
CR How can I take info from one table and print it into a txt file.
CR the table is (NAME)
CR and all the names in it I want to print out to a file name virtusertable.
See info about mysqldump:
Paul,
RTFM : http://www.mysql.com/doc/I/N/INSERT_SELECT.html
[quote]
INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name [(column list)] SELECT ...
With INSERT ... SELECT statement you can quickly insert many rows into a
table from one or many tables.
INSERT INTO tblTemp2 (fldID) SELECT
Placed At :
Hi..
I have set up a new slave host for my mysql DB..I have just done a create DB on
it and have setup all replication parameters in my /etc/my.cnf..but when i start
the slave i get the following error..has anybody come across
Hi,
Using PHP? If so, this works quite nicely if you pass your dates as unix
timestamps:
SELECT * FROM table WHERE (FROM_UNIXTIME($theMaxTime) col AND
FROM_UNIXTIME($theMinTime) col)
In other words, col needs to be between $theMinTime and $theMaxTime as
in $theMinTime col
I am in a windows 2000 environment. My level of experience is very low so
please be explicit. I am reviewing mySQL as a solution for multiple web
applications and CDROM applications.
I am trying to start the server for the first time using the command:
c:\mysql\binmysqld-max --standalone
Here
sreedhar,
Thursday, February 07, 2002, 3:03:35 PM, you wrote:
s Hi All,
s To Update current version on my new Redhat LINUX server I uninstalled MySQL
s 3.23.26 rpm and installed all MySQL3.23.47 rpms.
s When I tried to connect through
s shell mysql -u root mysql
s Can't connect to local
Andre,
Thursday, February 07, 2002, 1:55:26 PM, you wrote:
AS Howto backup databases MySQL direct to a Tape Backup.
You can directly copy files whitch contain tables from mysql data dir.
You can also use mysqldump to dump your database and then you can
backup result file to a tape. But I think
Not only will mysqldump allow you to work on a specific table, but it will
also allow you to dump directly from one table into another. Sounds like
exactly what your looking for.
You'll need to use the correct syntax to keep it from adding CREATE TABLE
statements, but it's all clear on this
Paul,
I want to dump the contents of one table in to another table
which has the same structure in MySQL, with just one column type changed
from VARCHAR to TEXT. Whats the best way to do this?
Would INSERT...SELECT suit you?
Yes, but it's a big table. Is there a way to do this
Hi all:
I have various mysql tables (innodb type) where I am
inserting values in auto increment columns. The
value inserted into the auto increment columns is null
which automatically means that the table handler
inserts the next higher value in that column.
Problem is, many of these updates
Put quotes around the hostname:
grant Select, Insert, Update, Delete on X.* to X@'X.f-tech.net'
identified by 'X';
Peter
On Thu, 7 Feb 2002, Paul Faber wrote:
Not sure if thius is supposed to go here but my version of MySQL
mysql status;
--
mysql Ver 11.15 Distrib 3.23.45,
Hi,
I'm wondering what the best way is to remove multiple records matching
against multiple instances found in another table. I'd like to avoid using a
scripting solution doing this in a loop.
Let's say I have two address books and there is some cross-over in entries.
I want to delete from
Hi James,
Many of the questions on this list are answered by people like
myself who are users of MySQL. We are busy trying to run our own
servers and put food on the table. That being said, you are
wondering why your question did not get an answer, it may be the
length of the message and
It seems that either your server was started with the --skip-networking
flag, or that it's not listening on port 3306 (check your my.cnf), or your
machine has a firewall installed locally that doesn't allow network
connections to port 3306.
The MySQL command-line client will probably work in any
I am trying to trim both leading and trailing whitespace from a TEXT
column in my SELECT query. I found the TRIM() command in the manual,
however, I can't get it to act upon a column name instead of an
actual string. Can anyone help?
If you just say TRIM(col_name) it will return the
At 9:07 -0500 02/07/2002, Ken Menzel was thought to have said :
Many of the questions on this list are answered by people like
myself who are users of MySQL. We are busy trying to run our own
servers and put food on the table. That being said, you are
wondering why your question did not
WHERE col BETWEEN $from_date AND $to_date ???
-Original Message-
From: Claire Forchheimer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 5:35 PM
To: [EMAIL PROTECTED]
Subject: Extracting fields from a table
I want to select all entries in my table that in a column with
Hi,
more and more frequently we are seeing this error:
Lost connection to MySQL server during query
during queries. I have seen it reported previously on the list, but i
haven't been able to find a remedy. Does anyone have a solution to this?
Any ideas are appreciated.
Thanks,
james
--
The following just worked in a test case for me:
...user@test-test.com...
On Thu, 7 Feb 2002 06:29:59 -0500, Paul Faber wrote:
Not sure if thius is supposed to go here but my version of MySQL
mysql status;
--
mysql Ver 11.15 Distrib 3.23.45, for pc-linux-gnu (i686)
the GRANT
Hi There!
I am using mysql 3.23.41, for redhat-linux-gnu (i386).
My problem is this.
In java, I am trying to extract a blob field from a mysql table - I am
using
Byte[] somebytes = RS.getBytes(FPPICTURE);
String somestring = new String(somebytes);
This gives me a string of the blob
Hi,
can it be that there is a bug in count(distinct(putafieldnamehere)) ?
After restarting the server it runs, but after some time it doesnt return
any result-rows.
A count(putafieldnamehere) runs without problems in this situation.
Thanx for any sugesstions to solve this problem ...
Ok, its not in count(distinct()). It always happends if temptables are used,
but only if the server
runs some minutes/hours/days :(
-Ursprüngliche Nachricht-
Von: Maverick [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 7. Februar 2002 16:48
An: [EMAIL PROTECTED]
Betreff: bug in
Hi Everyone,
I'm newbie with MySQL with some programming experience.
I'm about to implement an Internet shop. I would like to serve my
customers at a high level with, amongst other features, making sure that
every successful order will really be shipped due to a stock availability
check at order
Hello,
can anyone suggest a reasonable value for max_join_size
in MySQL server configuration as default value seems too
large? Clients should be able to run applications like
web forum but I want to prevent them from overconsuming
CPU time.
thanks,
Kirill Magdalinin
[EMAIL PROTECTED]
On 7 Feb 2002, at 8:20, Richard Reina wrote:
I tried both ideas and neither one removed the white spaces. arrr!
:-(
Unfortunately TRIM doesn't remove whitespace (spaces, tabs, carriage
returns, linefeeds), as it does in some programming languages. It
just removes spaces, unless you specify
Hello,
I just had a glance at your log-rotation file, and I think I might tell you about a
possible improvement:
In the file mysql-log-rotate I came across the following test case:
if test -n `ps acx|grep mysqld`; then
/usr/bin/mysqladmin flush-logs
fi
I think
Here is how I do it:
$query = some query ;
$query.=some more of the same query ;
$query.=still more query ;
$query.=and so on... ;
$rst = mysql_query($query);
NOTE: you need to add a space at the end of each line (after the last word
and before the closing quotations) if you plan on
I can't read your structures or query from here.
[EMAIL PROTECTED] wrote:
hi,
i'm running a big query across a table containing more than 137 million rows
comparing them to another one with about 4000 rows and i'm wondering how long it will
still take...
is there a way to see how many
I am in a windows 2000 environment. My level of experience is very low so
please be explicit. I am reviewing mySQL as a solution for multiple web
applications and CDROM applications.
I am trying to start the server for the first time using the command:
c:\mysql\binmysqld-max --standalone
Here
Ok.
My hardware hangup and i installing a new server.
Howto i restore from tape to a new instalation.
André Sartori
[EMAIL PROTECTED]
-Mensagem original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Enviada em: quinta-feira, 7 de fevereiro de 2002 09:56
Para: Andre Sartori
Assunto:
I am using PHP to access a MySQL DB. If I stop MySql and then restart it and
then open my webpage the table values are correct. If I make a change to the
table, close my browser and restart it, the table values are the old values.
If I stop MySQL after changes and then restart it, all works
Hello everyone,
There used to be a section in mysql documentation, which explained about all the
entries in my.ini file. Do you know what happened to it?
There is a part about my.cnf but that's not what I want. There was more.
Hello,
I am new to MySql. I have MySql installed in my Linux PC. How do I connect
to MySql using Perl script and assign the result of a query to an array?
Where could I find a sample code? Thank you.
Andy
_
Get your FREE
Problem Solved!
Thanks
- Original Message -
From: AOK Lansing [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 1:37 PM
Subject: PHP does not see Table updates
I am using PHP to access a MySQL DB. If I stop MySql and then restart it
and
then open my webpage the
Hi.
You have to install DBI::DBD module.
Then in perl
use Mysql;
$dbh = Mysql-connect(undef,database,username,'password');
$sql = select blah from blah;
$sth = $dbh-query($sql);
@arr = $sth-fetchrow;
for example if the result is more than one line you have to loop it
Ofcoz there is other ways
Show us your code.
What are your table structures like?
-Original Message-
From: AOK Lansing [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:37 PM
To: [EMAIL PROTECTED]
Subject: PHP does not see Table updates
I am using PHP to access a MySQL DB. If I stop MySql and
Has anyone made a suggestion or thought about ways to distribute
databases which focus on fulltext indexes?
fulltext indexes do a good job of indexing a moderate amount of data,
but when you get a lot of data to be indexed, the queries slow down
significantly.
I have an example table, with
Hi folks -
I am still having 2 related problems with the timezone setting for mysqld
was hoping to get some help.
Basically my squestions are as follows:
a) the documentation says to set timezone by simply using --timezone=# when
starting mysqld - but WHAT are the valid number values which
I am trying to query the database for records that have the same
sequence of starting characters--such as banana1 and banana2 and have a
result set returned that contains everything that starts with banana.
Any way to do this? I think I would use LIKE in other types of
databases, but I was
Hi,
As I am new to MySQL, perhaps this is a common question you have been asked.
I have a field Id which using auto_increment. Now I want to reset the
value of auto_increment, that is the Id starts form 1 and does not skip
the number. I have spent a few hours to find a way, but all failed.
SELECT * FROM Table WHERE Fruit LIKE banana%
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:56 PM
To: Mysql List (E-mail)
Subject: LIKE work around??
I am trying to
Sinisa Milivojevic wrote:
Shankar Unni writes:
And one big reason not: no native Windows port. Or Mac port (though that
has probably changed with OS/X - anyone working on that?).
When you are saying that there is no native Windows or OS X port, what
were you referring to ??
Oh,
MySQL doesn't support LIKE does it? I got an error when I tried.
-Original Message-
From: Nathan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:04 PM
To: Rutledge, Aaron
Subject: Re: LIKE work around??
Um... keep using LIKE? Just a thought... :-)
- Original
Work-around? LIKE should work just fine...
mysql select * from fruits where fruit_name like '%banana%';
On Thu, 7 Feb 2002, Rutledge, Aaron wrote:
I am trying to query the database for records that have the same
sequence of starting characters--such as banana1 and banana2 and have a
I am using the following versions of mysql on suse linux 7.2:
frontend: mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
server: version 3.23.47
If I try to use the GRANT command I get
#mysql -u root mysql
mysql GRANT ALL ON *.* TO root@localhost
-
...uhm duh. My apologies. I had the LIKE switched around when I tried
it and after reading through the manual and not finding anything about
LIKE (it isn't mentioned as a parameter in the SELECT section) I assumed
it wasn't supported. Thanks for your comments. Aaron
-Original
The variable will be string of cource that contains nomore than 255 chars.
No, I didn't even tried it :)
(concatenation will be the same)
But it has to be a way...
It is a problem, because my internet MySQL base doesn't permmit me to login
with MySQLfront as I have dynamic IP, for security and
On Thursday 07 February 2002 14:53, Brian DeFeyter wrote:
Has anyone made a suggestion or thought about ways to distribute
databases which focus on fulltext indexes?
fulltext indexes do a good job of indexing a moderate amount of data,
but when you get a lot of data to be indexed, the
Umm, I take it you haven't read the documentation? MySQL fully supports
LIKE. Can you tell us the error you are getting? Along with the full query?
j- k-
On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote:
MySQL doesn't support LIKE does it? I got an error when I tried.
--
Rutledge, Aaron writes:
MySQL doesn't support LIKE does it? I got an error when I tried.
I use it all the time. Maybe post the error message you got.
RLIKE on the other hand...sigh.
--Cindy
-
Before posting, please
The following deletes all records and re-starts renumbering from 1;
DELETE FROM mytable;
The following deletes all records and continues counting from where the
table last left off:
DELETE FROM mytable WHERE 1;
If you are trying to restart numbering while not deleting records,
forget-about-it.
Perhaps I should have split this up into two mails, but I saw them related
in the difference of databases
On mysql Ver 11.12 Distrib 3.23.32, for pc-linux-gnu (i686)
this works
SELECT SQL_BUFFER_RESULT DATE_FORMAT(ORDERHEADER.AvailableAt,'%y/%m/%d') AS
'Date',
Hi!
From http://www.innodb.com/ibman.html :
MySQL/InnoDB-3.23.44, November 2, 2001
You can define foreign key constraints on InnoDB tables. An example: FOREIGN
KEY (col1) REFERENCES table2(col2).
You can create 4 GB data files in those file systems that allow it.
Thus 4 G files
Thanks, but it was just a typo. And I tried it again, but with the same result. It's
really a strange installation.
mysql GRANT ALL PRIVILEGES ON *.* TO root@localhost
- IDENTIFIED BY 'salach01' WITH GRANT OPTION;
ERROR 1047: Unknown command
JoacHim
-Ursprüngliche Nachricht-
On Thu, 2002-02-07 at 15:40, Tod Harter wrote:
[snip]
Wouldn't be too tough to write a little query routing system if you are using
perl. Use DBD::Proxy on the web server side, and just hack the perl proxy
server so it routes the query to several places and returns a single result
set.
The obious question is: (before I test it)
This is concatenation to $query that is a string type, no?
So the limit isn't also set to 255 chars too?
Or is a trick especially for this case?
Makis
-Original Message-
From: Johnny Withers [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
There is no limit on the size of strings in PHP. Follow this link for more
info:
http://www.php.net/manual/en/language.types.string.php
Brett
Original Message Follows
From: savaidis [EMAIL PROTECTED]
To: 'Johnny Withers' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: long query on
MySQL folks,
I am planning on using MySQL replication to mirror a database at
various far-flung locations. I'm anticipating that there might be a
handful of slaves, but they will only come on every few months. In
that scenario, the last slave will have a lot of catching up to do if
all slaves
Think of the binary log as just a long binary data stream, which simply
happens to be in a series of files. Each slave has a position in that
binary stream, which is expressed as a filename and file position.
Each slave has (potentially) a different position in the stream, and
therefore a
I second the question. It could also reduce the size of the
fulltext index and the time taken to update it.
-steve
On Thursday 07 February 2002 20:53, Brian wrote:
Has anyone made a suggestion or thought about ways to distribute
databases which focus on fulltext indexes?
fulltext
It seems to me like the best solution that could be implemented as-is
would be to keep a random int column in your table (with a range of say
1-100) and then have fulltext server 1 psudo-replicate records with a
the random number in the range of 1-10, server 2 11-20 and server 3
21-30 and so
I did this at a previous job, and we split the data up more or less
this way (we used a pre-existing item number for the split which was
essentially random in relation to the text data), with a aggregator that
did the query X ways, each to a separate box holding 1/X of the data.
The results from
At 14:57 -0600 2/7/02, Rick Emery wrote:
The following deletes all records and re-starts renumbering from 1;
DELETE FROM mytable;
The following deletes all records and continues counting from where the
table last left off:
DELETE FROM mytable WHERE 1;
If you are trying to restart numbering
At 12:50 -0800 2/7/02, Cindy wrote:
Rutledge, Aaron writes:
MySQL doesn't support LIKE does it? I got an error when I tried.
I use it all the time. Maybe post the error message you got.
RLIKE on the other hand...sigh.
sigh, what? RLIKE works. It's the same as REGEXP.
--Cindy
Paul DuBois writes:
At 12:50 -0800 2/7/02, Cindy wrote:
Rutledge, Aaron writes:
MySQL doesn't support LIKE does it? I got an error when I tried.
I use it all the time. Maybe post the error message you got.
RLIKE on the other hand...sigh.
sigh, what? RLIKE works. It's the same
Shankar Unni writes:
And one big reason not: no native Windows port. Or Mac port (though that
has probably changed with OS/X - anyone working on that?).
Here is an unofficial install package of the new PostgreSQL 7.2:
http://www.entropy.ch/software/macosx/postgresql/
You can get an unofficial
input is SELECT dog_name FROM hold_tbl WHERE dog_name RLIKE ^sam[0123456789]*
ORDER BY dog_name
(and then printing out each of the matches made)
Sam
Sam4
Sam5
Sammie6
Sammy7
Sampson2
Samson
Samuel
As I understand it, only the first three should have matched.
Actually, as
Hi.
I prefer doing like this
$query = CREATE TABLE query ;
$query .= tabledef for col a,;
$query .= tabledef for col b,;
$query .= lots more table defs,;
$query .= welcome to line 400;
You get the point i guess
you can do same things many different ways in php:)
/PM\
Alex Aulbach wrote:
Yesterday, from savaidis:
The obious question is: (before I test it)
This is concatenation to $query that is a string type, no?
Yea. The following works either:
mysql_query(create bla.
bla.
bla
bla blabla
.
bla
.bla
);
So the limit isn't also set to
1 - 100 of 123 matches
Mail list logo