I have some questions on using ODBC with My SQL.
I have a MySQL on on an ISPs database server. I'd like to
pull data from it into Excel. It appears that I need to
use ODBC to do this. Do the server need to have ODBC
installed or do I just need it installed on the PC I want
to connect from?
I
Hi;
I want (and need) to get working mysql++.
1. First, I dowloaded the msyql++ rpm (1.7.9) and with no problems, but
when I try to compile something (a text) I get a lot of corrupt lines
from the headers (/usr/include/mysql++/). Example of how I try to
compile:
g++ -I/usr/include/mysql++ main.cc
Hi;
I want (and need) to get working mysql++.
1. First, I dowloaded the msyql++ rpm (1.7.9) and with no problems, but
when I try to compile something (a text) I get a lot of corrupt lines
from the headers (/usr/include/mysql++/). Example of how I try to
compile:
g++ -I/usr/include/mysql++ main.cc
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=74943
I think the last tip is the most recommended:
Here's another my.cnf fix that seems to work (under [mysqld]):
set-variable=max_allowed_packet=16M
set-variable=thread_stack=1M
Prasad
--
Jochen Kaechelin
-
I've been trying to upgrade to 4.0.3 mysql from
3.23.38. I've used the binary for 4.0.3 on a linux box
(SuSE 8.0) with dual 1.4GHZ pIII's and 2GB RAM. We run
a pretty busy e-commerce site, and the 3.23.38 box is
a Solaris7.
Each time I move the linux box into production, I'm
over-rum with an inord
>Description:
MySQL gives strange problems when installed on NetBSD Operating System. For
example, it is imposible to import the mysql database of geeklog package
(http://geeklog.sourceforge.net). I run netbsd-x86. The problem is this:
ERROR 1050 at line 11: Table gl_access already exist
Yes, you will have to grab the userid and insert it into student table,
Mysql has no concept of dependent keys (in 3.23.xx).
You can write a perl or php application to do that.
Regards,
Bhavin.
- Original Message -
From: "João Borsoi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Satur
Are you using PHP? There is a useful function in there that would give
you the last auto-number, like this:
(do your first insert)
$insert_key = mysql_insert_id();
(do your second insert, using $insert_key as the new foreign key that
you are putting in your SQL)
Now each table has its own auto-
Hello list,
I have two tables, USER and STUDENT, where all students are users. The
user table has an auto-increment key field. I want to make an operation
to insert users, which should insert rows in both tables (see the tables
bellow).
How can I control the auto_increment field in both tables? D
Hello list,
I have two tables, USER and STUDENT, where all students are users. The
user table has an auto-increment key field. I want to make an operation
to insert users, which should insert rows in both tables (see the tables
bellow).
How can I control the auto_increment field in both tables?
typically, a select statement on the SQL command line will retrieve all the
records.
-Original Message-
From: [EMAIL PROTECTED] [mailto:Sam4Software@;aol.com]
Sent: Saturday, November 02, 2002 12:00 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: INSERT within a loop
Hi,
I wonder i
Hi,
I wonder if there is a for loop statement in SQL, basically I want some data
in all the records in the table in one loop through the records within SQL
editor.
Thanks,
Sam
-
Before posting, please check:
http://www.mys
Lo everyone,
mysql> DESCRIBE UserAttributes;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| ID| int(11) unsigned |
Hi,
Isn't it time to add a manual section like this one
http://www.mysql.com/doc/en/Communication_errors.html on the Lost
Connection to MySQL Server during query? These emails come in at a regualr
rate, they seem to vary in cause somewhat, and I still have not solved my
own problem with this erro
VARCHAR is limited to 256 characters. TEXT is much longer, like 6000 or
6 characters or so, don't actually know. I believe both TEXT and
varchar both support full text searches. You can store HTML in the
database, just be sure to addslashes and stripslashes going in and out.
Your server may be
AuctionWare Admin wrote:
Hello all,
I have came across a pretty peculiar problem and am hoping someone can
help me out.
Each time I try to connect to a MySQL server on my network, I receive
the following error:
Lost Connection to MySQL Server during query
It isn't just one server that is givi
Hello all,
I have came across a pretty peculiar problem and am hoping someone can help
me out.
Each time I try to connect to a MySQL server on my network, I receive the
following error:
Lost Connection to MySQL Server during query
It isn't just one server that is giving me this problem, it is
Thanks.
If I have an old copy of Mysql on the system and want to uninstall that, how
would I make sure that all the database associated should get deleted, or do
I do it manually?
Thanks
Aman
- Original Message -
From: "Frederic Trudeau" <[EMAIL PROTECTED]>
To: "aman mysql" <[EMAIL PROTEC
Hi All:
I am kind of new to MySQL. I have ordered MySQL Cookbook but I still
have a week before it arrives. In the meantime, I am looking for some
basic help.
I am looking to store the text/description for the purpose of retrieving
it on the website. What would be the most appropriate way to stor
Tomek,
- Original Message -
From: "Tomek Dudziak" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, November 02, 2002 1:34 PM
Subject: Re: 4.0.4 stalls
> [EMAIL PROTECTED] (Tomek Dudziak) wrote in message
news:<[EMAIL PROTECTED]>...
>
> > about 300 queries per second
Hi,
I am having a problem with the imporot wizard in MySQL, as I don't know
wha'ts wrong Im doine, I tried to import from a text file, csv, .mdb, all
dont get me any data in the destination table, can some one advise ? (may be
if some one is willing to talk me through MSN messagner/yahoo messan
mysqladmin comes with mysql-server-X.XX.XX-X.rpm, me think you installed
mysql-X.XX.XX-X.rpm only
Try this command to make sure : rpm -qa | grep mysql
Then, get the mysql-server RPM here :
http://www.rpmfind.net/linux/rpm2html/search.php?query=mysql-server&submit=S
earch+...&system=redhat&arch=
Frank LaLone wrote:
Actually, I did see the Read Me file that came with the driver. I spent so
much time on this myself, I wanted to start fresh on here. :)
I am still unable to get mysql to connect to the jdbc driver. Here is the
latest what I did and the resulting errors that came up:
##
Hello,
What are your experiences with Mysql 4 and Fulltext?
is it stable or should I still wait for final release?
I realy need new functions of mysql 4, but i'm not sure if use it.
thanx
-
Before posting, please check:
ht
At 13:29 +0100 11/2/02, ddd wrote:
i know !
That wasn't apparent from your message.
but how to solve it ??!
can anybody help how to search word with "-"
Use a phrase search in boolean mode, which requires the original
phrase exactly as present in the table.
thanx
Paul DuBois wrote:
At
Hi
I downloaded the mysql in RPM format and installed on my RH Linux 7.3 box.
There is no mysqladmin, though there was no error. Do i need something else
or should i be downloading te tar-ball and installing that?
Aman
-
Before po
when I try to connect to a remote computer running mysql
I always get the following error on the remote machine:
Number of processes running now: 1
mysqld process hanging, pid 7262 - killed
021029 21:28:13 mysqld restarted
/usr/local/libexec/my
> There is no row number in MySQL. You should use ORDER BY to
> retrieve data in particular order.
What about the following info in the manual p. 55?
Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version
3.23.11: If the PRIMARY or UNIQUE key consists of only one column and thi
i know !
but how to solve it ??!
can anybody help how to search word with "-"
thanx
Paul DuBois wrote:
At 21:45 +0100 11/1/02, ddd wrote:
hello
i'm using mysql 3.23.41
i want to search in fulltext indexed table for word "Down-Syndrom"
but the
result is the same like when I search "138721-
John,
Thursday, October 31, 2002, 11:49:08 PM, you wrote:
JM> How do I create users for a specific database using SQL?
Take a look at GRANT statement:
http://www.mysql.com/doc/en/GRANT.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsore
Daya,
Friday, November 01, 2002, 12:41:57 PM, you wrote:
DKD> Can naybody tell me how can i get the last 10 inserted record in the table
DKD> in MySql. Is MySql uses rowid like Oracle.
You can use f.e. AUTO_INCREMENT column and then
SELECT ORDER BY auto_increment_field DESC LIMIT 10;
--
Alexander,
Friday, November 01, 2002, 2:02:18 PM, you wrote:
AB> Every time I want to replicate, do I have to restart?
No. Use SLAVE START and SLAVE STOP commands.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensi
I need a 20 GB + DB that I'd like to access by row number or physical order.
handf> Of course I could use a special rownum column but that would be a waste of
handf> space plus require an additional key whereas mySQL already maintains such
handf> table internaly.
There is no row number in MySQL.
Jorge,
Friday, November 01, 2002, 2:25:19 PM, you wrote:
JM> I need a query:
JM> Select * from table where field = ' var ';
JM> and var is a string variable 'otoño'
JM> mysql not find 'otoño' , find 'otono' ?
In which encoding do you insert data? What is character set you use
in MySQL (c
Alexander,
Friday, November 01, 2002, 9:48:50 PM, you wrote:
AB> I did the configuration below but the server doesn´t make the replication.
AB> I tryed some commands.
AB> start/stop slave
AB> status master
AB> but they didn´t.
AB> What else do I have to do?
Is there anything in the error log?
Hi,
I am trying to import 2 columns from Access to MySQL, I get the right number,
but all fields are imported as null.
Any suggestion ?
Sam
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
Actually, I did see the Read Me file that came with the driver. I spent so
much time on this myself, I wanted to start fresh on here. :)
I am still unable to get mysql to connect to the jdbc driver. Here is the
latest what I did and the resulting errors that came up:
###
37 matches
Mail list logo
