Benetl a free ETL tool using MySQL is out in version 3.7

Dear all, Benetl, a free ETL tool for files using MySQL, is out in version 3.7. You can freely download it at: www.benetl.net This version brings new controls and messages in the GUI. This version brings improvements and a bug correction in GUI. You should update. You can learn more about ETL

Benetl a free ETL tool using MySQL is out in version 3.7

Dear all, Benetl, a free ETL tool for files using MySQL, is out in version 3.7. You can freely download it at: www.benetl.net This version brings new controls and messages in the GUI. This version brings improvements and a bug correction in GUI. You should update. You can learn more about ETL

Using MySQL in the Cloud? Help us by answering a short survey and win a T-shirt

Hello! With the rise of cloud computing and "big data", database scalability issues are becoming critical to the growth and success of many applications. Xeround's MySQL Cloud Database is an elastic, always-on database that lets you run your existing MySQL-based application in the cloud. As we

Re: Fixture List generation using MySQL

y... itchy trigger finger. - Original Message - From: "Gavin Towey" To: "Tompkins Neil" ; "[MySQL]" > Sent: Thursday, August 19, 2010 1:50 PM Subject: RE: Fixture List generation using MySQL That's almost a cartesean product; except you just w

Re: Fixture List generation using MySQL

a condition to prevent those > rows from showing up: > > > select * from teams t1 JOIN teams t2 ON t1.id!=t2.id; > +++ > | id | id | > +++ > | 2 | 1 | > | 3 | 1 | > | 4 | 1 | > | 1 | 2 | > | 3 | 2 | > | 4 | 2 | > | 1 | 3 | &g

Re: Fixture List generation using MySQL

quot; ; "[MySQL]" Sent: Thursday, August 19, 2010 1:50 PM Subject: RE: Fixture List generation using MySQL That's almost a cartesean product; except you just want to eliminate results where a team would be paired up with itself. create table teams ( id serial ); Query OK, 0 rows

Re: Fixture List generation using MySQL

well as the logic is quite simple. Regards, -- Burhan Khalid Sent from my BlackBerry® smartphone from Wataniya Telecom -Original Message- From: Peter Brawley Date: Thu, 19 Aug 2010 12:48:18 To: Reply-To: peter.braw...@earthlink.net Subject: Re: Fixture List generation using MySQL >I

RE: Fixture List generation using MySQL

in the first column as the "home team." Regards, Gavin Towey -Original Message- From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] Sent: Thursday, August 19, 2010 10:07 AM To: [MySQL] Subject: Re: Fixture List generation using MySQL I'm looking at a routine / script

Re: Fixture List generation using MySQL

ience generating such information using MySQL ? Basically ... select a.id,b.id from tbl a join tbl b on a.idb.id; PB - On 8/19/2010 9:12 AM, Tompkins Neil wrote: Hi, I'm tasked with generating a list of fixtures from a table of teams, whereby each team plays each other home and a

Re: Fixture List generation using MySQL

generating a list of fixtures from a table of teams, >>> whereby >>> each team plays each other home and away. Does anyone have any >>> experience >>> generating such information using MySQL ? >>> >> >> Basically ... >> >&g

Re: Fixture List generation using MySQL

I'm tasked with generating a list of fixtures from a table of teams, whereby each team plays each other home and away. Does anyone have any experience generating such information using MySQL ? Basically ... select a.id,b.id from tbl a join tbl b on a.idb.id; PB - On 8/19/2010

Fixture List generation using MySQL

Hi, I'm tasked with generating a list of fixtures from a table of teams, whereby each team plays each other home and away. Does anyone have any experience generating such information using MySQL ? Thanks for any input. Regards Neil

Re: Variable Expansion Using MySQL Client and .sql Files

Simple - brilliant. I've modified to cat a temporary script... 1) cat the file as suggested: cat > ~/payload/scripts/create_mysqldb.sql << EOF ###--- ### Display the current user ###--- create database puppet; ###--- ### Display all default accounts ###--- USE puppet; ###--- ### Remove anonym

RE: Variable Expansion Using MySQL Client and .sql Files

You could try it inside a "here" document: mysql < Date: Thu, 29 Jul 2010 14:29:55 -0500 > From: todd_...@ssiresults.com > To: mysql@lists.mysql.com > Subject: Variable Expansion Using MySQL Client and .sql Files > > Hey all, > > I've found many packag

