>Hi,
>I'm having the following sql problem:
>I have two datetime fields (start and end), I need to find out if the
>month is either equal to start-month or equal to end-month but also
>if it's a month between start and end. I also check if the end-date
>is greater than today so it's a current one.
Hi! all,
I am linking the mysql client library using -l option i.e.
-lmysqlclient. I have also specified the path of the libmysqlclient.a.
But every time i make, i get some undefined reference errors for
compress and uncompress. The output of make is given below. I don't know
why i am getting
in Mysql documents
section 4.16.5 Options files
it is documented as :
MySQL reads default options from the following files on Windows:
Filename Purpose
windows-system-directory\my.ini Global options
C:\my.cnf Global opti
Hi,
I have the following tables:
Country:
id | int(5) | | PRI | NULL| auto_increment |
country | varchar(35) | | MUL | ||
contid | int(5)
City:
id| int(5) | | PRI | NULL| auto_increment |
city | varchar(35) | | MU
At 17:47 16/04/2001 -0700, Sam Daniel wrote:
>I am interested in retrieving Field and Type information from a named
>table. Currently, MySQL allows me to see a table's description via
>
>mysql> describe TheTable;
>
>returning its structure in the form of a table, including the Fields and
>Types
Hi
Do you have a shell account on your server?
It can be done but you would would need either ssh or telnet access.
At 20:13 16/04/2001 -0400, SteveW wrote:
>Want to create databases programmatically, then upload to my host.
>
>Am using MS Access for my business database. Want to create a subset
I have written an application that establishes a connection to a remote
MySQL database, and accepts queries from clients. If the server does not
receive a query in eight hours (as set by wait_timeout), then the
connection to MySQL disappears and all my queries fail.
How can I keep the connection
Hi,
Now I'm completely stuck.
I am codeing a (basic at this point) stock inventory in PHP/MySQL.
I have all items in a table displayed in a table in PHP. Like this:
if ($isstock >0) { //get value from a check on mysql_num_rows
if ($action != "Edit") {
for ($i = 0; $i <= $isstock -1; $i++)
To all MySQL users in Asia - most particularly in Japan,
I would like to know if any MySQL training exists in Tokyo/Japan.
Reply to: <[EMAIL PROTECTED]>
Regards,
Marc
_
Get Your Private, Free E-mail from MSN Hotmail at http
Hello Mysql,
I am in need of a small database program that I need someone to build for
me. The project is simple, goto http://www.parentprofiles.com,
http://www.adoption.com, and http://www.birthmother.com. These 3 sites are
all pulling a random family that is looking to adopt a child. We would l
Hi,
How will we format numeric fields in MySql using PERL ? I want to display
certain numeric formatted in the browser. I want to set the decimal points, currency
etc.
Thankyou
Rajeev Ramanujan
Hi!
On Apr 16, Christian Hammers wrote:
> Hello
>
> I compiled on an UltraSparc II Linux with libc-2.2.2 and say
> CREATE TABLE t (t int) TYPE=BDB;
> but it creates a MyISAM without any warning. Why?
> BDB seems to be compiled in correctly:
>
> ch@vore:~/test$ nm usr/bin/mysqld |grep be
Hello,
I used to use a version of your client. The program I have is "mysqlgui-win-1.4a". I
am using Windows 98. Could you tell me what the latest version of your software is
and what the exact name is? There are so many programs and variations that I seem to
be getting confused. I don't
Hi, I have a table with multiple instances of username (Basically a table of
dial-in user's input/output octets).
What I want to do (In Perl), was to select each username (And associated
in/out octets), add them together, and finally print out a total for each
user.
eg.
UsernameInOctets
Are you really sure that you want to create multiple databases? and not
just many tables in one database? A minor point, but it might make some
things simpler.
It sounds like you have two goals. 1) you want to make dynamic web pages
that query a mysql database. 2) you want to manage the data
You can do this by just issuing that statement as a regular SQL query. I
was able to connect via an ADO connection:
set myRecordset = conn.execute("describe thedatabase.thetable")
and I'm sure you could do this with php via mysql_query("describe
thetable")
In both cases you end up with
I'd like to get a minor source change into the next revision of MySQL to
make the standard source distribution compile on Mac OS X. I read somewhere
to use some diffing tool when providing the bug report, but can't find those
instructions.
What's the proper way to get the revision into the tree?
I am interested in retrieving Field and Type information from a named
table. Currently, MySQL allows me to see a table's description via
mysql> describe TheTable;
returning its structure in the form of a table, including the Fields and
Types columns. I would like to retrieve the contents of
Want to create databases programmatically, then upload to my host.
Am using MS Access for my business database. Want to create a subset of the
data in a mySQL database, and upload these to my website. Must be done on a
routine basis and wanted to write the code in MS Access. Have been told by
prelude:
- utf-8 is a 'string function friendly' version of UTF-32, a character
mapping for all known human languages (with room for more). UTF is 4
bytes (4 * 8 = 32). Any of those 4 bytes can be 0, i.e. ''/NULL. A
regular library string function will end the string at the first BYTE it
>Description:
When running make after ./configure, make stopped at an error
stating debug.c: In function 'init_dbug_state': debug.c: 344:
'MY_MUTEX_INIT_FAST' undeclared. I found out later that this same
variable is undeclared in other files as well. Could you tell me what
type 'MY_
>Description:
When I was installing mysql from sources, I got a strange error. I looked at what was
going on, and this is what I got. first of all, here's the error in from my "make"
/bin/sh ../libtool --mode=link gcc -O6 -DDBUG_OFF -rdynamic -o conf_to_src
conf_to_src.o -ldl -lcry
bobit wrote:
>
> Hi - here's my prob and background info. Tried the fix - it didn't work.
>
> MySQL Connection Failed: Can't connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock' (111)
>
> Any thoughts...?
>
Is MySQL actually running on your system? Even if you installed
NOTICE: THIS IS A ONE (1)-TIME MESSAGE AND IT WILL NOT REPEAT. THEREFORE THERE IS NO
NEED FOR DELETION OR REMOVAL. *Your email address has already been discarded from our
files.
-
I might have missed it but is there a way to get the strings related to a
enum from the database? (i.e. I have index 4 but I want the string that it
goes with)
thanks
-Ian Johnson
-
Before posting, please check:
http://www.m
I just compiled MySQL 3.22.27 (yes, I know it's an old package)
under RedHat 7.0. It compiles and installs fine and mysqld seems
to run ok, but isamchk refuses to check tables:
isamchk: error: 22 when opening ISAM-table 'note.ISM'
The file exists and is readable by root:
-rw-rw1 root
Hello
I compiled on an UltraSparc II Linux with libc-2.2.2 and say
CREATE TABLE t (t int) TYPE=BDB;
but it creates a MyISAM without any warning. Why?
BDB seems to be compiled in correctly:
ch@vore:~/test$ nm usr/bin/mysqld |grep berke
000822c0 t _GLOBAL_.D.have_berkeley_db
Hi, I am installing the binary version of mysql 3.23.36 on AIX 4.3. When
I run mysql_install_db, i get the following error
/usr/local/lib/libz.a(shr.o) could not be loaded.
Member shr.o is not found in archive
This error is occuring with the latest version of the zlib library. Can
someone shed s
Hi there,
> We have a very popular greetings card site at http://gcards.com We
> recently switched to MYSQL as our backend database..
>
> But recently we noticed that MYSQL cannot handle high load under
> normal installation. In our system we get more than 10,000
> insert/update/delete/select que
On Monday 16 April 2001 10:23, phelles wrote:
> Hi everybody!!
> I'm using mysql on linux Redhat7...
> When i exec safe_mysqld the server begin and... shut down, so i can't use
> it...
> i used an RPM version.
> If somebody could help me it could be great: one more try and i kill
> myself!!
> (ex
Hi,
I have a question if mySQL can be ported to an embedded environment like
VxWorks?
Thanks,
Andrew
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
While trying to install the binary distribution of mysql-3.23.36 on a Sun
Sparc30 running Solaris 2.6 I get a fatal pthread_rwlock_init symbol error.
Am I perhaps missing some critical library in /usr/lib that mysql needs to
perform its installation?
Details follow; thanks in advance for any he
I have just compiled fl_editor-0.4.1. Here is the list of .o files that get created:
./src/Fl_Editor.o
./src/Fl_FancyEditor.o
./src/Fl_FancyMultiEditor.o
./src/Fl_MultiEditor.o
./src/Fl_ProgressBox.o
./src/Fl_StatusPanel.o
./src/editengine.o
./src/lists.o
./src/wstring.o
./test/progress.o
./tes
See also:
http://www.kofler.cc/mysql/mssql2mysql.html
mssql2mysql converts Microsoft SQL Server databases to MySQL (schema + data,
but no SPs, no triggers, no views etc.)
mssql2mysql is VB/VBA code (you need VB6 or a VBA6 capable program such as
Excel 2000 or Word 2000 to run it)
mssql2mysql i
<[EMAIL PROTECTED]>
I am very new to mysql, so perhaps this is incorrect, but, I think
there is something in the manual that I saw on this that suggests that
you should check for file permissions. Look in .err and
.log (?) files created in some directory near your install
location (/usr/
Okay just checking a few basic things, have you indexed your table properly?
There is a manual section about performance, also make sure to play around
with the mysql configuration file (global one in /etc/my.cnf)
>From: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: MYSQL Problem
>Date: Mo
If you are truly getting 10k queries per second, that would imply to me a roughly
comparable number of webserver connections (maybe within a factor of 2). If this is
the case, I'd be amazed that it would work at all when hosted on a single box with
"only" 256M of ram. I believe your problem
Hi everybody!!
I'm using mysql on linux Redhat7...
When i exec safe_mysqld the server begin and... shut down, so i can't use
it...
i used an RPM version.
If somebody could help me it could be great: one more try and i kill
myself!!
(excuse me for english: i'm french...)
Anyway, thank you for your
> "DG" == Dennis Gearon <[EMAIL PROTECTED]> writes:
DG> Is it true no indexing on Nulls In the Innobase database tables and
DG> MyIASM
DG> tables?
Dunnow about Innobase tables, but MyISAM tables let you have indexes
on nullable columns. ISAM did not.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Hi Everybody,
We have a very popular greetings card site at http://gcards.com
We recently switched to MYSQL as our backend database..
But recently we noticed that MYSQL cannot handle high load under
normal installation. In our system we get more than 10,000
insert/update/delete/select queries
Is it true no indexing on Nulls In the Innobase database tables and
MyIASM
tables?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
Also, it's not a specific query that crashes it, only select queries
apparently.
>I can do better than that I can give you root access to my machine. You can
>corrupt the data as much as you want I have backups on my other machine.
>Contact me at my email for the login details.
>
>>From: Sasha P
as I said before I can give you root access on the machine which I believe
would be easier for you to disagnose the problem.
>From: Sasha Pachev <[EMAIL PROTECTED]>
>To: "Andrei Cojocaru" <[EMAIL PROTECTED]>
>Subject: Re: Problem - Possible Bug?
>Date: Mon, 16 Apr 2001 08:31:54 -0600
>MIME-Versi
On Sunday 15 April 2001 19:40, Andrei Cojocaru wrote:
> Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am
> running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the
> same problem, I upgraded to 3.23.36 today and it had the same problem. I
> have recompiled
1. No, unless you use ISAM tabbes ( See the Manual )
2. Index Sequential Access Method.
Jamie S Buchanan wrote:
>
> Hello, I wonder if you can help me.
>
> For a university project I've got a database with several tables using columns
> set up with 'auto_increment'. I've discovered that the va
You need to load the "ncurses" headers and libraries.
I am not familiar with Debian, but they are on your CD.
André Estel wrote:
>
> Hello,
>
> i mail you from germany, so please excuse my "special" english! I just want
> to compile mysql 3.23.36 under Debian Potato for use with PHP(classic LAM
I suggest you get 3.23.36 it's the latest.
>From: "Thomas Morton" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: Please assist me?
>Date: Mon, 16 Apr 2001 14:35:50 +0100
>MIME-Version: 1.0
>Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id
>MHotMailBCA4429B00C94004370AC0
Use only GCC-2.95.2
Gordon Stewart wrote:
>
> I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI
> module But I get errors when I do a make
>
> I have enclosed a screen dump of the output I get. I seams to be getting
> stuck with dbimon. I have installed DBI-1-14.tar.g
And what does this have to do with MySQL?
Dennis Gearon wrote:
>
> How do you guys uniquely identify companies within your mysql databases,
> both foreign and domestic?
>
> Tax ID numbers?
> Name and State and City(US)
> Other?
>
> In the database I am designing
>
> the are identified by ema
The server needs read and execute permissions all the way to the data
file, and read
permissions on the file.
I you are on the server, try LOAD DATA LOCAL instead.
Kalvin Kag Khetsavanh wrote:
>
> I keep getting the following error everytime i tried to use Load Data
>
> mysql> load data infile
Sir,
Sorry to bother you. I have downloaded MySQL version 3.23.22-beta. I am looking for
a pretty basic tutorial to get started. Are there any suitable training materials on
your website? In particular, how can I best use the GUIs in WinMySQLAdmin?
Your kind response would be appreciated.
"Thomas O'Neill" <[EMAIL PROTECTED]> wrote:
> 1. How would I select the row that has the highest value in one of the
fields?
Use the ORDER BY clause. ORDER BY field_name DESC
> 2. How to I update a record?
Use an UPDATE query. Query structure and MySQL commands are covered in the
online manua
Try looking at the bottom of any message.
By the way, the output of your query is an empty set.
Yen wrote:
>
> Thank you Jeremy, these really help!! I can't find the manual :D
>
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 13, 2001 4:00 P
Sinisa,
I appreciate your taking the time to help. I do seem to have run into
unexpected problems.
Thanks.
David
At 08:47 AM 4/16/01, you wrote:
>David Relson writes:
> > Good morning,
> >
> > >What does `find . -name '*.o' -print' return ??
> >
> > It prints nothing.
> >
>
>It means that
On Mon, Apr 16, 2001 at 07:54:56AM -0500, Jeff Holzfaster wrote:
>
> Hi!
>
> This query works: select date_format(date, "%W, %e %M %Y") as date from
> table
> This query doesn't: select concat(date_format(date, "%W, %e %M %Y"),"
> ",another) as time_of_day
>
> I'm wondering if it is possible to
Jeff Holzfaster writes:
>
> Hi!
>
> This query works: select date_format(date, "%W, %e %M %Y") as date from
> table
> This query doesn't: select concat(date_format(date, "%W, %e %M %Y"),"
> ",another) as time_of_day
>
> I'm wondering if it is possible to use concat in this way and how if it is
>From: Sinisa Milivojevic <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>CC: [EMAIL PROTECTED]
>Subject: Re: How to apply a patch?
>Date: Mon, 16 Apr 2001 15:48:48 +0300 (EEST)
>MIME-Version: 1.0
>Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id
>MHotMailBCA4360F00AB40043751C03AC5A
Hi!
This query works: select date_format(date, "%W, %e %M %Y") as date from
table
This query doesn't: select concat(date_format(date, "%W, %e %M %Y"),"
",another) as time_of_day
I'm wondering if it is possible to use concat in this way and how if it is
possible.
Thanks!
Jeff
Andrei Cojocaru writes:
> Hello sorry for my ignorance but how do I apply a patch [diff file] to the
> mysql source? Thanks for your help.
>
> -Andrei Cojocaru
Hi!
Enter mysql source and run patch < filename.
If that does not work, try patch -p 0 < filename.
Regards,
Sinisa
David Relson writes:
> Good morning,
>
> >What does `find . -name '*.o' -print' return ??
>
> It prints nothing.
>
It means that you have not built fl_editor. Build it !
>
> I consider pre-built binaries to be security risks, especially ones that
> ask for passwords!
>
Why ?? mysqlgui i
Good morning,
At 07:07 AM 4/16/01, Sinisa Milivojevic wrote:
>David Relson writes:
> > At 11:42 AM 4/15/01, Sinisa Milivojevic wrote:
> >
> > Sinisa,
> >
> > I have fl_editor-0.4.1, which I downloaded, configured, and built
> > today. There is no edfile.o. I have run command 'find . -name
> "e
Hello sorry for my ignorance but how do I apply a patch [diff file] to the
mysql source? Thanks for your help.
-Andrei Cojocaru
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Hi - here's my prob and background info. Tried the fix - it didn't work.
MySQL Connection Failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
Any thoughts...?
I'm not sure if it's the same problem but here goes:
I just did a fresh install of RH 7.0
Luis E. Cruz Campos writes:
> I am trying to prove a small program of test, but when trying to execute it
> this always it throws "Aborted (core dumped)", this happens at the time of
> making the connection:
>
> It is the program:
>
> #include
> #include
> #include "sqlplus.hh"
>
> cchar *u
Hi!
MySQL++ can not be used with g++ 2.96 as it is very unstable when it
comes to high C++.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
List Box writes:
>
> MySQL is not giving expected results in queries:
>
> The table has a decimal field, 'tolong', with a 13 char size and 8
> decimal places.
>
> I know from browsing that the table contains many records with
> 'tolong' values less than -120, as low as -124.
>
> The query
>
Andrei Cojocaru writes:
> Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am
> running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the
> same problem, I upgraded to 3.23.36 today and it had the same problem. I
> have recompiled mysql in full debug and done a
"Aborted" in a C++ program usually means an exception was thrown that
you didnt catch. In this case, the connection constructor could have
thrown something.
try
{
Connection MySQL(db, host, user, pass);
}
catch(...)
{
cout << "Connection failed." << endl;
}
Check the e
[EMAIL PROTECTED] writes:
> Hello,
>
> When using Visual C++ or Delorie DJGPP (under windows 2000) compilers and compiling
>the following example:
>
> #include
> #include
> #include
> #include
> #include
>
> int main()
> {
> Connection con("stw");
> return 0;
> }
>
>
>
> I
David Relson writes:
> At 11:42 AM 4/15/01, Sinisa Milivojevic wrote:
>
> Sinisa,
>
> I have fl_editor-0.4.1, which I downloaded, configured, and built
> today. There is no edfile.o. I have run command 'find . -name "edfile.*"'
> to locate it and found nothing.
>
> David
> -
[EMAIL PROTECTED] writes:
> I tried mysqlgui:
> mysqlgui-linux-static-1.7.5]$ ./mysqlgui
>
> but it didn't works well:
> It can't connect to mysql.
> Why?
> How can I do to connect for example to a database called "visia" with pw
> "pw_visia" from an user called "rino" in "localhost
> select ID from table where sentence = '".does't take."'
I think that should do the trick. Or if not...hopefully you're using
mysql in combination with some other programming languages like asp or php
or...in php you just use addslashes() function bvefore sending a query to
mysql.
Cheers
Sii
escape the apostrof with a backslash:
select ID from table where sentence = 'does\'t take'
you should do this for some other characters as well, like the backslash
itself.
if you'd use php you could use the function 'addslashes()';
basically what you should do to make a string binary-safe is re
Hi, I'm new in mysql,
I have a problem in the apostroph,
I would write a query like :
select ID from table where sentence = 'does't take'
Can you help me?
___
Do You Yahoo!? -- Pour dialoguer en direct avec vos amis,
Yahoo! Messenger :
Hi I am pretty new to MySQL and database work in general. I was hoping that someone
good answer two easy questions.
1. How would I select the row that has the highest value in one of the fields?
2. How to I update a record?
I am sorry I have to ask questions like this.
If any one is curious
Are you running at as root?
David Loszewski wrote:
> it tells me that I'm missing a command if I take away the -p
>
> Dave
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Guray Sunamak
> Sent: Saturday, April 14, 2001 3:27 AM
> To: David Loszewsk
76 matches
Mail list logo