 | | | MySQL General | | hi all
i 'm building MySQL-4.0.20 from source on OSX 10.3.3
fwiw my build env includes
gcc (GCC) 3.3 20030304 (Apple Computer Inc. build 1640)
autoconf --verautomake (GNU aufr0g <fr0g@(protected) > wrote
>
> Well I 'm in despare.
> I have a record in my DB with name Michalis and surname Ka*l*ogiannis.
> When I try to add name Michalis and surname Ka*k*ogiannis I geNot sure if this will help but we recently ran into a problem
building MySQL on a Solaris 9 system - the build failed at the
point of trying to make "readline " because of a missing file
Makefile.iOn Thu May 27 2004 at 03 59 46PM -0400 Bono Saroj AA R62 wrote
> I am going to use mysql_query() and want to find out if a certain
> database exists. If mysql_real_connect() fails there are mWell my "hack " (which is sort of like what you suggest) is to change my
primary key from just an auto_increment 'id ' field to a combination of two
other fields (mac/scanner_id) that I know must be -----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Hi
MySQL Connector/J 3.0.13 a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.0.13 is a bugfix releaseHi
I am sure all FreeBSD users are sick and tired of saying this. USE 4.10!!!!
Lots of people blindly follow version numbers but 5.x is a lot different than 4.x in ways I don 't yet feel comfortab "MYSQL " <mysql_list@(protected) > wrote
> Is it possible to write a SELECT statement that will select all columns but 1 or 2 certain
> ones?
Nope.
>
> I know I can do SELECT Col1 Col2 Col3Hi Paul
assuming that the first three occurances of blanks can be regarded as
field separators you can do
prompt > cat file.txt | sed \
-e "s/ '/\\\\ '/g " \
-e "s/ */ ' '/ " \
-e " "Robinson Eric " <eric@(protected) > wrote
> Hi
>
> I included the following statement in my.ini
>
> log 3Dc \log.txt
>
> I then executed some queries.
>
> The file log.txt only shIn C API after running mysql_query() I want to stop
this query by mysql_kill(). But I can not get the
specific process (query) ID. How could I solve this
problem?
mysql_list_processes() return Hello
Libraries and header files RPM download at http //dev.mysql.com/downloads/mysql/4.0.html
is the mysql-devel package right?
Thanks!
Carlos
Hi
I was running the test-select under the /usr/local/mysql/sql-bench dir and was wondering if someone could help break it down for me ( Or at least the "Testing big selects on the table " section Now the fun part becomes which linux distro do you use? Which is faster?
Because trust me each distro will benchmark differently.
Let the games begin!
Donny
> -----Original Message-----
I wished to use MySQL clustering for application development that is Windows-based. Since the binaries aren 't available as yet I tried using the source distribution (tried to build using cygwin) but Did you change the permissions for the files to include
read/write/change for the user/account MySQL uses on your system? This
doesn 't require deleting as far as I recall Windows permissions...
Since the database I created was not critical I could simply throw it away.
Therefore
delete the whole MySql installation directory and unzip the alpha release
zip file again
to create the instaCheck permissions on the mysql\data directory and files/folders below
for the MySQL process/user (sorry for not knowing the right Windows
terminology I 'm not a Windows user).
HTH
Robert J David Blomstrom wrote
> I 'm working on an add/edit form illustrated by the
> screehnshot at http //www.geoworld.org/addedit2.gif
>
> I decided to arrange the rows by ID rather than
> alphabetHello
I run into a problem after re-installing mySQL 4.1.1 today. When I
tried to start the service on my Windows2K I got the following error
040527 15 37 49 Fatal error Can 't open pr "Abdul Aziz " <aaziz@(protected) > wrote
>
> How can we optimize MySQL queries plz define easy method
> comparing as well as better performance for data retrieval.
>
The following chapterFajar Priyanto <fajarpri@(protected) > wrote
>
> Hi all
> I 'm trying to move my Mambo (content management) database from one server into
> another.
>
> In the old server the mysql version is Daevid Vincent wrote
> Well my "hack " (which is sort of like what you suggest) is to change my
> primary key from just an auto_increment 'id ' field to a combination of two
> other fields (mac/scaI 'm developing a program where I try an "UPDATE ... LIMIT 1 " and if
mysql_affected_rows 0 then I know nothing was updated and so I do an
INSERT. I find this is much cleaner and the majority of tHi
> On Wednesday 26 May 2004 11 22 pm kyuubi@(protected) wrote
> > Hi I am trying to use the foreign key constraints from InnoDB
> > and creating indexes is a requirement for foreign key.
> I can not find this in the docs.
I can see in phpmyadmin what a table comment is and what type of table it
is such as MyISAM etc.
I have a field in mysql 4 using InnoDB
Field is timestamp 14 and defualt is set to 00000000000000 which I want to
be the result of NOW() so that every record made will get NOW() as the
value I cHello
Is there any way to have per user stats? In the bin log we have
nothing but exec_time 0 (seems this is "seconds ") - is there a way for
more precise statistics what different users do regarDear Mark
You should be tweaking your mailer such that your mails originate fom
msusol@(protected) and not my own email address.
Thanks
Mike
> -----Original Message-----
If there is an FAQ where this is addressed please point me to it so
I can RTFM.
I need to find out if table joins lock the table or alternatively
how to find out what query is locking the ta |
|
|
