Hi Egor,
Thanks for your reply.
> What table was deleted? report_YYYMMDD?
Yes.
> RV> MySQL Log file says nothing.
>
> Nothing about table delete or nothing about error?
Nope.
Robert Vetter
Internet Application Developer
Kontor23 GmbH
Ottenser Hauptstrasse 56-62
22765 Ha
the table is deleted! MySQL Log file says nothing.
Can somone tell me what's going on?
MySQL Version is 3.23.49 and runs on a Linux system (compiled from
sources).
Thanks
--
Robert Vetter
Internet Application Developer
Kontor23 GmbH
Ottenser Hauptstrasse 56-62
22765 Hamburg
Tel.: 040/3808
On Tuesday 21 May 2002 09:51, Robert Vetter wrote:
> On Tuesday 21 May 2002 10:38, Sameer Maggon wrote:
> in /var/www/html/rcmms/appl.php on line 5
>
> Hello,
>
> 1. make shure the PHP module is compiled into Apache, or runs as CGI.
rubbish, sorry. Make shure PHP is compiled
s that mysql_connect
>
> Fatal error: Call to undefined function: mysql_connect()
> in /var/www/html/rcmms/appl.php on line 5
Hello,
1. make shure the PHP module is compiled into Apache, or runs as CGI.
2. If you have more questions: Ple
. After that there is no connection and no new
connection will be created.
What the module do is to read data from HEAP tables from MySQL in a
handler function.
Maybe is using global MYSQL handle not a good solution?
Thanks for help.
Robert Vetter
Internet Application Developer
Kontor23 GmbH
. After that there is no connection and no new
connection will be created.
What the module do is to read data from HEAP tables from MySQL in a
handler function.
Maybe is using global MYSQL handle not a good solution?
Thanks for help.
Robert Vetter
Internet Application Developer
Kontor23 GmbH
1.id
> group by number order by number desc
Hello,
I don't know what exactly you want to count, but one thing seems to be
obviously to me: You can't make a left join between t2 and t3 on
t3.id_t1=t1.id (line 3 of the query).
Pozdrowienia do Polski,
Robert Vetter
-
D'Arcy Rittich wrote:
>
> > Actually you dont't need a ocx. You can call the MySQL API functions,
> > which are in a dll file.
> >
> > Robert
>
> Do you have any examples of that with VB?
No, I don't. But you can take a look at an example written in C.
Robert
---
Cyber Monkey wrote:
>
> Has seen an ocx for the MySQL++ to allow Visual Basic to control MySQL databases?
>
Actually you dont't need a ocx. You can call the MySQL API functions,
which are in a dll file.
Robert
-
Before post
Fayed Design wrote:
>
> - Original Message -
> From: Fayed Design
> To: [EMAIL PROTECTED]
> Sent: Friday, May 18, 2001 1:14 PM
>
> Hello to all of you,
> does anybody know how to connect an Java Applet with mySql.I am trying already since
>weeks,no success.
>
> It always response no
install as usual.
Now when I try to run mysql_install_db I get this error: "Didn't find
/usr/local/libexec/mysqld. You shold do a make install...".
How can I configure my system, so that mysql knows mysqld is in
/usr/local/mysql/libexec/ now? I use Linux Debian.
Thanks
Jeremy Zawodny wrote:
>
> On Thu, Apr 26, 2001 at 07:36:34PM -0700, Rodney D. Myers wrote:
> >
> > Is there a place to purchase the MySQL manual?
>
> The folks at NuSphere will sell you one for $79 or so. You'll get a
> CD, printed manual, and support for the software.
What? I hope you don't
Sven Heising wrote:
>
> Hi list,
>
> I'am new in this php and mysql-stuff so i need al lil bit support...
>
> this is my problem:
> $result = mysql_query("select * from $dbtable where $wonach like
> '%$first_name%' ");
>
> $wonach is a var which is set in a html form if i want to search
Fabio Galarraga wrote:
>
> Hi to all:
> I have a linux script and I need it can execute some mysql commands.
> Is it possible? If possible, how?
Simply put the SQL commands in a text file. To execute them in the bash
script you use the mysql client program:
mysql -u user -p password the_datab
> Yann Larrivée wrote:
>
> Thanks for the answer but it is a bit more complexe, i actually
> creates these sample table for the example. Here is an attachement of
> the structure dump.
>
> Hummm you got me to think more about my database structure withc is
> really good. The idea you bourght u
Hello,
I have just had a little problem with a SELECT query like this:
SELECT DATE_FORMAT(Day,"%e.%m.%Y") AS ftag,* from TheTable;
this query returns an SQL error: ERROR 1064: You have an error in your
SQL syntax near '* from TheTable' at line 1
BUT:
SELECT *,DATE_FORMAT(Day,"%e.%m.%Y") AS ft
Joris Kluivers wrote:
>
> hi,
>
> i have a problem
> i have a database table created with the statement:
> CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT,
>message text, username varchar(100), UNIQUE id (id);
>
> I insert records with:
> INSERT INTO chatmessages
"Thalis A. Kalfigopoulos" wrote:
>
> > > Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is
> > > closest to the boolean type
> >
> > ShortInt: 0 == FALSE, <> 0 == TRUE
> > That's how I do it anyway.
> >
> > Or maybe combine multiple bool fields to one and use binary l
[EMAIL PROTECTED] wrote:
>
> On 01.03.2001 13:51:58 Robert Vetter wrote:
>
> > ENUM("no","yes")
>
> I always wondered: How much space does this take?
1 or 2 bytes, depending on the number of enumeration values (65535
values maximum).
Blaz Grapar wrote:
>
> Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is closest
>to the boolean type
ENUM("no","yes")
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
Evan James Dembskey wrote:
>
> Hi,
>
> I have this statement:
>
> res = mysql_query(&my_connection, "SELECT * FROM student WHERE studnum =
> 31665222");
>
for example something like this:
char query[96]="SELECT * FROM student WHERE studnum=";
int studnum;
studnum=get_studnum();
s
21 matches
Mail list logo