the correct communication for
the tables, or where am I going wrong with the two above attempts?
Thank you,
-Patrick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sorry about that..
$totalrows_rsComments gives a value of 0. But no matter what I do I
can't seem to alter it. It stays at zero.
-Patrick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Daniel da Veiga wrote:
> On 4/25/06, -Patrick <[EMAIL PROTECTED]> wrote:
>
>> Hi Folks,
>> Here is the table for the articles:
>>
>> CREATE TABLE `blg_article_art` (
>> `id_art` int(11) NOT NULL auto_increment,
>> `idtop_art` int(11) NOT NUL
y given to output a number.. using
mysql_num_rows(). But Im getting syntax and check line errors..
Any thoughts?
-Patrick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Philippe Poelvoorde wrote:
> 2006/4/25, -Patrick <[EMAIL PROTECTED]>:
>
>> $query_rsComments = sprintf("SELECT id_com WHERE idart_com=%s ORDER BY
>> date_com ASC", $KTColParam1_rsComments);
>>
>>
>> can anyone see what Im trying to do he
iated.
Thanks
-Patrick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
;
It is supposed to print the month only IF it there is entries matching
the date. So if there were 3 entries made for one month, then all
entries for that month should be printed. Right now, this prints every
row in existence.
-Patrick
--
MySQL General Mailing List
For list ar
not cool.
Thanks
-Patrick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
John Hicks wrote:
> -Patrick wrote:
>> Folks, I could really use your assistance.
>> Take a look here: http://pastebin.com/687889
>>
>> How can I manipulate totalRows_numberComments so that I get the number
>> of blg_comment_com.idart_com PER blg_article_art.id_art
Historically any form of punctuation, parameter delimiter, or filepath
delimiter in either a database name, field or column name, file or table
name would not be recommended; even if the RDBMS or File Handler allows it.
If you are able to stick to alphanumeric characters using underscores
char
825 SE 47th Terrace
Cape Coral, FL 33904
- Original Message -
From: Chance Ellis
To: Patrick
Sent: Monday, October 03, 2005 2:22 PM
Subject: Re: Table names with periods
Patrick,
I have been trying to figure out how I can convert an IP address to a 32bit
integer within a S
ad, that he wasn't looking for
help in db design, just a solution to the punctuation issue.
Pat...
- Original Message -
From: [EMAIL PROTECTED]
To: Patrick
Cc: Chance Ellis ; mysql@lists.mysql.com
Sent: Monday, October 03, 2005 4:30 PM
Subject: Re: Table names with periods
Repl
What type client are you using?
With the C API you would test for the return value (0 or 1) and process
accordingly.
You could use 'INSERT IGNORE' syntax, but then you would not know what
records failed (you could test for how many were inserted with mysql_info()
using the C API).
See Chap
I'm wondering if there's any way to force updates on InnoDB tables to
require an explicit COMMIT when running queries from the mysql
command-line client (similar to Oracle's command line client)?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
t they are from the
command-line client. Is there a way to set this just for the client,
like some option that would go in the [mysql] section?
Patrick
On 3/28/06, Wolfram Kraus <[EMAIL PROTECTED]> wrote:
> patrick wrote:
> > I'm wondering if there's any way to force updates
I've confirmed that this does affect ALL incoming connections.
On 3/30/06, patrick <[EMAIL PROTECTED]> wrote:
> Is there any way to make this the default behaviour? I did a Google
> search, and it was suggested I put the following line in /etc/my.cnf:
>
> [mysqld]
> init
Check your border router access list.
Patrick Sherrill
patr...@coconet.com
Coconet Corporation
SW Florida's First ISP
(239) 540-2626 Office
(239) 770-6661 Cell
Confidentiality Notice. This email message, including any attachments,
is for the sole use of the intended recipient(s) an
Do you have to do something special with InnoDB tables to accept
various character sets like accented, European characters? Using the
default, these accented characters come out as garbage.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
The return you are getting is correct for the format you are using. A 90
second difference is in fact 1 minute, 30 seconds(130).
To get the time difference in seconds convert the datetime or timestamp to a
julian date or unixtime and then process.
SELECT start_time, end_time, UNIX_TIMESTAMP(end_
Make sure the permissions on the file are set to executable. Assuming your
platform is some *nix variant, login as root or owner. Change to the
directory where your mysqld is located (/usr/local/mysql/libexec) and
execute the following command:
chmod 755 *
This will ensure the binaries and script
If you've got 157 errors it probably won't be to hard to track down. What
are the 1st couple of errors? You probably don't have your environment set
correctly.
Pat...
[EMAIL PROTECTED]
SW Florida's 1st ISP
- Original Message -
From: "Ron Ohmer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED
Well said Dan. While foreign keys, cascades and built-in transactions are
convenient, atomicity and referential integrity are readily attained by
proper implementation and the appropriate code.
Setting buffers,dirty flags and commit functions really is the
responsibility of the applicatio
ting slow
> At 09:49 AM 12/9/2004, Patrick Marquetecken wrote:
> >Hi,
> >
> >I have 3 snort sensors logging to a central mySQL database after two
weeks
> >the size of the database is about 3.3GB and the machine is getting slow,
> >as i'm not used to be work
punctuation are frequently used as delimiters in other programs, os's and
applications, so when you use them in elements other than strings you often
limit the portability (i.e. import and export) of your structures.
I hope you find this information valuable.
Pat...
Patrick Sherrill
Co
Try BETWEEN
I hope this helps.
Pat...
Patrick Sherrill
CocoNet Corporation
SW Florida's 1st ISP
825 SE 47th Terrace
Cape Coral, FL 33904
- Original Message -
From: "Scott Haneda" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Sent: Tuesday,
Hi,
Sql Porter Might Be Of Some Help, But Alas Its Not Free...
P
Prasad Budim Ram wrote:
> Hi,
>
> Are there any tools to migrate db schema as well as data from sybase
> to mysql?
>
> Thanks,
> Prasad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
Hi,
Im currently using mysql 4.0.15
what could i do in the my.cnf to make it work better faster :)
i use innodb
and its a linux box with kernel 2.4.23_pre
and its got xfs on it and its got a gig of ram as well as 2x 2.6ghz
hyperthreading xeons
P
--
MySQL General Mailing List
For list archives
Bob,
Try:
UPDATE pictures set caption = REPLACE(caption,'www.bob.com',www.bubba.com')
WHERE caption like '%www.bob.com%'
Make sure you backup or copy data before trying...
See MySQL Manual 'Language Reference->String Functions'
I hope this helps...
Pat...
CocoNet Corporation
825 SE 47th Ter
You should not have any problem. The only caveat is ensure you have the same
version and directory structure.
Good Luck!
Pat...
Patrick Sherrill
Southwest Florida's First ISP
CocoNet Corporation
- Original Message -
From: "Ansari, Raza (GEI, GEFA)" <[EMAIL PROTE
to
bring it in sync with your existing database.
Alternatively, if you don't need the data from the existing database drop it
and recreate it. Then run your dump against it, followed by the necessary
alter table statements.
I hope this helps...
Pat...
Patrick Sherrill
CocoNet Cor
ittle more helpful.
Pat...
How many rows are we talking about here? Would hand editing your sql file
be reasonable
- Original Message -
From: "Ronan Lucio" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 06, 2004 5:37 PM
Subject: Re: mysqldump
> Pa
?>
I hope this helps...
Pat...
Patrick Sherrill
CocoNet Corporation
SW Florida's 1st ISP
825 SE 47th Terrace
Cape Coral, FL 33904
- Original Message -
From: "Scott Swaim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 21, 2004 1
help.
Pat...
- Original Message -
From: "Valère Palhoriès" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 21, 2004 6:50 PM
Subject: Re: Problems adding table to Crystal Reports using ODBC Connection
> Patrick,
>
> Yes I am. If I create a Linked T
Agreed...
Pat...
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 17, 2003 2:52 PM
Subject: Re: AW: EMS MySQL Manager for Linux 1.15 released!
> Absent a list for MySQL-centred products & their support, I appr
Yeah, 'Desktop Class' cross-platform with RPC and Client/Server no less. We
have MySQL deployed on over 15+ servers across multiple OS's with clients
written in C, C++, VB and PHP. Oh yeah, I have it on my W2K desktop too!
I guess I may be being a little sensitive, but I think one should take car
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Patrick" <[EMAIL PROTECTED]>
Sent: Thursday, March 14, 2002 2:05 PM
Subject: Re: Replication 2 way
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. T
SELECT * from table ORDER BY column DESC, LIMIT 100
This will get the last 100 in descending order. If you have a date field
you can use a WHERE clause with ORDER BY date field with the LIMIT parameter
to achieve an ascending order.
I hope this helps.
Pat...
- Original Message -
From:
I believe the timestamp field needs to be nullable, but you shouldn't have
any issue selecting a char. Can you run the query from mysql interface? If
you can, than I would suspect that ADO is the culprit, try using straight
ODBC instead.
I hope this helps...
Pat...
- Original Message
Ok could some kind soul point me to the doc's for reseting the index
after deleting a few records below is my database and I did a
delete where rec >0 and it worked however the index is still at 6 how
can I correct this or reset the index to the number of records in the
data base hum...
Than
>Description:
After installing MySQL-3.23.39-1.i386.rpm, /usr/bin/mysqladmin
cannot be found.
>How-To-Repeat:
Don't know.
>Fix:
Don't know.
>Submitter-Id:
>Originator:Patrick Linstruth
>Organization:
>MySQL support: none
>
O' MyT SQL wizards!
I'm a total newbidiot w/ regard to MySql. I bought the O'Reilly
book and it's been a big help, but I have a problem that book
doesn't even gloss-over:
One table has a (large) list of developers (100,000+), each of
which can be a member of 0-5 project teams.
Another table is
I share in that, Ansgar developed a very commercially sound product that he
shared with the community.
Thank-you Ansgar,
[EMAIL PROTECTED]
Patrick Sherrill
And avid MySQLFront fan and user.
CocoNet Corporation
- Original Message -
From: "Manuel Villasante" <[EMAIL P
hey all,
I have a table "mytable" that looks like this:
id tinyint primary key auto_increment
row1 varchar 150
row2 varchar 150
I would like to remove all duplicates, which means that if n records
have the same row1 and row2, keep only one record and remove the
duplicates. Any idea how to do this?
I have a table confs like this:
id int 5 auto_increment primary key;
conf text;
and another table conf_ip like this:
id int 5 auto_increment primary key;
conf_id int 5; ==>foreing key of confs
ip varchar 150;
I would like to
select id, conf from confs where ip!='some val';
how can I do this?
th
On 4/26/06, Patrick Aljord <[EMAIL PROTECTED]> wrote:
> I have a table confs like this:
> id int 5 auto_increment primary key;
> conf text;
>
> and another table conf_ip like this:
> id int 5 auto_increment primary key;
> conf_id int 5; ==>foreing key of confs
> ip
On 4/26/06, Shawn Green <[EMAIL PROTECTED]> wrote:
>
>
>
> --- Patrick Aljord <[EMAIL PROTECTED]> wrote:
>
> > On 4/26/06, Patrick Aljord <[EMAIL PROTECTED]> wrote:
> > > I have a table confs like this:
> > > id int 5 auto_increment pr
Niels Larsen wrote:
Niels,
Do you mean in the Makefile for zlib?
Thanks!
Patrick
Connie,
I had the same error with another program recently, but probably the
fix for yours is the same: try compile zlib with -fPIC by adding
" -fPIC" to CFLAGS in the Makefile.
Niels Larsen
Logg
I would like to prohibit the value 'xxx' on my column title, and if it
does contain the value I would like to create an exception by
assigning 'xxx' to the primary key id which is int(5).
This is what I do but I get an error on its creation so I guess it's
not the right way:
CREATE TRIGGER testre
I meant the error is:
mysql> CREATE TRIGGER testref BEFORE INSERT ON bookmarks
-> FOR EACH ROW
-> BEGIN
-> IF NEW.title LIKE '%xxx%' THEN
-> SET NEW.id ='xxx';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version f
thanx it works the trigger is created successfully but it has no
effect. here it is:
delimiter //
create trigger testref before insert on bookmarks
for each row
begin
declare dummy char(2);
if new.title like '%xxx%'
then
set new.id='xxx';
end if;
end;
//create t
On 10/7/06, Patrick Aljord <[EMAIL PROTECTED]> wrote:
thanx it works the trigger is created successfully but it has no
effect. here it is:
delimiter //
create trigger testref before insert on bookmarks
for each row
begin
if new.title like '%xxx%'
then
Folks,
Go with what you know best. If you are a good Windows admin etc go with
windows. If you are a good Linux/Unix admin go with Linux. What little
performance gain from one or the other will be lost if you do not run a
tight ship all around. Performance and stability goes way beyond what
OS
t referenced in slave.o) (data)
collect2: ld returned 1 exit status
make[4]: *** [mysqld] Error 1
I'm using the GCC binary from the HP-UX Software Porting Archive site:
Output of GCC -v:
Using built-in specs.
Target: hppa2.0w-hp-hpux11.11
Configured with: ../gcc/configure
Thread model: s
ibdata7:500M;ibdata8:500M;ibdata9:500M;ibdata10:500M
:autoextend
Also in this case I got the same error message.
What should I do in order to convert this table?
Should I set in the innodb_data_file_path for example 50 Files, each big 4GB
?
Thanks a lot for your help.
Best regards,
Patrick
PS:
o use
innodb_data_file_path?
Thanks a lot and regards,
Patrick
> -Original Message-
> From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]
> Sent: Sunday, 15 January 2006 15:09
> To: Patrick Herber
> Cc: mysql@lists.mysql.com
> Subject: Re: ERROR 1114 (HY000): The table is f
Hi,
Do you mean you have such a structure
Table A
ID_a
ID_b
ID_c
...
Table B
ID_b
Value_b
...
Table C
ID_c
Value_c
...
?
In that case you can
SELECT Value_b, Value_c
FROM A
LEFT JOIN B on A.ID_b=B.ID_b
LEFT JOIN C on A.ID_c=C.ID_c
WHERE ID_a=xxx
Regards,
Patrick
> -Origi
Do you mean something like that?
UPDATE tablename SET date2=DATE_ADD(date1, INTERVAL -3 MONTH)
Regards,
Patrick
> -Original Message-
> From: Shaun [mailto:[EMAIL PROTECTED]
> Sent: Monday, 16 January 2006 15:27
> To: mysql@lists.mysql.com
> Subject: UPDATE Date Column
I would suggest a union
SELECT name, count(*)
FROM (SELECT name1 as name from mytable union select name2 as name from
mytable union select name3 as name from table)
GROUP BY name
but perhaps there's a better way...
Regards,
Patrick
> -Original Message-
> From: Critt
Bonjour,
J'utilise une technologie CMS, installée depuis l'année dernière sur une
base MySQL 4.0.16-nt. Le CMS à crée lui meme lus tables et y fait référence
en utilisant l'encodage UTF-8.
Depuis, nous avons migré à la version MySQL 4.1.16-nt et l'encodage par
défaut choisi a été latin_swedish
Hi,
We have moved from Mysql4 to MySQL5 and are currently planning our new database
schema. In this new approach we would like to move to InnoDB's storage engine
for transaction support and still want to use MySQL's FULLTEXT search
capabillities. And to make things easy we also want to replica
Hi,
I am running MySQL 4.0.1 with j/connector 3.1 and I am having problems
trying to figure out why I am not getting the results I am expecting.
I have a table that is used for generating primary keys. It only has one
item, an int that is incremented each time a key is needed. This is not m
executeUpdate(updateQuery);
...
c.commit();
c.setAutoCommit(true);
If I have multiple instances of this code running I end up with duplicate
keys. I thought this was suppose to lock the table so that would not happen.
What am I not doing right? What am I not understanding about locking?
Thanks
Patrick
At 10:52 AM 2/10/2006, [EMAIL PROTECTED] wrote:
Patrick Duda <[EMAIL PROTECTED]> wrote on 10/02/2006 16:28:56:
> I guess I don't understand this locking stuff. I have a InnoDB table
that
> has one thing in it, a counter. All I want to do is have multiple
> instances o
At 12:54 PM 2/10/2006, Mark Matthews wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Patrick Duda wrote:
> I guess I don't understand this locking stuff. I have a InnoDB table
> that has one thing in it, a counter. All I want to do is have multiple
> instances of the
Why, when I create a table as follows:
mysql> create table requestid ( request_id int not null default
1, constraint requestid_innodb_pk_cons primary key(request_id) )
ENGINE=InnoDB;
Query OK, 0 rows affected (0.02 sec)
Do I get the following?
mysql> select request_id from requestid
+
|3 |
+--+
Can you please tell me what the problem could be and what can I do to solve
it?
Thanks a lot!
Regards,
Patrick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stop the service during the
week) and tell you the results.
Shall also perform a REPAIR TABLE?
Regards,
Patrick
> -Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 04 April 2006 10:34
> To: Patrick Herber; mysql@lists.mysql.com
> Subject: R
Hello,
I wanted only to report that I removed and re-added the Index as Martijn
suggested and now it's OK.
Thanks again for your help
Regards,
Patrick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I seem to recall the issue with the debug library, but don't recall the fix.
Do you get the same permissions (access) error with the release library?
Pat...
- Original Message -
From: "Miguel Cardenas"
To:
Sent: Saturday, January 10, 2009 10:22 AM
Subject: VC++ 2008 / MySQL debug / U
>Email: john.dais...@butterflysystems.co.uk
>
>
>
>
>
> --
> Best Regards,
>
> Prabhat Kumar
> MySQL DBA
> Datavail-India Mumbai
> Mobile : 91-9987681929
> www.datavail.com
>
> My Blog: http://adminlin
Logical Processor(s)
Installed Physical Memory (RAM) 4.00 GB
Total Virtual Memory 6.75 GB
Page File Space 3.37 GB
Disk 120GB SSD with 22GB available
If this isn't the right place to ask this question, can someone point me to
somewhere that is.
Thanks
Patrick
Are you using...
m
That's true for the deletes - but not for save and get. The ddl is available
here
http://cipl.codeplex.com/SourceControl/changeset/view/2460#57689
The code that accesses it is here
http://cipl.codeplex.com/SourceControl/changeset/view/2460#57729
Patrick
myList<http://www.my
LT CHARSET=latin1;
This is just the retrieve side - which seems to be around 1.5 times slower than
the equivalent Sql Server numbers.
The update is much slower - 3 to 5 times slower depending on the record size.
It makes sense to me to focus on the retrieve, maybe the update is just a
reflecti
Thanks Martin, though I'm somewhat confused by your message - there are no
joins in the query (unless the longtext s thought of that way) and the Explain
seems to indicate the query is using the ItemsById primary index (which is what
I would expect).
Patrick
myList<http://www.my
FF'
'innodb_log_buffer_size', '1048576'
'innodb_log_file_size', '25165824'
'innodb_log_files_in_group', '2'
'innodb_log_group_home_dir', '.\'
'innodb_max_dirty_pages_pct', '90'
'innodb_max_purge_lag',
Sorry, that should be 200MB not 20MB (still doesn't seem like much to me)
Patrick
myList - everything you could possibly want (to buy)
-Original Message-
From: Patrick Thompson
Sent: Monday, October 25, 2010 5:24 PM
To: 'Gavin Towey'; mysql@lists.mysql.com
Subject: RE: m
ts current incarnation - so I consider it to be
accurate, at least in that respect.
Patrick
myList - everything you could possibly want (to buy)
-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Tuesday, October 26, 2010 3:52 PM
To: Patrick Thompson; mysql@lists.mysql.c
We always store as strings to avoid rounding issues and then convert for calcs
to whatever precision we need.
Pat...
Sent from my iPhone
> On Dec 17, 2014, at 6:24 AM, Lucio Chiappetti wrote:
>
>> On Tue, 16 Dec 2014, Hartmut Holzgraefe wrote:
>>> On 16.12.2014 15:16, xiangdongzou wrote:
>>>
Hey all,
I have comments(id,content) and votes(comment_id,vote). vote is a tinyint.
I would like to select total votes for each comment, I tried:
"select content, sum(v.votes) from comments c left join votes v on
c.id=v.comment_id"
but it only returns first result obviously, any idea how I coul
Hi all,
I'm doing a "select * from comments where c.content REGEXP
'http://[^i].*'" and I would like to sort the urls found by repetition
of the same urls.
As an example if I get 3 records with http://google.com url in the
content and two with http://mysql.com I would get the first the 3
comments
hey all,
I have my query that counts posts per user:
SELECT count(*) as counted, c.user_id FROM posts c group by c.user_id
having counted>1 order by counted DESC LIMIT 20
I wanted to add user login for each count so I did:
SELECT count(*) as counted, u.login FROM posts c left join users u on
p
> Your doing a left join which can increase the number of rows returned.
> This is then GROUP BYed and run through a HAVING. Is:
> posts.poster_id=users.id
> a one to one relationship? If it is not, then count(*) would be a
> larger number and pass the HAVING. This may not be your problem, but
Hello,
I successfully changed ft_word_min_len to '1' + rebuilt my fulltext
index (dropped and readded it). But - for some reason the mysqlD still
does not return anything unless the wordlength is >=3.
Any thoughts about this?
regards,
Patrick
--
MySQL General Mailing
Hey all,
I host my app on a friend server who make backup every night, well
yesterday he installed another distro so I asked him for my db backup
and it turns out the only backup he did was the whole hard drive. So
he just sent me a tarball of my database directory containing:
ads_categories.MYD,
hey all,
I have two tables like that:
artists(id,name)
albums(id,artist_id,album_name)
and I need to transfer the data of this database to three tables that
look like this:
artists(id,name)
albums(id,name)
artists_albums(album_id,artist_id)
any idea what's the fastest query to do this?
thanx i
Hey all,
I have a table 'clients' like this:
id int(5),
name varchar(55),
address varchar(55)
I would like to select all the records that have '%x%' and '%y%' but
'%x%' can be in name and '%y%' can be in address. Also in my query
there are generally more words to match (x,y,z,t etc) and I can't u
Hey all,
I have 2 tables:
Profiles(id).
Relationships(id,friend_id,befriender_id).
friend_id and befriender_id represent profiles ids.
I want to find all the profiles that are neither friends neither
befrienders with a given profile.
this is the query I use with profile id=1:
select * from pro
7;#'
--fields-optionally-enclosed-by='"' --ignore-lines='1' --replace --verbose
recepten /tmp/recepten.txt
I see in some text fields:
4 stuks bizonmedaillon Covee
some strage signs like and anyone a idea how i get rid of it?
Patrick
--
Sex is like hacking. You get in
Hi,
I seems not to figure out how to import a xml file into mysql 4.x
I'm working on, Linux, help would he fine.
Patrick
--
"You're dead, Jim."
-- McCoy, "Amok Time," stardate 3372.7..
Fingerprint = 2792 057F C445 9486 F932 3AEA D3A3 1B0C 1059 273B
ICQ# 31693270
it's dependent on the OS
having the Jet engine. I'd be very interested to know if anyone has
done an equivalent to that in Linux.
--
___ Patrick Connolly
{~._.~}
_( Y )_ Good judgment comes from experience
(:_~*~_:) Experience comes from bad jud
ny thoughts?
--
Patrick Campbell
OurVacationStore.com
Website Administrator
Tel. 602.896.4729
Statically linking using C API only you will need mysqlclient.lib
For odbc interface you'll need to make odbc calls in your code and use
myodbc.dll (Install myodbc on the client).
You can mix calls, but why would you. I have found the C API to be the best
solution for us. We statically link fo
Brian,
I think you are going to need to rename your fields/columns. If you are
unable to rename them in mysql then you will probably need to rename them in
your jet database with Access and re-import them.
Your column names should be literals not wrapped in graves or quotes and
should contain no
What is the syntax of your call to connect to the MySQL server?
It seems as though no server parameters are being passed, thereby defaulting
to the local machine which apparently has no mysql server running.
Pat...
CocoNet Corporation
SW Florida's First ISP
- Original Message -
From:
quot;Arunachalam" <[EMAIL PROTECTED]>
To: "Patrick Sherrill" <[EMAIL PROTECTED]>
Sent: Tuesday, December 30, 2003 8:44 AM
Subject: COBOL Syntax of calling MySQL's C API
> Hello Patrick,
>
> The actual calling routines in C is;
>
> MYSQL *mysql_real_connect(MY
your parameters and data types for mysql_real_connect and ensure the
server you are attempting to connect to is in fact running and accepting
connections.
Also don't forget to reply to the list.
Pat...
- Original Message -
From: "Arunachalam" <[EMAIL PROTECTED]>
To: "Pa
pe problem. The parameters being
passed from your COBOL program, are not getting to the 'C' routine as the
correct data types or parameters (remember NULL is not zero).
Pat...
- Original Message -
From: "Arunachalam" <[EMAIL PROTECTED]>
To: "Patrick Sher
m work right and stay
working after each and every patch, or upgrade of the M$ compiler and
operating system. Most programmers who use M$ C compiler constantly
complain they must write code that works around a bug in the compiler or
OS, only to have to rewrite the code after M$ tries to fix
access to the SQL server. They would need to access the
webserver which has programs on that allows limited in-direct access to the
SQL server. Hope this helps.
Patrick Shoaf
IT Manager
At 02:41 PM 1/19/2004, [EMAIL PROTECTED] wrote:
Could someone please tell me if tyhe following is possible
Folks,
Is InnoDB activated by default in MySQL V4 or V4max? Do I have to
compile from source with the innoDB flag in order to use the innoDB
tables or just in stall the RPM?
Patrick
1 - 100 of 340 matches
Mail list logo
