>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Is this where I would get some help using the mysql++ api for linux c++?
dave
--
--Powered By Linux--
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Thanks... mysql_error() said "No database selected". Oops... forgot to
define $db_name as a global.
- Original Message -
From: "Girish Nath" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Brian Rue" <[EMAIL PROTECTED]>
Sent: Sunday, December 16, 2001 8:17 PM
Subject: Re: [PHP] mysql_query()
How about this:
update table
set answer = concat_ws("," ,
if(left(columnA,1)="*",substring(columnA,2),""),
if(left(columnB,1)="*",substring(columnB,2),""),
if(left(columnC,1)="*",substring(columnC,2),"") )
Greg
> I've got a 700-question multiple choice quiz th
On Sun, Dec 16, 2001 at 09:33:06PM +0200, Heikki Tuuri wrote:
> I will change InnoDB so that it allows several NULL values in secondary
> indexes even if that index would have been declared UNIQUE. Oracle has a
> similar convention.
>
> In the case of foreign keys, I advise against using NULL val
(answer to myself & anyone interested ;0)
After setting my date to "Unix_Timestamp"
mode, I convert it to a 10-base number:
-
>> CONV(UNIX_TIMESTAMP(U.lastTime),10,10)
-
Then, I perform the substraction:
-
Hi
Try the following to find out what's happening :
$result = mysql_query($query,$conn) or die (mysql_error());
Or try echo'ing $result to see what it contains. It should contain something
like this if everything is working fine :
Resource id #2
Regards
Girish
- Original Message -
At 08:58 PM 12/16/01 -0700, Doug Thompson wrote:
>This should help:
>
>A.4.2 How to Reset a Forgotten Password
>http://www.mysql.com/doc/R/e/Resetting_permissions.html
Works ok up through step 2.
mysql -h localhost mysql gives me error 1045 again.
Can't get in with mysqladmin either.
--
Dave'
This should help:
A.4.2 How to Reset a Forgotten Password
http://www.mysql.com/doc/R/e/Resetting_permissions.html
Good luck.
Doug
On Sun, 16 Dec 2001 22:43:39 -0500, David VanHorn wrote:
>
>I'm root on a small server.
>My co-sysop has managed to lock us out of mysql.
>I can't get in with -u
I'm root on a small server.
My co-sysop has managed to lock us out of mysql.
I can't get in with -u root and the root password, or anything else I can
think of.
Error 1045: Access denied for user" 'root@localhost'
So how do I slip a key under the door, without nuking the databases?
--
Dave's E
I've got a 700-question multiple choice quiz that I've got imported into
MySQL, with one small problem: the answers to the quiz are not a separate
column. I have three columns for each of the possible answers; the correct
answer is denoted by a "*" in the appropriate field. For example, if I ha
Hello all.
I'm trying to compile MySQL-4.0.0 on Slackware 8.
Here's what I've done...
export CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors
-fno-exceptions -fno-rtti"
./configure --enable-thread-safe-client --with-openssl --enable-assembler
make
Then after a little compiling, I get:
g
I have made binary distributions of;
- unixODBC
- PostgreSQL Driver
- MySQL Driver
availible to the public at http://www.codebydesign.com/DataArchitect.
These binary distributions are based upon Open Source code which was
configured and built on the Mac OSX.
All distributions use the standar
I have two tables that are exactly alike. What I want to do is fetch the
rows from each into one sortable result set. Example:
Table1
--
| Column1 | Column2 | Column 3 |
--
| 1| 2| 3|
--
Hi
I am trying to install mysql++-1.7.9 on linux. I followed the README by
typing automake in the mysql++-1.7.9 directory but get the following
messages:
automake: Makefile.am: required file `./INSTALL' not found
automake: Makefile.am: required file `./NEWS' not found
automake: Makefile.am: req
I try to use the ?var?'s to create a menu for inserting new rows in a table.
for example:
insert into personnel(first_name, last_name) values(?first_name?,
?last_name?)
if i type jean in first_name and maupertuis in last_name the result is
"unknow column
'jean' in 'field list' "because it's tr
* florian
> but except for that text can store more than 255 chars is there
> any difference between varchar and text/blob?
>From the manual:
"In most respects, you can regard a `TEXT' column as a `VARCHAR' column
that can be as big as you like. Similarly, you can regard a `BLOB'
column as a `
> Some how I don't have control over mysqld as root. It starts on
> boot, but I
> am unable to stop it to reset root password. How can I correct this?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.
Hi!
> "Michael" == Michael Stassen <[EMAIL PROTECTED]> writes:
Michael> Of course, you are right. As I said, I took this code from
Michael> set_maximum_open_files in mysqld.cc: simply turning the 1st
Michael> sql_print_error line into the printf lines. I should have looked more
Michael>
Hi!
I will change InnoDB so that it allows several NULL values in secondary
indexes even if that index would have been declared UNIQUE. Oracle has a
similar convention.
In the case of foreign keys, I advise against using NULL values, because in
SQL NULL really means 'an unknown value'.
Actually
Some how I don't have control over mysqld as root. It starts on boot, but I
am unable to stop it to reset root password. How can I correct this?
Raymond
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hi!
>I received a table handler error 139 on several occasions while trying
>to convert a table to type InnoDB (alter table data type=InnoDB). I
>ran a check table and optimize table on it, and converted it from
>MyISAM to BDB successfully. Today, when I tried it again to get the
>exact err
> Hi,
> I am having problems loading data into a table and have 2 questions.
>
> 1)
> I want to load some data from a text file in to a table by using the
> following line:
> LOAD DATA LOCAL INTO "st.txt" INTO TABLE studio;
>
> this keeps giving me : File "st.txt" not found (ErrorCode: 2)
>
>
On Monday 17 December 2001 02:02, Didier Brisebourg wrote:
> Hi,
>
> Can anybody help me ?
>
> In MySQL documentation, it is said that table name can use any character
> allowed in filename except '/' and '.'.
>
> On my Linux, i can create a file with this name "'w4-1".
>
> But, i can't create the
hi!
i have a question concerning string column types of a mysql database:
char is better for small sized strings (because of the fixed row size, and for
long strings it would blow the db up too much)
but how about varchar vs text or blob.. which one is suited for which need
the best? blob is ca
I received a table handler error 139 on several occasions while trying
to convert a table to type InnoDB (alter table data type=InnoDB). I
ran a check table and optimize table on it, and converted it from
MyISAM to BDB successfully. Today, when I tried it again to get the
exact error message
Hi,
Can anybody help me ?
In MySQL documentation, it is said that table name can use any character
allowed in filename except '/' and '.'.
On my Linux, i can create a file with this name "'w4-1".
But, i can't create the table with this name. The request is rejected.
Has anybody an explanation
Is there an upper bound on how many items may be listed in an 'IN' clause?
SELECT a,b,c from d where a in (1,2,3,4,5,6 ... 1123,1124); ...??
Thanks
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock/
-
* Sebastian Bergmann
> Roger Baklund wrote:
> > You can almost always improve the performance of queries by adding an
> > index. The trick is to add the right index... :) If you for instance
> > often did a "SELECT * FROM pot_accesslog WHERE client_id=$id AND
> > timestamp > NOW() - INTERVAL 24 HO
Roger Baklund wrote:
> However, if the behaviour with no restrictions on duplicates is
> correct, you may be better of without a primary key in this case.
Okay, that's what I need here.
> Also, the second create statement defines indexes on all fields, making
> almost any query reasonably fas
Hello,
On our server we currently have, what I think, is a problem. We run mysql
for some time now, but every time a query is loaded the mysqld uses more
then 50 % of the CPU. In some cases it even uses 99,9 % of the cpu for a
second or 2.
I find this very strange myself. The table that's used
Hello all !
I've got 2 questions :
Can we insert ASCII characters in an INSERT statement... like
INSERT INTO guy(name) VALUES('ascii codes here'); so that the
ascii code of a ';' will display a ';' in the database... understand !?
And is there a place on the net that we can browse all errors no
* Sebastian Bergmann
> I am currently trying to optimize the indexes / keys for the MySQL
> schema of phpOpenTracker.
I don't know phpOpenTracker, but I have a few comments.
> I'm wondering if multiple keys, like
>
> CREATE TABLE pot_accesslog (
> accesslog_id int(10) unsigned NO
LOAD DATA LOCAL INFILE "location of text file" INTO TABLE [tablename]
- Original Message -
From: "Inderpal Singh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 16, 2001 8:12 AM
Subject: Location of text file for loading data in to table
> Hi,
> When using the command
Inderpal Singh writes:
> When using the command:
> LOAD DATA LOCAL INFILE "xxx.txt" INTO TABLE [TABLE NAME];
>
> where should the txt file be located?
That's up to you to decide, but as _always_ when you do something
to a file, you must give some sort of valid path (absolute
or relative or wha
Hi,
I have run the small test below:
mysql> create table test (
-> f1 int,
-> ts timestamp);
Query OK, 0 rows affected (0.40 sec)
mysql> insert into test values (10);
ERROR 1136: Column count doesn't match value count at row 1
mysql> insert into test (f1) values (10);
Query OK, 1 row af
On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote:
: On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote:
: >
: > So, could you give me some advice that if it is feasible ? Or show
: > me your successful cases of using mySQL which is supporting very
: > large DB or tables with d
My timestamp is doing the same thing... with inserting 0's ... but if I
leave it out of the insert query, it wont update, because the field is
missing... I have the insert and also a mail() function that lets me
know every time an entry has been made, and when I first tried the
timestamp, it just
Actually, we've been runnning mySQL replication for ~4 months now
We've never had a problem with the slaved machines losing their position
in the log, nor do we ever run a reset slave...
Try the following script instead out of cron...
#!/bin/sh
FIRST_LOG=`echo 'SHOW MASTER LOGS ;' | mysql|head -
Hi!
On Dec 16, Magnus Enbom wrote:
> Hi,
>
> I'm trying out the new query cache features in mysql4.
> Are the cache supposed to work with innodb tables? It's not according to the
> output of show status, works fine with myisam tables.
> I'm ran a 'bk pull -l' this morning and compiled with Suns
Hi,
I'm trying out the new query cache features in mysql4.
Are the cache supposed to work with innodb tables? It's not according to the
output of show status, works fine with myisam tables.
I'm ran a 'bk pull -l' this morning and compiled with Suns cc on a Solaris-x86
box.
It looks like this:
Hi,
When using the command:
LOAD DATA LOCAL INFILE "xxx.txt" INTO TABLE [TABLE NAME];
where should the txt file be located?
Thanks
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
---
Hi,
When using the command:
LOAD DATA LOCAL INFILE "xxx.txt" INTO TABLE [TABLE NAME];
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
-
Hi!
I just happend to notice this old email...
> "Moshe" == Moshe Gurvich <[EMAIL PROTECTED]> writes:
Moshe> In MySQL 3.23, how to update one table using information from another table.
Moshe> update table1 set value1=t2.value2
Moshe> from table1 as t inner join table2 as t1 using(pk_key)
Hi!
> "Brian" == Brian P Austin <[EMAIL PROTECTED]> writes:
Brian> You need to download the MySQL-4.0 source and compile for
Brian> embedded-server. This is a library that you link your programs to.
Brian> It is used for small devices, like what we are doing here.
Brian> I haven't found a
sql mysql
test
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
> user drop primary key;". Work fine. But "alter table user add primary key
> (userName)" didn't work. It print "ERROR 1062: Duplicate entry 'a' for key
> 1". What's wrong? Help me.
This means that you have more than one record with the same value under the
userName column...
try this
SELECT us
> Hi all,
> Ive recently been made aware of a glitch in MySQL
> regarding locked at the table level (instead of row)
> when a record is being updated.
>
> Is this still a problem in Version 3.23.46?
>
> Has it been fixed in 4.0.0? And if so, when is a
> stable version of 4.0 likely to be released?
Hi all,
Ive recently been made aware of a glitch in MySQL
regarding locked at the table level (instead of row)
when a record is being updated.
Is this still a problem in Version 3.23.46?
Has it been fixed in 4.0.0? And if so, when is a
stable version of 4.0 likely to be released?
Many thanks,
On Fri, Dec 14, 2001 at 06:36:19PM -0500, Peter M. Perchansky wrote:
> Greetings everyone:
>
> RE: http://www.mysql.com/doc/R/e/Replication.html
>
> How frequently does each slave get data from the master?
The slaves have a thread running (the "slave thread") which is always
connected to the m
On Sat, Dec 15, 2001 at 12:55:28PM +1100, Tim Wood wrote:
> Hi Peter
>
> We use the mysql replication stuff here. Its very reliable, and the
> synchronization between master & slave is pretty much instant.
>
> There does seem to be one problem when the master rotates its
> transaction logs, the
On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote:
>
> So, could you give me some advice that if it is feasible ? Or show
> me your successful cases of using mySQL which is supporting very
> large DB or tables with details ?
How about a table with 260 million rows? We've got one that is
Im new to MySQL and it seems that a big part of this is knowing how to
write the right conditional clause to get the results you want. Anybody
know where some good articles are on learning how to write good WHERE
CLAUSES, I always know what I want to get but Im still not sure how to map
that in
Hi,
I've download the latest version of ODBC for window NT/XP to install
on my XP machne, during the installation. It response with:
Cannot find file D:|software\Mysql|ODBC\WinNT\SETUP.EXE [or one of its
components]. Check to ensure the path and filename are correct abd that
all required li
There seems to be a flaw in the myODBC driver
02.50 when working with the Unix-Timestamp()
function.
Apparently, the driver doesn't know which
data-type to use...
When I send the sql statement:
--
Select
( UNIX_TIMESTAMP(U.lastTime) -
UN
55 matches
Mail list logo
