Re: insert subquery

[EMAIL PROTECTED] wrote: DJ wrote on 09/23/2005 12:22:58 PM: i want to insert a row into table1 only if the value being inserted on table1 exists on table2 primary id. can i do this with subquery? thanx. Depending on what version MySQL you are using, probably not. A very robust

insert subquery

i want to insert a row into table1 only if the value being inserted on table1 exists on table2 primary id. can i do this with subquery? thanx. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.5/110 - Release Date: 9/22/2005 --

Questions regarding mysql architecture

Hello, I've been looking through the source code for version 4.0.10-gamma trying to discern how exactly this thing runs by tracing back through the various inits() but because of how poorly it has been documented its slightly overwhelming to figure out what structures belongs to what modules o

Re: easy question

>Is there a way to have the timestamp automatically inserted when an >insert statement is run? The timestamp of the insert statement. Try now() Hisseine - Original Message - From: "chad kellerman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 9:59 AM Subje

Re: help with mysqlhotcopy

> I was wondering if someone could help me out with the syntax to use > mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've > tried a few variations of the command but with no luck so far. The > mysql server is running on RH 7.2 and the DAT tape drive is on that same > machine

Re: Can I connect to a MySQL Database on a unix platform from a PC?

> As a potential MySQL customer, I am trying to find the answer to the > question "Can I connect to a MySQL Database on a unix platform from a PC > through TCP/IP network? If the answer is yes, what other additional > supporting software will be needed on the Unix platform and on the PC? Any > poi

Re: Automatic Primary Key for "circular table"

You can use timeval struct and create a field in your Database as double, and then use these two value tv_sec, and tv_usec to build you PK. Hisseine - Original Message - From: "Jonathan Pelletier" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 29, 2002 10:45 AM Subj

Fw: link problem

- Original Message - From: "Hisseine Dj." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 09, 2002 2:40 PM Subject: Re: link problem > > > gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient > > > -lm -

Re: link problem

> > gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient > > -lm -tz -> Replace the -c option with -o Hisseine - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 09, 2002 1:43 PM Subj

Re: C++ API for Mysql

Hi Carsten, I've tried Mysql++ and SQLAPI. I am asking if someone out there know about other best tools in C++ for Mysql on linux. Thanks, Hisseine - Original Message - From: "Carsten Gehling" <[EMAIL PROTECTED]> To: "Hisseine Dj." <[EMAIL PRO

C++ API for Mysql

Hello, Can someone tell me if there is an C++ API that works smooth with MYSQL on linux. So far I was trying msql++ and SQLAPI++. SQLAPI++ seems to be good by there are problems when runing the program. My system is Redhat 7.2 and Mysql 3.23.49 Thanks, Hisseine -

C++ API for Mysql

Hello, Can someone tell me if there is an C++ API that works smooth with MYSQL on linux. So far I was trying msql++ and SQLAPI++. SQLAPI++ seems to be good by there are problems when runing the program. My system is Redhat 7.2 and Mysql 3.23.49 Thanks, Hisseine --

Re: Mysql.sock missing

Don't worry if it's running then you can find that file else where on your system; try to look for in /tmp Hisseine - Original Message - From: "Charitha" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 4:58 AM Subject: Mysql.sock missing > > Hello all, > > I a

Re: Cant connect using socket ''(111) for Mysqlgui on linux

Verify if your MySQL server is running and the user and password when entering Mysqlgui1.7.5 I have the same on Linux and it's running fine. Hisseine - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, April 2

Re: Newbie: Test for MySQL connection

Try shell> cd YourMysqlInstallationDirectory shell> bin/safe_mysqld & shell> mysql -h host -u user -ppassword Hisseine - Original Message - From: "Fei Chen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 10:36 AM Subject: Newbie: Test for MySQL connection >

Re: mysql client issues

> ld.so.1: mysql: fatal: libncurses.so.5: open failed: No such file or > directory What kind of system are you using? Linux? Verify on your system for libncurses.so, it should be in /usr/lib. If you have that library on your system then check for library path Hisseine - Original Message --

Re: Enterprise Manager (?)

Hy Johnny, I try to install MySQL front on Window 2000. When I run it to connect to mysql server on Linux, I got an error saying this host (my client) cannot connect to the mysql server. It seems to be a configuration on the mysql server, any idea. Thanks, Hisseine - Original Message

Re: Graphical UI for MySQL

Try mysqlgui, this is a tool that can give you the ability to do some admin. Hisseine - Original Message - From: "Kela Vesa" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 2:48 AM Subject: Graphical UI for MySQL > Greetings, > > I would like to ask you follow

Re: mysqladmin

Thanks Egor, I just did it now and I find that. I start the installation today so that's I am missing some elements. Again thanks for your help. Hisseine - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 12:22 PM Subject

mysqladmin

Hi all, I just downloaded the MySql rpm file : MySQL-3.23.49a-1.i386.rpm I did the installation on linux redhat 7.2, everything is ok, but I can't locate the msqladmin command. I try find command as root but nothing in the result. Does binary files are missing in this version? Thanks, Hisseine

Re: About BLOBS

Thanks Paul, Hisseine - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Hisseine Dj." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 10:40 AM Subject: Re: About BLOBS > >Hello, > > > &

About BLOBS

Hello, Does MySqL database supports BLOBs operation? (Insert, delete etc ...) If yes which API can use to do these operations? (MySqL++)? Thanks for help - Before posting, please check: http://www.mysql.com/manual.php

Re: binding to more than one ip address.

I only want to run 1 copy of mysql.. just bind 2 two different ip addresses.. one localhost.. and one of my external addresses.. i want to only have one copy running thou. DJ - Original Message - From: "Chris Bolt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sen

binding to more than one ip address.

addresses without binding to EVERY ip address, and not just ONE ip address. I hope someone can help. DJ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the