 | | | MySQL General | | Greg Willits wrote
> I 've installed mysql 3 & 4 a dozen times or more but I 'm having trouble
> with 4.1.2 on OS X Server (10.3.4).
Maybe it 's not a MySQL problem -- I just happened to read GET_LOCK is just a string lock and has nothing to do with tables.
Use LOCK TABLES instead.
Richard Clarke wrote
>The manual indicates that a GET_LOCK expires automatically when a new
>GET_LHi Andy
First of all you can make a temporary table..
Query 1
CREATE TABLE t_mytable
SELECT *
FROM myTable
WHERE OnSale 'Y '
Query 2
INSERT INTO t_mytable
SELECT *
FROM myTable
OI belive ive gotten mySQL installed but im getting a few errors that I
cannot seem to figure out. When I try to test out the database by typing
bin/mysqlshow or bin/mysqlshow mysql I get an erroHi everyone
I 've got a project where I record measurement data for various objects in 15
minute intervals. A simplified table structure could look like
- objectid Integer
- dt DateTimeI 'm having trouble with a query and hope someone of the list can help. I 'm
running version 4.0.16. I 'm trying to query against two tables
mysql > DESCRIBE router
+-------+I saw the announcement regarding some sort of issue with getting MySQL 4.1.2
ready for the Win32 platform - so what is the specific problem? I 'm not
saying that I could fix it but I bet many otherI have SuSE 9.1 and can 't find any "GUI auto config " type option to
start mysqld at boot up so I was wondering what was the best way to
configure MySQL to start at boot time
Chris W
Bring BaI am using mysql_query to insert into a column which is of type
datetime. My variable is stored in a char string. I need to put it into
the query in a way that it can be inserted
myDate "98-Rpm -U xxxxxxxxxxx
> -----Original Message-----
> From Larry Lowry [mailto Larry.Lowry@(protected)]
> Sent Tuesday June 01 2004 9 55 AM
> To mysql@(protected)
> Subject Upgrade 4.1.1 to 4At 11 50 1/6/2004 Nandan Telang wrote
Hi
Thank you for your bug report.
>Hi
> I have been trying to build from the MySQL server source distribution
> 4.1.2alpha for Windows.
>I creatFrom "Mike Blezien " <mickalo@(protected) >
> 040601 9 17 20 Warning Asked for 196608 thread stack but got 126976
> Is this type of Warning something to be concerned about or is this common
Hi!
This is a bug that is fixed in upcoming 4.0.21. See below for a workaround.
"
If you configure innodb_additional_mem_pool_size so small that InnoDB memory
allocation spills over from it Hi!
MySQL/InnoDB-4.1.2 is totally broken and useless if one has specified
innodb_file_per_table in my.cnf on Unix!
In crash recovery InnoDB scans the database directories under the datadir
aDon 't EVER copy to database files while the server is running.
This is a guaranteed way to crash your database files.
Shutdown the server.
Copy the files.
Start the server.
Abuzar Chaudhary On Tue Jun 01 2004 at 09 28 37AM -0400 adam wrote
>
> mysqldump --user root --password <root-password > --opt bugs >
> $BACKUPDIR$BACKUPSQLFILE
>
> My problem is that it does not seem to woHi!
I 'm using mysql-max-nt Version 5 running on Windows 2000.
While inserting rows into a table from a perl script i get error 1146
"table mysql.proc doesn 't exist ".
The application ran withoI have the call to mysql_server_init() cided exactly as it appears in
the mysql manual sample. It returns 0 (success) yet the server is never
sarted . I check that its not running by trying to typeHello mysql
Recently downloaded myODBC for use Win2k SP4
initially used EXE version (MySQL Connector/ODBC 3.51) when installed
Looking at its properties
myodbc3.dll shows that it 3.51.6 ??
Buna ziua...
In cazul in care cineva din echipa dvs.are de rezolvat probleme in Bucuresti pentru citeva zile si ar avea nevoie de cazare va propunem o solutie alternativa la cazareaphp <php@(protected) > wrote
>
> @@@@@@@@@@@ please help me! @@@@@@@@@@@@@@@
>
> mysql > REPAIR TABLE f_ivairus_bodies
> +Hello list
im having a hughe problem with the RAND() function
first of all im using mysql 3.23 so subquerys are impossible.
Im having three tables which are joined by ID 's now i want to seJohn Mistler <johnmistler@(protected) > wrote
> Can anyone guess why I am getting this error
>
> "ERROR 1 Can 't create/write to file
> '/Users/johnmistler/Desktop/TestFile.txt ' (ERRCODE 13) "
"paqogomez " <paqogomez@(protected) > wrote
> I am trying to build a stored procedure in v. 5.
> This is what I have so far.
>
> delimiter |
> create procedure get_id(out oid int)
> begin
> At 12 38 -0700 on 05/27/2004 Daevid Vincent wrote about Re Feature
Request UPDATE 'error codes ' or mysql_affected
>REPLACE INTO won 't work as I need the previous record (hence the update). INik Belajcic wrote
>This may be a silly question but I am wondering if there is something
>opposite to
>
>@(protected) $sth- >fetchrow_array
>
>In other words instead of fetching rows from MySQL
"Donny Simonton " <donny@(protected) > wrote on 01/06/2004 03 12 43
> We have been using 4.1 in a production environment since about a month
after
> 4.1.0 was released. And we > Peter
> Actually
>
> Mysql -uUSERNAME -pPASSWORD works just fine.
>
> Donny
And `mysql -u root -p somepassword` will not work. With the space between
-p and "somepassword " mysql I 've been running OPTIMIZE TABLE on a MyISAM table with an index on two
varchar type columns. The process status shows as "Repair with
keycache ". The table has 73 million rows. OPTIMIZE TABLE has
ColdFusion Lists wrote
> Hi
>
> my table have an field when users can enter any chars....
>
> If users dont send any content for that field(phone) mysql store "( ) - "
> without quotes |
|
|
