 | | | MySQL General | | Bryan Coon wrote
> Posted this yesterday but it never showed up...?
>
> Hi
>
> I have the following table (sorry if the formatting gets tweaked) and
> query. The table is around 36k rows Hello
>From MySQL 4.1 MySQL supports storing of data in
utf-8 and ucs2. But all the C API till supports only
char*.
This has brought up some issues in my mind
1.) How do you I send UnicDan Vande More wrote
> /* repost considering I have no answers is it safe to conclude it 's not feasible?*/
>
>
> I 'd like to be able to audit connections to mysql databases. Here is
> what II am having some problems with constant table corruption on a database. I have
now had this occur on two different operating systems with two different
versions of MySQL. I edit these tables usingHello
I am having a weird problem with some sql that is supposed to set up a
DB for me. When I run the .sql file manually from the command line like
this
mysql --user root < DB_init.sql
"Lutz Maibach " <klinge@(protected) > wrote
> Hello Sasha
>
> thanks for your advise but I 'm not shure whether I understand how to
> find out if the master is offering (and using) the compressed Do you need something like ...
SELECT tour.id tour.showid tour.date tour.status
stat.id stat.statusmesg
FROM tour INNER JOIN stat USING (id)
WHERE tour.date >$daysInMonths
Hi!
You seems to have just installed mysql. The root user should be able to
acces a mysql server from anywhere by default. I don 't know why you can
connect from localhost probably you delete theHi Keith
you can use
pla.type IN ( '1 ' '2 ' '3 ' '4 ')
/Johan
Keith wrote
> is there any alternative to using OR for selecting between values?
>
> ie pla.type '1 ' OR pla.type '2 ' OR plHello
I am having a hard time getting Mysql to let root@(protected) connect.
I am constantly getting this
ERROR 1045 Access denied for user 'root@(protected) ' (Using password NO)
when I iKris
Is
...LIKE '%[img] ' + i.image_name + '[/img]% '
what you 're looking for?
PB
----- Original Message -----
From Kris Burford
To mysql@(protected)
Sent Friday MaPedro Baquero <pbaquerop@(protected) > wrote
> I installed mysql under RedHat 9 with mysql-standard-4.1.1-alpha-pc-linux-i686.tar.gz but when I try to start the mysqld with the sentence "./bin/mysqArunachalam <arunchp@(protected) > wrote
>
> I am really astonishing when I see the sample
> program on the URL
> http //www.mysql.com/doc/en/mysql_stmt_execute.html
>
> I am using
> MySIan van der Neut wrote
> Hello all
>
> Is there a scriptable way to determine if a slave in a replication setup
> has been fully synchronized with its master?
>
> Kind of like the following "Baum Stefan " <stefan.baum@(protected) > wrote
> Hi
>
> I 'm planning to use MySQL for logging from an SMTP-Relay.
> What is the maximum size of the database that can be reached?
>
Table sizemysql@(protected) wrote
> Here is the problem. I am getting random table locks in my databases on a new
> server running Fedora 0.96 and Mysql 3.23.58-7.
>
> It seems that different tabI have two tables that I want write one query that uses different where
clauses under conditions in the where clause. In the first table I have type
of document with document names. Through a thirdHi Ganbold
I think you are asking in the wrong place. I would suggest
ports@(protected) or current@(protected) or threads@(protected) see .
But my personal thoughts on this is if you are not rAll - I 've got a table that has an unsigned int that stores increasing
sequence numbers that are stored in UDP payloads. Occasionally messages
get lost and we 'll have missing numbers in the sequen "Keith Wilson (www.giraffedog.net) " <keith.wilson@(protected) > wrote
> I am trying to split the results from a select query across several pages.
>
> I have a contacts database and if someone
"Keith " <warlord_khan@(protected) > wrote on 11/03/2004 09 50 35
> 've had a good look through the manual and archives but can 't find
> an answer. I 'm pulling among other things a
Hi folks
I would like to know if there are a perfomance loss using PEAR DB comparing with PHP native Mysql functions and if this is a significant issue.
Also I?m wondering if using persistent John
----- Original Message -----
From "John Thorpe " <jthorpe@(protected) >
Newsgroups mailing.database.myodbc
Sent Thursday March 11 2004 7 34 PM
Subject Innodb logfiles timestamp quest "ron " <ron@(protected) > wrote
> Hello (first post)
>
> I 'm a noob to this group but I have an issue which I am hoping there is a
> solution to.
>
> I would like to have one instance of mysqlHi!
On Feb 21 HMax wrote
> So this means we cannot combine both FULLTEXT and classical indexes if
> we want to use a LOAD INDEX INTO CACHE and that we won 't ever be able
> to ?
No. FULLTEXKen Menzel wrote
> This may be more solaris related but I need to compile mysql with
> gcc because perl is compiled with gcc and I need DBD mysql. It seems
> the linker can 't find the libs. I
http //php.dreamwerx.net/forums/viewtopic.php?t 6
storage implementation that is not affected by max_packet_size.
On Thu 11 Mar 2004 Tomas Zvala wrote
> Hello
> I run into a problem According to this page in the online manual
http //www.mysql.com/doc/en/C_API_Prepared_statement_datatypes.html the
length element of the MYSQL_BIND structure when set to 0 will treat the
buffer eI have a very simple query
SELECT ProblemReports.* FROM ProbelmReports
If there is no data in the column 'Description ' it returns 'x '. There
is no default value being used and there is no d "Darran Kartaschew " <darran@(protected) > wrote
> Hi Everyone
>
> Is there an easy way to update a field for the last record referenced by
> an ID number? where that ID number is used on |
|
|