Variable Expansion Using MySQL Client and .sql Files

Hey all, I've found many packages that sit on top of MySQL for various clients. For the purposes of consistency I'd like to automate these installs. I've been directed towards using .sql files and they work great. The trouble I'm having now is that I would like to secure the installation but

Benetl, a free ETL tool for files using mySQL, is out in version 3.5.

Dear all, Benetl, a free ETL tool for files using mySQL, is out in version 3.5. You can freely download it at: www.benetl.net This version brings bugs correction and "if" operator for conditions in "part formula". You should update. You can learn more abou

Finding the max integer using MySQL.

Hi there, I would like to find out the maximum (signed or unsigned) integer from MySQL. SELECT CAST( POW(2,100) as UNSIGNED) as max_int; # max_int | 9223372036854775808 This seems to be a MAX_BIGINT from the lookup table at http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html Is there a wa

Re: Benetl, a free ETL tool for files using MySQL, is out in version 3.3

Dear all, Benetl, a free ETL tool for files using MySQL, is out in version 3.3. You can freely download it at: www.benetl.net This version brings two new improvements, you should update. You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for

free ETL tool for files using MySQL, Benetl version 3.1

Dear all, Benetl, a free ETL tool for files now using MySQL is out in version 3.1. You can freely download it at : www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier

free ETL tool for files using MySQL

Dear all, Benetl, a free ETL tool for files now using MySQL is out in version 3.0. You can freely download it at : www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier

Re: Retrieving results of a stored function using MySql C API

Yeah, please show us the source code of yours. On Wed, Apr 15, 2009 at 4:10 PM, Venu Gopal wrote: > Hi guys, > I am using stored procedures and stored functions for the first time. > And currently stuck at a this point where. I am unable to retrieve > results returned by stored fu

Retrieving results of a stored function using MySql C API

Hi guys, I am using stored procedures and stored functions for the first time. And currently stuck at a this point where. I am unable to retrieve results returned by stored function using MySql C API. Kindly let me know how to do so. In case you need details I'll share the source code. C

Re: Using MySQL with its data files on a CD-R (recordable CD)

D. >However, a more truthful answer uncovers some complexities, > including the speed at which the data can be transferred from the CD > (which will be slower than direct access from a hard drive), as well > as the version limitations. If the MySQL databases on the CD are, for > exam

Re: Using MySQL with its data files on a CD-R (recordable CD)

ransferred from the CD (which will be slower than direct access from a hard drive), as well as the version limitations. If the MySQL databases on the CD are, for example, in MySQL 5.x format, but your end-user is still using MySQL 3.23, it's not going to work. Also, there will need to be some

Re: Using MySQL with its data files on a CD-R (recordable CD)

I believe that this situation could work with ldap, but it is not what I had imagined. I was picturing a database for retail. The database could hold a list of products for sale and details relating to those products. -Michael "Thufir" <[EMAIL PROTECTED]> wrote > On Wed, 05 Mar 2008 00:13:56

Re: Using MySQL with its data files on a CD-R (recordable CD)

On Wed, 05 Mar 2008 00:13:56 -0500, Michael Hemer wrote: > I have been researching to see if it's possible to have a MySQL database > with it's data files on a cd-rom, but could use some help to determine > if I have found out the full truth of what's possible. I would > appreciate any additiona

Using MySQL with its data files on a CD-R (recordable CD)

Hi, I have been researching to see if it's possible to have a MySQL database with it's data files on a cd-rom, but could use some help to determine if I have found out the full truth of what's possible. I would appreciate any additional info people have to offer. The situation I've been think

pam and crypt using mysql

Hello, sorry if this is not the right mailing list to ask this question, hope someone can point me to a better list in the case. My problem is that I'd like to use mysql as database for storing user accounts for different services, and I started using vsftpd. Now, following the instruction here

Using MySQL date/time

Hello guys, I would like to get some registers on my database that are older than 90 days, and after delete it because the table is very larger: mysql> select count(*) from max_ecardsent; +--+ | count(*) | +--+ | 1172330 | +--+ 1 row in set (0.01 sec) But I'm confusing

Re: "segment fault" when using mysql++

