Pada Mon, 1 Jul 2002 09:01:13 +0200
"Wouter van Vliet" <[EMAIL PROTECTED]> menulis :
> I would use
>
> WHERE skill LIKE "%powerpoint%" OR skill LIKE "%PHP%"
>
where skill REGEXP "powerpoint" or skill REGEXP "php"
--
#ifdef STUPIDLY_TRUST_BROKEN_PCMD_ENA_BIT
2.4.0-test2 /usr/src/linu
I would use
WHERE skill LIKE "%powerpoint%" OR skill LIKE "%PHP%"
but that is because I don't know the better way, which must be there, I feel
it .. anybody?
--
Alle door mij verzonden email is careware. Dit houdt in dat het alleen
herlezen en bewaard mag worden als je goed omgaat met
Hi All
In MySql 3.23.51 , i was able to add values into the child table
I have created a table parent and also another table child where parentid
column in child is a foreign key to the id column in parent table
It was possible that i have no entries in parent table , and i was able to
insert
Hi
Probably a stupid question, but which is best to have on ones server,
the "old" mysql, or max. I.O.W, if you install MAX and never use innodb
or berkeley tables, will it be equivalent to a normal mysql installation
wrt performance and stability?
I'm asking from an ISP's point of view, if tha
Hi
Probably a stupid question, but which is best to have on ones server,
the "old" mysql, or max. I.O.W, if you install MAX and never use innodb
or berkeley tables, will it be equivalent to a normal mysql installation
wrt performance and stability?
I'm asking from an ISP's point of view, if tha
Hi
Try
eregreplace(tab, 4 spaces)
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
Hi Jeremy,
Here's the deal -- I let the MySQL number of open file handles default to
MySQL's default setting. I also let the linux "max file handles" setting
default... I started getting Error 24 (too many open files--from linux)
when issuing queries, which rendered MySQL useless and caused "bad
Thanks guys, nl2br works perfectly for preserving my new lines! I've
checked over the php string function list and am still experimenting with
some options. However, do you know of any function that will preserve tabs
and spacing (used for centering text, etc)
in case your wondering, i'm letti
>
> hello everyone
> i am working on a project in which db is mysql and it should support
> japanese and korean simultaneously I have mysql 3.23.36 running on
> red_hat_linux_7.1_sea-wolf and default ecoding for mysql is sjis
>
> Kindly tell meif is it possible to make a database support japan
Hi,
Yes there are number of functions you can use in php. I don't know what you
really want to do, i assume that you want the resumes viewed over the web,
in that case you can use nl2br() function to indicate a new line..
Take a look at the following pages:
http://www.php.net/manual/en/ref.strings
I haven't seen the rest of the thread, but form data looses all formatting.
Line breaks will remain but HTML ignores them
look at nl2br() to convert them to
HTH
Peter
---
Excellence in internet and open source software
Thanks, Peter,
Yeah, I had looked at ENCODE()/DECODE() and ABS_ENCRYPT()/ABS_DECRYPT() as possible
tools, as well as some inherent PHP functionality. My real question is more about
database design than about the mechanics of encryption. But I do appreciate the
feedback.
Make a good day . .
I'm using (and new to) PHP. any suggestions as to what functions, if any
exist, that would be appropriate for pre-formatting?
thx,
blue
- Original Message -
From: "Gurhan Ozen" <[EMAIL PROTECTED]>
To: "Blue Presley" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, June 30, 2002 6:0
Thanks, César,
But this is not an option that is negotiable for me. The client mandate is very
clear, and the reason behind it has a strong business case from their standpoint. I'm
not about to get them to change their minds . . . they and I have been over this way
too many times already.
This should be handled before the data is even inserted into mysql. Have
your scripting language that you use in the form handle this to have the
resume formatted in the way you'd like and then have it insert the data into
mysql.
Gurhan
- Original Message -
From: "Blue Presley" <[EMAIL PR
Hi,
If you are sure that the user hasv exists in mysql, then either type
mysql -u hasv -p so that the mysql client will prompt you for a password, or
in your home directory, create my.cnf file and type
[client]
password=yourpassword
Gurhan
- Original Message -
From: "Hugo Veiga" <[EMAIL P
hello,
I have a web from that allows a user to submit a resume in text format. How
do i make mysql respect the formatting of the text document so that it is
pulled from the database as it was inserted? right now everything comes
back as one paragraph.
thanks,
blue
One thing that I find a little confusing is the notion of transactional
behavior in mySQL. I read that it's possible to enable transactions in
mySQL-max, however, it's never really been clear to me exactly what I'm
supposed to do, or whether I have to do anything. If I'm using a transactional
da
Hi
Just to throw another thought in
If you do change the password and send it to them, you have to allow for the
fact that their email could have changed - left work, service provider went
bust etc etc, or somebody could just enter their email for a joke 8*} and
get their password reset. I h
you will need to give it the password flag and then type in the password
when prompted for one.
mysql -u hasv -p
Regards,
Bhavin.
- Original Message -
From: "Hugo Veiga" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 30, 2002 9:54 AM
Subject: need you expertise
> Hi agai
Barn.
I asked the same question couple of weeks ago and all the answers I got
pointed to one way encryption. Actually, I had the same need that you,
but understood that it was better to reset the password when a "Forgot
password" was made, send it to the user and ask them to change the
password a
I need to store small files in mySql. Some are binary and some are not,
can they be stored the same way ?
eg: Read them in as binary and store them in a blob ?
I can't figure out how to store binary data in mySql using ADODB, c# ?
I read in the binary data as a byte array. I then convert that to
Hi!
I have a table called 'candidate_skill'
id (autoincrement)
candidateID (link to candidate),
skill (tinytext)
Query: SELECT * FROM candidate_skill WHERE candidateID='2'
Result:
134 | 2 | Powerpoint
223 | 2 | PHP
313 | 2 | Lotus Notes
Is it possible to do a fulltext search. I want to search
Hi again,
first of all thx for the precious help given to me.
Well it seems i have problems again.
Everytime i try to access "mysql" it returns:
"ERROR 1045: Access denied for user:'hasv@localhost' (Using password:
NO)"
How can i put it to work? Any clue? I'm new to this so
The default at table creation is 4GB. You can change the default vaule via
an ALTER TABLE. You will need to alter AVG_ROW_LENGTH and MAX_ROWS.
MAX_DATA_LENGTH is the product of the two.
http://www.mysql.com/doc/T/a/Table_size.html
Regards,
Bhavin.
- Original Message -
From: "Henry Hank" <
Results of Michael Bacarella's request (too big for dist list, so only
Michael and Michael/Monty got the full reply, this is shortened for the
list so a possible light bulb can go off):
3.23.51:
> ps -eo pid,tt,user,fname,tmout,f,wchan
PID TT USER COMMAND TMOUT F WCHAN
1
Mysql list serve manager,
Could this be a bug in the mysql listserv. Tedd Richards tried to
unsubscribe and I am getting the confirmation e-mail to confirm that I
really want to un-subscribe, when, I haven't emailed an unsubscribe request
in the frist place.
- Original Message -
From: <[EM
Folk,
I need some input on how best to store username/password combinations online. My
preference would be to store a one-way encrypted value, but that is not possible in
this situation. The constraint is that we have to make provision for giving the
user's password back to the user after a "
Hi shawn,
You have probably have % in the user and host of the user table, so mysql
client let you in without a username. To be able to use mysql database, you
have to login as the root user. Just type, mysql -u root -p and see if you
can login in that way.
Besides, you have to restart mysqld fr
Hello,
While looking at SHOW TABLE STATUS, I noticed that all my dynamic tables seem
to have a Max_data_length of 4,294,967,295 bytes. Is this true - that any
dynamic tables are limited to 4GB in size? My fixed tables do not show this
problem, and report that their Max_data_length is 4+ bill
On Sat, Jun 29, 2002 at 10:47:47PM -0700, Steven Roussey wrote:
>
> Tomorrow I'll try doing my own compile with gcc3.1. Note the other
> guy that had the same problem that went away after he compiled it
> himself:
Even gcc 2.95.3 or .4 will work well based on what I've seen. We can
still sustai
>Description:
I think that when I installed mysql, I ran out of room on the /var file system
>How-To-Repeat:
bash-2.05$ /usr/sbin/mysqld --datadir=/home/mysql
InnoDB: Error: data file ./ibdata1 is of different size
InnoDB: than specified in the .cnf file!
InnoDB: Could not open data files
020630
Hi
Not sure here, but you have logged in as 'admin' on the system. Unless you
su to root mysql will use the same user.
try either
[admin admin]$ su -l
to log in to the system as root and then 'mysql -p' to log into mysql
or stay as admin but log into mysql as root, under mysql
[admin admin]$
33 matches
Mail list logo
