Well, my server is running on Mandrake 8.0. We're trying to implement
database hosting at our site, therefore people should probably have
database spaces between 10-50 MB.
In Microsoft SQL server you can limit the size of a database when
creating it. Is it possible in MySQL ?
VVM Ravikum
Hi Guys,
I am running MySQL on windows 2000 and I have just noticed something
very strange! I have been setting up a network over the last few weeks and
managed to install MySQL ok when I wasn't logged on to our domain (I could
just run a command prompt, change directory to c:/mysql/bin
Hi Guys,
I am running MySQL on windows 2000 and I have just noticed something
very strange! I have been setting up a network over the last few weeks and
managed to install MySQL ok when I wasn't logged on to our domain (I could
just run a command prompt, change directory to c:/mysql/bin
The MySQL server keeps crashing together with half the tables
(MySQL-3.23.38). The server is tight-loaded, but not enough for a
possible lack of resources. It all acts on a Dell server,
Linux-2.2.18.
Sincerely yours
Maxim A Belushkin
System Administrator
Hosting Unit
RUNET.COM
Hi,
Thanks for assisting me in my earlier query. I never had the time to try
it out as my office needs keep changing. In connection to my earlier
question, this is just an extension :) The hotel names repeat in the
travel table.
My travel table's required fields from the hotel table are:
nom
I want to used the begin trans and commit trans in
my ASP program on top of mysql db.
do anyone know how to do that ?
thanx
/---\
Confidential and/ or privileged information may be contained in this
e-mail and any attac
When begining and commiting a transaction using perl and DBI, does the
commit need to come from the same statement handle as the begin or does it
just need to be from the same database connection handle?
Thanks.
ryan
-
Before
Using PHP you can. PHP Nuke has this, I use it on my site, other than that
no clue.
-Original Message-
From: saraswathy saras [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 18, 2001 10:20 PM
To: [EMAIL PROTECTED]
Subject: assign auto password
Do anyone know how to assign password automa
Do anyone know how to assign password automatically or create a new
password in mysql by using only user id.
Thanks in advance
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
On 18-Jun-01 WeAreUs wrote:
> Hi All!
>
> While this is not a huge problem, it is a recurring one so I thought I would
> see if someone else has a nice generic way of handling this situation. I
> often set up database tables with a PHP4 interface to handle insertions.
> It is always set up on
do anyone know how to assign password automatically in mysql or create
a password by using only user ID.
Thanks in advance.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-
Red Hat 6.2 configured right out of the box ... mysql 3.23.38 . After 15
days of running fine, the server hangs now (even after reboot) and doesn't
listen for connections.
Any thoughts?
Thanks
Sue
On Mon, 18 Jun 2001, Jeremy Zawodny wrote:
> I'd use a combination of my.cnf entries and SQL. The my.cnf entry (or
> entries) woudl list the available directories, like others have
> suggested. Then, using SQL, you could:
>
> * Mark a table to be "spread out" at creation time vis some
> at
On Mon, 18 Jun 2001, Patrizio Bruno wrote:
> "select max(field) from table" returns the greatest field's value in the first
> file of the RAID table (successive files are not considered), adding a where
> clause (for ex. "select max(field) from table where field2 >= 200") the
> problem seems
Do anyone know how to assign password automatically in mysql or create
password automatically by using only the user ID.
Thanks in advance.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
At 9:44 PM -0400 6/18/01, [EMAIL PROTECTED] wrote:
>what's wrong with this please:
>
>mysql> -u jjames -psd342 dbtheNetee <
>/Library/WebServer/web1/book/install/netsloth.dump;
>
> ->
Looks like you're trying to execute a shell command from within mysql.
Run the command from your shell prom
what's wrong with this please:
mysql> -u jjames -psd342 dbtheNetee <
/Library/WebServer/web1/book/install/netsloth.dump;
->
(as i understand it a .dump = .sql file)
thanks.
-
Before posting, please check:
http://ww
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 9:20
Subject: please help (dumb permissions thing?)
> Access denied for user: '@localhost' to database 'netsloth'Could not
> drop database netsloth
Don't know what command you used but I
>Description:
Starting MySQL daemon
Loading Standard Test Databases
Starting Tests
TEST USER SYSTEM ELAPSEDRESULT
alias 0.12 0.06 0.9
Tried both. 1st copied the data tree (wherein there is a host.frm,
host.MYD, and host.MYI files).
When that didn't work, I did the mysql_install_db, but that had no effect.
I suspect that there is a ./configure option I missed that declares the
default data file format to use, and that they wer
i guess that is confusing to me because it says "query".
i'm really stuck though -see my recent 'please help' post to the mysql list.
thanks.
At 2:48 AM -0600 6/18/01, Chris Bolt wrote:
> > thank you.
>> that's sort of what i thought.
>>
>> now for the silly question:
>> i know how to do it w
Access denied for user: '@localhost' to database 'netsloth'Could not
drop database netsloth
(i asume "drop" means to "drop 'in'" in this case?)
is what i get back when i try to install the db 'netsloth.dump' from
J Greenspan's book and CD.
please tell this newcomer what he has to do to fix th
It's looking for the "host" table (physical files) within the 'mysql' data area
(not your own data area).
Did you run "mysql_install_db" after installing the new version ? (or copy the
"mysql" subdirectory from the old version)
Guy Smith wrote:
> I just upgraded from 3.23.27 to 3.23.32 (can't
I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to
sync development with production systems).
I copied the /data directory to the new home. When I try to start mySQL, it
halts and the log file has the entry "Can't find file: 'host.ISM' (errno:
2)". I checked the old my
At 01:08 AM 6/19/2001 +0100, © webfroggie.com wrote:
>Hi,
>
>Is there a place where I can find a manual (not tutorial) of SQL
>Reference/Sintax, something like the PHP Manual...
>It could be about SQL in general, MySQL and/or Oracle.
>
>
>Thanks,
>
>Jorge Oliveira
>[EMAIL PROTECTED]
The MySQL man
Hi,
Is there a place where I can find a manual (not tutorial) of SQL
Reference/Sintax, something like the PHP Manual...
It could be about SQL in general, MySQL and/or Oracle.
Thanks,
Jorge Oliveira
[EMAIL PROTECTED]
© webfroggie.com - R
In case you're not aware of it yet, Linux (and other UNIX operating systems)
are not 'binary file compatible' with Microsoft products (including Windows
98).
You should always 'dump' your database contents (using mysqldump) before
'moving' the data to build another database (unless you're moving
If you're trying to check a 'remote' system, you can 'telnet' to port 3306
(IF you have remote 'telnet' access to the MySQL service, and IF it's
listening on the default port 3306) which will display some garbage containing
the version number
> telnet yubby.dubby.com 3306
3.23.37G\Tn
I'm receiving the following error:
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (111) in
/home/httpd/html/phpadmin2/lib.inc.php on line 119
what could be?
thanks,
Augusto
---
How can I transfer the data from a MySQL 3.22.32 running on RedHat
6.2 Linux to a MySQL 2.23.37 running on Windows 98?
thanks,
Augusto
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:/
On Mon, Jun 18, 2001 at 08:19:20PM -0300, Augusto Cesar Castoldi wrote:
>
> How can I know the version of mysql running on Linux (RedHat 6.2)
mysqladmin version
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 4
On Mon, 18 Jun 2001 20:19:20 -0300 (EST), Augusto Cesar Castoldi
<[EMAIL PROTECTED]> wrote:
SELECT VERSION();
>>te: Mon, 18 Jun 2001 20:19:20 -0300 (EST)
>>
>> How can I know the version of mysql running on Linux (RedHat 6.2)
>>
>>
>>thanks,
>>
>>Augusto
Mike(mickalo)Blezien
=
> Steven> Now I have a question: Does this also apply to automatic
> repair inside
> Steven> mysqld? I'd finally use the feature if its true...
>
>
> If you just run CHECK TABLE, it will repair the open count (it should
> always have done that).
>
> myisamchk --fast --force is equal to:
>
> run CH
I tried to put the data (.frm, .ISD and .ISM files) of my Linux into
windows 98 put I can't use the data. When I open phpadmin2, he show how
many registrys I have, but When I try to use/list the table is empty. Can
I solve this problem? I need to use mysqldump to put the data into windows
98?
th
How can I know the version of mysql running on Linux (RedHat 6.2)
thanks,
Augusto
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Hi.
On Mon, Jun 18, 2001 at 02:32:13AM +0100, [EMAIL PROTECTED] wrote:
> I need some help with a query to sum data for each id and write it into a
> new table.
>
> I have a source data table for each calendar month containing i.d.'s (not
> unique) and a value and I need to sum all the values for
Hi.
On Mon, Jun 18, 2001 at 08:16:45AM +1000, [EMAIL PROTECTED] wrote:
>
> What is the current way to move back and forwards and to any position in a
> recordset without losing performance
There is no way. For effiency, the record set is hold in memory as
linked list. Searching a position in li
You can. However, in these situations (in other languages) I've written code
generators that generate either the entire HTML/PHP page for me or at the
very least, the data object that I am talking to, complete with
SELECT/INSERT/UPDATE and DELETE statements.
That having been said, not trying to b
Hi,
I'm connecting to a MySQL server through the MM JDBC driver on under Red Hat
6.2 using the below code. I keep getting an error message returned that says
: "Server configuration denies access to data ".
I'm connecting as the root user and I am definitely passing the correct
password etc. in t
I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to
sync development with production systems).
I copied the /data directory to the new home. When I try to start mySQL, it
halts and the log file has the entry "Can't find file: 'host.ISM' (errno:
2)". I checked the old my
Hi Jeff,
If you visit my homepage at:
www.geocities.com/hisiomara
click "Tutorials" and select the first item "Team5.com an ecommerce sample"
you will be able to see the ERD diagram that attends your ecommerce demand.
Actually will will be able to see much more.
The design is there,and I wil
Really the question is will the following work:
LOAD DATA INFILE 'home/domain name/www/subdirectory/data.txt' INTO TABLE
data FIELDS ENCLOSED BY '"' TERMINATED BY ',' LINES TERMINATED BY ';';
-Original Message-
From: Hamilton, Jay
Sent: Monday, June 18, 2001 4:56 PM
To: '[EMAIL PR
>Description:
Upgraded from 3.22.27 to 3.23.32. Built from source.
When attempting to start the daemon, it immediately terminates. Log file shows "Can't
find file: 'host.ISM' (errno: 2)". I checked the old data directory (from where I
copied the database files) and there never has been a ho
hi.
the easiest way is to have
an order table:
(orderID, customer, address, etc., etc.)
a item table:
(itemID, description, price, etc.etc.)
and an orderItems table:
(orderID, itemID)
this way you can
select i.description, i.price
from order o,
item i,
orderItems oi,
where o.orde
The problem is the text file resides on a server that holds the website
pages. I am new to UNIX. How do I setup the LOAD DATA INFILE command to
specify the text file if it is loaded on another server?
This is what I have:
LOAD DATA INFILE 'data.txt' INTO TABLE data FIELDS ENCLOSED BY '"'
TER
Ola Ricardo,
Não sei ao certo se o formato padrao do MySQL voce consegue mudar.
Entretanto voce pode resolver o problema utilizando o DATE_FORMAT no select.
Veja o exemplo abaixo:
SELECT DATE_FORMAT(NOW(), "d/m/Y") AS DATA;
[]'s
Crercio O. Silva
-Original Message-
From: Ricardo Ferrar
Hi All!
While this is not a huge problem, it is a recurring one so I thought I would
see if someone else has a nice generic way of handling this situation. I
often set up database tables with a PHP4 interface to handle insertions.
It is always set up on a CGI basis, wherein a form blasts variab
On Mon, Jun 18, 2001 at 03:56:32AM -0700, Jamie Krasnoo wrote:
>
> [mysqld]
> datadir=/data1;/data2;/data3
>
> - or -
>
> datadir=/data1:/data2:/data3
>
> As it stands now, both will produce an error and MySQL will not start.
>
> Other ways could be like: RAID_DIRS=/data1:/data2:/data3
Well,
Ok, in your PHP code, do this:
$customer_select="SELECT * FROM customers WHERE Customer_No = '$id'";
This will add quotes around the variable...
-TIM
On Mon, 18 Jun 2001, Shrout, Ryan wrote:
> Thanks for the suggestions, but this is actually a variable that is passed
> via a URL. For examp
Hello All,
Sorry if this is the wrong place to post this request.
I represent ADEMKA and in September we are launching a publication which
has both a LIFESTYLE and a TECHNICAL angle to it for Computer Professionals.
We are looking for articles relating to MySQL and are paying between
£50(GBP) a
Like this:
$customer_select="SELECT * FROM customers WHERE Customer_No = '$id'";
Jorge Oliveira
[EMAIL PROTECTED]
---
© webfroggie.com - Recursos Online!
web: http://www.webfroggie.com
wap: http://www.webfroggie.com
-Mensagem original-
De: Shr
You are using PHP. Well PHP is not ASP :-) clever and you can enclose your
variable in single quotes as in:
$customer_select="SELECT * FROM customers WHERE Customer_No = '$id'";
Hope this helps.
*
* Visit http://www.computerstaf
Hi there,
Where can I get the MySQL protocol?
Thanks!
Yue
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Hi,
I am new to MySQL. I downloaded MySQL for Windows version 3.23.38. When
I installed in MyISAM mode, mysqld was running fine. Then I uncommented
the configure parameters for innoDB in my.cnf. Mysqld initialized the
database the folowing messages printed on screen. Can anyone help ?
Thanks,
Wo
> $customer_select="SELECT * FROM customers WHERE Customer_No = $id";
This is more of a PHP question but here's what I would do.
$customer_select="SELECT * FROM customers WHERE Customer_No = '$id'";
OR
$customer_select="SELECT * FROM customers WHERE Customer_No = '".$id."';
if for some reason the
This looks like an order-lineitem situation, which I would imagine would
look like this:
ORDERS
ORDER_ID
CUSTOMER_ID
ORDER_DATE
LINEITEM
ORDER_ID
PRODUCT_ID
LINEITEM_QUANTITY
At 02:00 PM 6/18/2001 -0500, you wrote:
>I have a design problem I was hoping some of you could help me out
>with.
Hello,
Your field(column) is a CHAR and therefore the parameter to it should be in
single
quotes:
Change your query to:
SELECT * FROM customers WHERE Customer_No = 'CMET3558539239'
*
* Visit http://www.computerstaff.net - Compu
Thanks for the suggestions, but this is actually a variable that is passed
via a URL. For example:
http://localhost/cus-lookup.php?id=CMET3558539239
Then in the code it looks like this:
$customer_select="SELECT * FROM customers WHERE Customer_No = $id";
How can I 'put quotes around' a variabl
Try
SELECT * FROM customers WHERE Customer_No = 'CMET3558539239'
Jorge Oliveira
[EMAIL PROTECTED]
© webfroggie.com - Recursos Online!
web: http://www.webfroggie.com
wap: http://www.webfroggie.com
-Mensagem original-
De: Shrout, Ryan [mail
Put quotes around the Customer_No:
SELECT * FROM customers WHERE Customer_No = 'CMET3558539239'
- TIM
> Here is the full error I am getting when running the query included:
>
> Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239
> 1054 : Unknown column 'CMET3558539239' in
On Mon, Jun 18, 2001 at 02:44:00PM -0400, Shrout, Ryan wrote:
> Here is the full error I am getting when running the query included:
>
> Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239
> 1054 : Unknown column 'CMET3558539239' in 'where clause'
> Here's the problem, I know
I have a design problem I was hoping some of you could help me out with. I am writing
a shopping
cart system (as if there wasn't enough already) and I have one problem that has me
stumped.
A person can order more than one item of course. So let's say they order a kite and
some string.
Both o
Hello all,
I am running the new Mac OSX Server. In the mysql docs, it says to put
the mysql.server file in the correct place for your system. Does anyone know
what the right place on OSX Server is? I placed it in
/Library/Startup/MySQL, as the other databases I am experimenting with have
their
Kenneth Johansen ([EMAIL PROTECTED]) writes:
> hi all, i have a small problem
>
> im using mysql_query to access my mysql database.
>
> now then, i have 2 queries, 1 just after the other.
> the first one goes ok, the second one never does.
>
> doesnt matter if i switch the queries, the one tha
Here is the full error I am getting when running the query included:
Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239
1054 : Unknown column 'CMET3558539239' in 'where clause'
Here's the problem, I know that Customer_No exists. I can see it in the
database. This code work
You could try using the IFNULL() function on that column before you do the join.
http://www.mysql.com/doc/C/o/Control_flow_functions.html
--jfarr
- Original Message -
From: "Bryan Coon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 11:12 AM
Subject: left outer
Ricardo Striquer Soares <[EMAIL PROTECTED]> writes:
> i have recently installed the red hat 7.1 in my computer,
> althought i have not installed the mysql durring the os
> installations, naw i installed the mysql database
> but its giving me a socket error like this:
>From our RPMs, or did
That's what it's supposed to do. End the command with a "&" so it will
spawn into the background.
Scott
At 11:05 AM 6/18/2001 -0700, Dale Schell wrote:
>Hello all,
> I have mysql 3.23.39 installed on the new Mac OSX Server. The problem I
>am having is that when I start it from the command
Hi, I am having a small formatting problem maybe someone can help with.
I have a query that does a left outer join, which generates a table with a
few NULL values in some columns. All okay so far. But what I need to do is
sort on this column, and I need to put NULL values at the end. Normally
Hello all,
I have mysql 3.23.39 installed on the new Mac OSX Server. The problem I
am having is that when I start it from the command line using safe_mysql -u
mysql, it says:
"Starting mysqld daemin with databases from /usr/local/mysql/var"
It never reports anything else. The database starts
Ricardo,
Heh... Watch out, RH 7.x is notorious itself for being the
src of a problem.
Cheers
-v.
--EOF
Ricardo Striquer Soares wrote:
>
> i have recently installed the red hat 7.1 in my computer,
> althought i
> have not installed the mysql durring the os installations,
> naw i
> I have downloaded the mySql distribution as well as
> 2 different versions of gnu tar that available at the site.
>
> gtar-solaris-4.1.4-sparc.gz and gtar-sparc.gz
>
> The reason I downloaded 2 different versions of the gnu tar
> is that I can't get anyone of these to deflate using gzip.
>
> I h
(assuming you're using PHP...)
The best idea would probably be to create a column in your users table which
indicates which company each user belongs to. Then, using "select
company_name from users where username EQ ".$username;
If you're not using PHP, the idea is still the same. Use a MySQL qu
hi all, i have a small problem
im using mysql_query to access my mysql database.
now then, i have 2 queries, 1 just after the other.
the first one goes ok, the second one never does.
doesnt matter if i switch the queries, the one that is last never works.
if i write the query in an xterm (usin
I recently set about upgrading our MySQL install on a Compaq Tru64 4.0f
Alpha box from 3.22.25 to 3.23.38.
As in the past, I used the Compaq cc as CC and gcc (2.95.3) as CXX with
appropriate flags set. I do not have the GNU binutils installed, so it
is the Compaq ld that is used. I am, howev
No need to worry.On NT each table can have
upto4GB.Database there is predefined limit.It can go
even upro 20GB or more also.
--- Ali Kemal YURTSEVEN <[EMAIL PROTECTED]>
wrote: >Hi,
>
> I'm new in this list and new to MySQL also. What I
> want to know is how
> to limit the size of a
Greg wrote:
>
> Le jeudi 14 juin 2001, à 08:14, Daniel a écrit :
>
>> I believe that i've seen this on the list before.
>> Read the php docs before compiling, don't use the builtin mysql support,
>> specify --with-mysql=/path/to/mysqllibs
>
> Yes, I've compiled with this option. Is it possib
ola
como faço p/ mudar a data padrao do mysql??
ele esta como
-dd-mm
eu gostaria de mudar p/ dd-mm-
falow
valeu
i have recently installed the red hat 7.1 in my computer,
althought i
have not installed the mysql durring the os installations,
naw i
installed the mysql database but its giving me a socket
error like this:
/etc/rc.d/init.d/mysqld status
mysql dead but subsys locked
mysql
ERROR 2002: Can't con
try some more then..
try // or / or .. .
> Hi,
> I donot even get that with an additional backslash
> also.In my case it just ignores the backslash and goes
> ahead with the search .
> Regards,
> Ravi
> --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On
> Mon, Jun 18, 2001 at 04:32:5
"select max(field) from table" returns the greatest field's value in the first
file of the RAID table (successive files are not considered), adding a where
clause (for ex. "select max(field) from table where field2 >= 200") the
problem seems not to exist. I don't know if the bug is limited to
Hello
I run mysql on a multi proccesoor server and when I run queries from different
servers,
I see it uses under 100% cpu, even thought it sometimes take 50% from each cpu. how
can I get it to use 100% for each query?
Thanks
Tomer Grassyani.
Internet Driver.
-
Hi,
I get the following based on my requirement:
This time it returned an empty set.See the
last.Sometimes it is ignoring the backslash
altogeather.
I want to search a string like "ah\bl" in "blah\blah".
Regards,
Ravi
mysql> use dbhub;
Database changed
mysql> CREATE TABLE slash_test ( foo VARCH
Hi,
I donot even get that with an additional backslash
also.In my case it just ignores the backslash and goes
ahead with the search .
Regards,
Ravi
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On
Mon, Jun 18, 2001 at 04:32:54PM +0100, VVM
> Ravikumar Sarma Chengalvala wrote:
> >
> > Even after
On Mon, Jun 18, 2001 at 04:32:54PM +0100, VVM Ravikumar Sarma Chengalvala wrote:
>
> Even after escaping mysql just seems to be ignoring it.
Odd. I'm seeing something other than what I first expected. Watch
this...
---snip---
mysql> CREATE TABLE slash_test ( foo VARCHAR(30) );
Query OK, 0 rows
Hi,
Can someone get back to me at the earliest regarding
mysql's support for backslash characters in pattern
search.I am not able to search based on the string
which contains a backslash character even after
escaping..
Regards,
Ravi
Do
Title: Blank
I currently have several different systems
accessing a mysql server 3.23.34 somewhere in there is a process that forgets
about connections that it has open.
So after a few days I get a "too many
connections open error". Is there a way that I can set connections to time
out af
Alex,
did you change any my.cnf parameters? Version .39 should
actually be a littel bit faster than .38.
What does Unix 'top' say? What are the CPU usage %?
The biggest change performance-wise in .39 is that
you can now specify the parameter
innodb_unix_file_flush_method
in my.cnf.
You could
I am trying to evaluate mySql.
I am told that if I am on Solaris, I must obtain gnu tar because
of a bug in Solaris tar.
I have downloaded the mySql distribution as well as
2 different versions of gnu tar that available at the site.
gtar-solaris-4.1.4-sparc.gz and gtar-sparc.gz
The reason I
It is not working even after escaping it.I am working
on WINNT4.0 and mysql 3.23
--Regards,
Ravi
--- Scott Baker <[EMAIL PROTECTED]> wrote: > It
depends on what you mean by pattern search? You
> probably have to escape
> the "\" character. If you put a "\" in front of a
> character it means th
Hi,
Even after escaping mysql just seems to be ignoring
it.
Regards,
Ravi
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On
Mon, Jun 18, 2001 at 04:15:37PM +0100, VVM
> Ravikumar Sarma Chengalvala wrote:
> > Hi,
> >
> > Did mysql pattern search support a backslash
> character?
>
> Yes.
>
> Sin
It depends on what you mean by pattern search? You probably have to escape
the "\" character. If you put a "\" in front of a character it means this
next character is what I say it is not it's MySQL representation. This
would allow you to put a ";" or ")" in your query. Simply put "\\" to m
On Mon, Jun 18, 2001 at 04:15:37PM +0100, VVM Ravikumar Sarma Chengalvala wrote:
> Hi,
>
> Did mysql pattern search support a backslash character?
Yes.
Since it is a special character, make sure it is properly escaped.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
De
Bonjour,
Environment: Solaris 2.8 on SPARC 64bit, Mysql-3.23.39+InnoDB.
Mysql 3.23.38 with InnoDB support have been running for a while now
on one of my servers (for a month in fact, since the release of
3.23.38).
It worked perfectly well and was able to handle the job (intens
Hi,
Fairly new at this so i need all the help i could get. I created a admin
page where admin can add/mod/del/view from this page. But now I need to give
access to other admins but from diffrent companies where I need to grant
diffrent username and passwords to the original admin page. Each compan
Hi,
Did mysql pattern search support a backslash
character?
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-
Hi,
I am facing the following problem in pattern matching:
I want to check the pattern matching using LIKE on a
field that is declared as Binary and also contains
back slashes.
eg:
ID INT,
NAME VARCHAR(128) BINARY
I am using C-API of mysql to escape the characters
like '\' for this field.
The s
But my problem is perhaps simply in the concept:
When MySQL accept a create table in entry (as bad as it is like this one from a guy in
my team), mysqldump should regenerate from this table a create table statement
accepted by MySQL too.
no? it's not logic?
;-)
Regards,
Le Mon, Jun 18, 2001
Sinisa,
A good way to prove that mysqldump is doing what it should, might be to do a
describe TESTBADDUMP;
I think this will prove that mysqldump is just dumping what is in the table
def, which is all you can expect.
Have a great day...
John
On Monday 18 June 2001 09:46, Sinisa Milivojevic w
Guillaume Fougnies writes:
>
> ok so it's a failure from mysqldump.
>
> I know this declaration is not really correct but mysqldump must regenerate a
>correct sql statement (good when pipe in mysql client i mean at least ;) ).
> It's not the case.
>
> Regards,
> --
> Guillaume FOUGNIES
> Resea
1 - 100 of 130 matches
Mail list logo