wangxu wrote: actually I am using this piece of code,but I replaced fprintf to printf just to simplify the problem. Everything I said about printf() applies equally to fprintf(). The "%s" work-around suggested by Pete Harlan will work, but not for very good reasons. Again: see examples/cgi

Re: "segment fault" when using mysql++

This may be a bit off topic, but if you are making the up-front design decision to use the C++ API instead of the more entrenched C API, why would you use the printf family of functions at all? They are deprecated in C++ in favour of iosteams which avoid the kind of buffer overrun issues you are r

Re: "segment fault" when using mysql++

He's saying that instead of this: >fprintf (fp1, r["content"]); You at least want something like this: fprintf (fp1, "%s", r["content"]); if you're going to use fprintf, or, if you want something more c++-like, you'd use a function besides fprintf altogether. Ot

Re: "segment fault" when using mysql++

actually I am using this piece of code,but I replaced fprintf to printf just to simplify the problem. and the field content actually stores string content. Shall this mean some thing different from your explanation? while (r = res.fetch_row()) { FILE *fp1;

Re: "segment fault" when using mysql++

I'm replying to you both personally and to the MySQL++ mailing list, where this message is on topic. Please reply only on the list, not to me directly. wangxu wrote: below is my code;these code works very fine until, the length of the field "content" exceeds 30, How certain are you abo

"segment fault" when using mysql++

below is my code;these code works very fine until, the length of the field "content" exceeds 30, then "segment fault" happened. how can I avoid this? mysqlpp::Query query = conn.query(); query << "select content from pages where id="

Re: why can I not edit my database using mySQL administrator ?

Are you using MySQL Administrator for Windows ? Are you using it against MySQL running in Linux ? If so, you may prefer MySQL Administrator for Linux. Just a couple more thoughts ... - Original Message - From: "cfaust-dougot" <[EMAIL PROTECTED]> To: "Weiqi Wa

回复： why can I not edit my databas e using mySQL administrator ?

MySQL administrator mainly focus on MySQL server status monitor/use management/security/backup/restore etc. If you want to edite database, you should use MySQL query browser, it's included in MySQL GUI tools package. Weiqi Wang <[EMAIL PROTECTED]> 写道： Dear everyone: I'm trying to si

RE: why can I not edit my database using mySQL administrator ?

using mySQL administrator ? Dear everyone: I'm trying to simplify the operating of mySQL by using a GUI tool, mySQL administrator. But it seems that I was only allowed to view the databases which I have made up, but not allowed to edit them. Is it because I have to buy a lisence or some

why can I not edit my database using mySQL administrator ?

Dear everyone: I'm trying to simplify the operating of mySQL by using a GUI tool, mySQL administrator. But it seems that I was only allowed to view the databases which I have made up, but not allowed to edit them. Is it because I have to buy a lisence or something which I didn't buy? Thanks fo

Using mysql for huge data warehouse - recommendations

so i'm debating between mysql and postgresql so far for choosing our data warehouse platform, and i've been using mysql for about 8 years now and would hate to move into postgresql if possible. mysql definitely has it's pros and cons, but so far, more pros than cons excep

Re: Using MySQL to log and report transactions

In the last episode (Nov 10), James Tu said: > I'm going use MySQL to log transactions so that I can report on them > later. > Ex: > > CREATE TABLE statistics ( >id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT > , user_id BIGINT UNSIGNED > , entity_id INT UNSIGNED > , transacti

Using MySQL to log and report transactions

Hi: I'm going use MySQL to log transactions so that I can report on them later. Ex: CREATE TABLE statistics ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT , user_id BIGINT UNSIGNED , entity_id INT UNSIGNED , transaction_type INTEGER(2) UNSIGNED , datetime_logged DATET

RE: Degrading write performance using MySQL 5.0.24

ata` char(20) default NULL, > `calling_party_on_dest_num_type` int(1) default '0', > `calling_party_from_src_num_type` int(1) default '0', > `original_isdn_cause_code` int(1) default '0', > PRIMARY KEY (`callid`,`cdr_seq_no`) > ) ENGINE=

RE: Degrading write performance using MySQL 5.0.24

crname` char(50) default NULL, `call_dest_custid` char(20) default NULL, `call_zone_data` char(20) default NULL, `calling_party_on_dest_num_type` int(1) default '0', `calling_party_from_src_num_type` int(1) default '0', `original_isdn_cause_code` int(1) default '0&#

RE: Degrading write performance using MySQL 5.0.24

call_dest_crname| char(50) > | YES | | NULL| | > | call_dest_custid| char(20) > | YES | | NULL| | > | call_zone_data | char(20) > | YES | | NULL| | > | calling_party_on_dest_num_type | int(1) > | YES | | 0 | | > | calling_party_from_src_num_type | int(1) >

RE: Degrading write performance using MySQL 5.0.24

l Message- >>>From: Jay Pipes [mailto:[EMAIL PROTECTED] >>>Sent: Wednesday, August 30, 2006 1:44 PM >>>To: George Law >>>Cc: mysql@lists.mysql.com >>>Subject: RE: Degrading write performance using MySQL 5.0.24 >>> >>>What type of data are

RE: Degrading write performance using MySQL 5.0.24

> > -- > George > > > > > > >>>-Original Message- > >>>From: Jay Pipes [mailto:[EMAIL PROTECTED] > >>>Sent: Wednesday, August 30, 2006 12:06 PM > >>>To: Phantom > >>>Cc: mysql@lists.mysql.com >

Re: Degrading write performance using MySQL 5.0.24

On Wed, 2006-08-30 at 09:34 -0700, Phantom wrote: > Here is the schema for the table are generate Sequence Numbers needed per > item and the table that actually stores the data : > > CREATE TABLE SEQUENCE_NUMBER > ( > USER_KEY VARBINARY(255) NOT NULL, > SUBKEY VARBINARY(255)NOT NULL, >

RE: Degrading write performance using MySQL 5.0.24

George >>>-Original Message- >>>From: Jay Pipes [mailto:[EMAIL PROTECTED] >>>Sent: Wednesday, August 30, 2006 12:06 PM >>>To: Phantom >>>Cc: mysql@lists.mysql.com >>>Subject: Re: Degrading write performance using MySQL 5.0.24 >>

Re: Degrading write performance using MySQL 5.0.24

On Wed, 2006-08-30 at 08:31 -0700, Phantom wrote: > We have an application that stores versioned data in MySQL. Everytime a > piece of data is retrieved and written to, it is stored in the database with > a new version and all old versions are subsequently deleted. We have a > request rate of 2 mil

RE: Using MySQL as backend

@lists.mysql.com Subject: Re: Using MySQL as backend sharvan kumar wrote: > Dear Sir/Madam > I am working on a project where I am > to use PHP as front end and MYSQL as backend.MySQL > stand alone is working properly,but it is not > connecting with PHP.Please t

Re: Using MySQL as backend

sharvan kumar wrote: > Dear Sir/Madam > I am working on a project where I am > to use PHP as front end and MYSQL as backend.MySQL > stand alone is working properly,but it is not > connecting with PHP.Please tell me solution. > Connect it. -- Daniel Kasak IT Developer NUS Consul

Using MySQL as backend

Dear Sir/Madam I am working on a project where I am to use PHP as front end and MYSQL as backend.MySQL stand alone is working properly,but it is not connecting with PHP.Please tell me solution. __ Do You Yahoo!? Tired of spam? Yaho

RE: Find invalid email formats using MySQL query.

At 22:10 +0100 20/5/06, Keith Roberts wrote: Probably the most efficient place to do this sort of field checking would be using javascript in the browser. That would stop the bad addresses even being sent down the line to the server in the first place. Sure, but if you're being conscientious ab

RE: Find invalid email formats using MySQL query.

, 20 May 2006, fbsd wrote: > To: Yesmin Patwary <[EMAIL PROTECTED]>, mysql@lists.mysql.com > From: fbsd <[EMAIL PROTECTED]> > Subject: RE: Find invalid email formats using MySQL query. > > You need to use a stronger edit to check email addresses. > This is what I us

RE: Find invalid email formats using MySQL query.

content before adding it is the normal way this is done. -Original Message- From: Yesmin Patwary [mailto:[EMAIL PROTECTED] Sent: Saturday, May 20, 2006 10:48 AM To: mysql@lists.mysql.com Subject: Find invalid email formats using MySQL query. Dear All, My contact table has email fi

Re: Find invalid email formats using MySQL query.

Yesmin Patwary wrote: Dear All, My contact table has email field which contains many invalid email addresses. I find them using following php function. Is there a way to do that check in MySQL query? function emailValidate ($str) { $reg = "^([a-zA-Z0-9._-]+)@([a-zA-Z0-9-])+

Re: Find invalid email formats using MySQL query.

sql@lists.mysql.com > From: Yesmin Patwary <[EMAIL PROTECTED]> > Subject: Find invalid email formats using MySQL query. > > Dear All, >My contact table has email field which contains many > invalid email addresses. I find them using following php > function. Is there a

Find invalid email formats using MySQL query.

Dear All, My contact table has email field which contains many invalid email addresses. I find them using following php function. Is there a way to do that check in MySQL query? function emailValidate ($str) { $reg = "^([a-zA-Z0-9._-]+)@([a-zA-Z0-9-])+(\.[a-zA-Z0-9-]+)+$"; i

RE: viewing data using MySQL Administrator tool

al Message- From: hicham [mailto:[EMAIL PROTECTED] Sent: Thursday, May 18, 2006 6:30 AM To: mysql@lists.mysql.com Subject: viewing data using MySQL Administrator tool Hello using MySQL administrator tool, I can view databases under the catalog folder, but I can't view the data fille

viewing data using MySQL Administrator tool

Hello using MySQL administrator tool, I can view databases under the catalog folder, but I can't view the data filled in the tables, when doing right click table --> Edit table Data , nothing shows up Thanks for your help hicham -- MySQL General Mailing List For list archiv

adding conditional stmt using mysql

equirement is to get the most recent employment record only for those executives who don't have a current employment(active) record and in other case get multiple current employment records. Is there anyway this kind of conditional queries can be written using MySQL? Th

Re: segmentation fault using mysql

At 10:15 AM Saturday, 8/27/2005, Kemin Zhou wrote -=> Ed Kasky wrote: Running MySql 4.1.14 on RedHat 7.2 I just upgraded from 4.1.13 to 4.1.14 and was am experiencing problems using the mysql client. # /usr/local/mysql/bin/mysql -h localhost -u root Welcome to the MySQL monitor. Commands

Re: segmentation fault using mysql

Ed Kasky wrote: Running MySql 4.1.14 on RedHat 7.2 I just upgraded from 4.1.13 to 4.1.14 and was am experiencing problems using the mysql client. # /usr/local/mysql/bin/mysql -h localhost -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 34 to ser

segmentation fault using mysql

Running MySql 4.1.14 on RedHat 7.2 I just upgraded from 4.1.13 to 4.1.14 and was am experiencing problems using the mysql client. # /usr/local/mysql/bin/mysql -h localhost -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 34 to server version: 4.1.1

Re: Using MySQL libraries for a client app

Steven Altsman wrote: cp /usr/local/mysql/lib/mysql/* /usr/lib No no no! There are several better options: 1. Add /usr/local/mysql/lib/mysql to your system's dynamic loader configuration. On Linux, for instance, this is /etc/ld.so.conf; you need to run ldconfig after changing that file.

Re: Using MySQL libraries for a client app

Steven Altsman wrote: checking whether mysql clients can run... no configure: error: Your MySQL client libraries aren't properly installed Read through config.log to see what test was tried, and how it failed. I've looked at the PureFTP archives and they aren't particularly helpful I take i

RE: Using MySQL libraries for a client app

Original Message- From: Steven Altsman [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 11:37 AM To: 'mysql@lists.mysql.com' Subject: Using MySQL libraries for a client app checking for mysql_init i

Using MySQL libraries for a client app

checking for mysql_init in -lmysqlclient... yes checking whether mysql clients can run... no configure: error: Your MySQL client libraries aren't properly installed -

Cost-Effective Database Scale-Out Using MySQL

I just got an email from MySQL concerning web seminar. Since I'm deaf I would like to attend, is there any accomodations that I can use to get in touch? There is a "Video Relay Interpreting" service online and am wondering if MySQL could use that service? -- Please avoid sending me Word or

Re: Exporting a database from one PC to another using MySQL 5.0

Hello. See: http://dev.mysql.com/doc/mysql/en/mysqldump.html http://dev.mysql.com/doc/mysql/en/moving.html http://dev.mysql.com/doc/mysql/en/backup.html "Eric Dahlenburg" <[EMAIL PROTECTED]> wrote: > Hi, > > I am currently a student learning SQL. I have MySQL 5.0 installed at

Re: Exporting a database from one PC to another using MySQL 5.0

ect: Exporting a database from one PC to another using MySQL 5.0 Hi, I am currently a student learning SQL. I have MySQL 5.0 installed at home and on my Laptop. How can I take a database that I have updated on my laptop and transfer it to my home PC so that they are both synchronized ? I trie

Exporting a database from one PC to another using MySQL 5.0

Hi, I am currently a student learning SQL. I have MySQL 5.0 installed at home and on my Laptop. How can I take a database that I have updated on my laptop and transfer it to my home PC so that they are both synchronized ? I tried looking on the forums for this info, but forums locks-up my Interne

No data transfer, using Mysql Toolkit

All, I used migration tool kit from myslq and did migration from Oracle to Mysql. No error occurred, but there are no data transfer? Do I need to set up something on the server before I do migration? Thank younguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Re: error 1418 when creating stored procedure using mysql 5.0.6

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Here are two of the stored procedures I tried, as I had forgotten to send that with my query. I am hoping that the stored procedure will now work, as it hasn't since mysql 5.0.1. Thanx for any help. CREATE PROCEDURE assignItem ( user CHAR(15), ri

re: error 1418 when creating stored procedure using mysql 5.0.6

James Black <[EMAIL PROTECTED]> wrote on 06/06/2005 12:33:40 PM: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > I am curious what has changed in 5.0.6 that leds to this error: > ERROR 1418: This routine is declared to be non-deterministic and to > modify data and binary logging is enabled >

re: error 1418 when creating stored procedure using mysql 5.0.6

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am curious what has changed in 5.0.6 that leds to this error: ERROR 1418: This routine is declared to be non-deterministic and to modify data and binary logging is enabled What should I be looking at changing in my CREATE PROCEDURE call to enable

Re: [PHP] building php, using mysql for apache2

--with-mysql is supposed to be the directory in which configure can find the mysql header (.h) files and the mysql library (mysql.so) underneath that directory. /usr/bin/mysql_config is a program -- a "binary" if you will It's incredibly unlikely that your MySQL header files and the mysql.so libr

Re: building php, using mysql for apache2

hi, have you installed php4-mysql ? look at http://www.coagul.org/article.php3?id_article=169 for example. Mathias Selon bruce <[EMAIL PROTECTED]>: > hi... > > trying to build php4 with mysql4.1-12, for use in apache2. i have the > following "./compile" that works for php5. however, when i try

building php, using mysql for apache2

hi... trying to build php4 with mysql4.1-12, for use in apache2. i have the following "./compile" that works for php5. however, when i try to use it for php4, i get a msg, stating that it can't find the MySQL Headers... can anybody provide any pointers as far as what the Headers are for mysql, an

Re: Using MySQL to store/archive code/html etc?

On Fri, 27 May 2005 15:39:36 -0400, wrote: >news <[EMAIL PROTECTED]> wrote on 05/27/2005 02:46:09 PM: > > >> > >It is possible to do just what you propose. You could even FT index your >code so that you could find certain key phrases (assuming that the >keyphrase you want is at least 4 (or 3)

Re: Using MySQL to store/archive code/html etc?

,Perl,Javascript for and I spend more time going thru CD backups etc than it would take to start again. I've postulated using MySql as a store for such pages. but is a database suitable for storing, searching for and retrieving such information.??? No. Store all the files on a hard di

Re: Using MySQL to store/archive code/html etc?

ory fails to remember which site I developed a > piece of HTML,PHP,Perl,Javascript > for and I spend more time going thru CD backups etc than it would > take to start again. I've > postulated using MySql as a store for such pages. but is a database > suitable for stor

Using MySQL to store/archive code/html etc?

more time going thru CD backups etc than it would take to start again. I've postulated using MySql as a store for such pages. but is a database suitable for storing, searching for and retrieving such information.??? Your eminent opinions and experiences desired!! -- zzapper vim -c &quo

Site search using MySQL fulltext index

Hi, I've implemented my site search using MySQL db fulltext index. I understand that fulltext index currently doesn't support stemming of words. However I want to implement my search such that a query containing words in singular tense matches records of words in plural tense and vice

Re: Date validation using mysql

IL PROTECTED]> > To: "Chris Ramsay" <[EMAIL PROTECTED]>; > Sent: Friday, April 29, 2005 6:10 PM > Subject: Re: Date validation using mysql > > No problem - I followed up and found out that this function is not > available. THought probably you were referri

Re: Date validation using mysql

inal Message - From: "Anoop kumar V" <[EMAIL PROTECTED]> To: "Chris Ramsay" <[EMAIL PROTECTED]>; Sent: Friday, April 29, 2005 6:10 PM Subject: Re: Date validation using mysql No problem - I followed up and found out that this function is not available. THought prob

Re: Date validation using mysql

No problem - I followed up and found out that this function is not available. THought probably you were referring to a later version of Mysql.. anyways... We use Java - and maybe I could use that - I was just wondering if I could help reinventing something already there. Thanks so much for the

Re: Date validation using mysql

Anoop You could try checkdate()... Apologies for erroneous advice - I am evidently suffering from list psychosis... Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Date validation using mysql

You can, sort of. You can use a type of query like this: select if(now()>'2005-04-28', 1, 0); Which will return a 1 or a 0 if the date is greater than the current date/time. But that's a very weak comparison, prone to error, since the date must be in the MySQL readable format. So while you could

Re: Date validation using mysql

You could try checkdate()... chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Date validation using mysql

So is there a function in mysql that I can call to validate dates?? Or do I need to build it? Thanks, Anoop On 4/29/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Anoop kumar V <[EMAIL PROTECTED]> wrote on 04/29/2005 11:00:11 AM: > > > Is it possible to do a date field validation us

Re: Date validation using mysql

Anoop kumar V <[EMAIL PROTECTED]> wrote on 04/29/2005 11:00:11 AM: > Is it possible to do a date field validation using an sql query. > > Its like we have an html field- its a free form text field and the end user > should type in a valid date, of course in a predefined format only > (MM/dd/yy

Date validation using mysql

Is it possible to do a date field validation using an sql query. Its like we have an html field- its a free form text field and the end user should type in a valid date, of course in a predefined format only (MM/dd/yyy). I tried using javascript but either it works on some browsers and not in o

Program using MySQL C api crashes

Hello, I'm a newcomer to MySQL and to databases in general. I'm using MySQL 4.1.9 on a x86-system running Windows XP Pro SP2. I am trying to use the MySQL C api and I've made the following test program in C (hope the indentation isn't lost): #include #include #incl

Re: a query to insert values into two different tables using mySQL Server

Isn't that technically multiple queries? In mysql an insert inserts into one table. That's it. -Eric On Wed, 1 Dec 2004 15:50:15 +0100, ***ADI*** <[EMAIL PROTECTED]> wrote: > in MS SQL u can do it by the following query: > > declare @transool varchar(20) > set @transool = 'opcofficelink' > b

a query to insert values into two different tables using mySQL Server

in MS SQL u can do it by the following query: declare @transool varchar(20) set @transool = 'opcofficelink' begin transaction @transool insert into Table1 (Sine_20_Sec, Sine_30_Sec) values (@Sine_20_Sec, @Sine_30_Sec) insert into Table2 (Sine_20_Sec, Sine_30_Sec) values (@Sine_20_Sec, @Sine_30_Se

Using mysql and mysqladmin

Hello, I have installed "MySQL-server-4.0.22-0.i386.rpm" as server at a linux computer and at the PC (windows 2000) as client was installed "mysql-administrator-1.0.14-win.msi" and "mysql-query-browser-1.1.1-gamma-win.msi". Now I have two questions: Although the installtion at the server was suc

Cast a value as datetime using Mysql prior to 4.0

Hi. In MySql 4.0 you can use the function CAST to cast a value as datetime: CAST(value AS DATETIME), but in versions of MySql you can't. How can I do this cast in other versions of MySql? Iago. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:ht

__libc_read() hangs using MySQL-devel-4.0.18-0

Dear All, I am using mysql C API for my multi-thread program development (using C++ to develop, Using Redhat 7.2 with 2.4.18-3 kernel version, MySQL-devel-4.0.18-0). In some threads, I will open a new mysql database connection to get the data. While sometime I have the problem in

  1   2   3   4   >