My mysql version is 5.0.12-linux.
I use "show variables like 'innodb_safe_binlog'".
But i can't find this option.Why?
i'm using myisam. Is there any tip i should know before to migrate this
table to innodb ?
Thanks !
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 29, 2005 12:35 PM
Subject: Re: locking issues
Hello.
What table engine do you use for yo
"Beauford" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:31:24 PM:
> I just installed MySQL 3.23 (the only one I could get to work) and I
find
> that I can log into the server just by typing mysql at the DOS prompt.
Ho do
> make it so you have to use a user name and password to get in.
>
> Thanks
Michael
>Is there a command similar to "SHOW CREATE TABLE. . ." that will
>output the commands to fully duplicate a table; data and all? I want to
>retrieve the command and write it to a text file.
See the docs for mysqldump.
PB
-
Michael Williams wrote:
Hi all,
Is there a command
>Error
>SQL query:
>call p0(
>)
>MySQL said:
>#1312 - PROCEDURE tr.p0 can't return a result set in the given context
To permit calling of stored procedures, the CLIENT_MULTI_STATEMENTS flag
must be set (4th param to mysql_connect() or mysql_pconnect()). Looks
like the phpMyAdmin working group h
Hi,
If you've just installed it then the root user has no password.
Change the root user to have a password then you will have to specify
the -p parameter on the command line before you can log in. (Or you can
put it in your local my.cnf file)
=C=
www.calevans.com
Beauford wrote:
I just in
You could still still use mysqldump. There is a parameter to specify
which specific table you want to dump.
Usage: mysqldump [OPTIONS] database [tables]
=C=
www.calevans.com
Michael Williams wrote:
Hi all,
Is there a command similar to "SHOW CREATE TABLE. . ." that will output
the command
- Original Message -
From: "Michael Williams" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 29, 2005 11:30 PM
Subject: SHOW commands.
Hi all,
Is there a command similar to "SHOW CREATE TABLE. . ." that will output
the commands to fully duplicate a table; data and all? I want
I just installed MySQL 3.23 (the only one I could get to work) and I find
that I can log into the server just by typing mysql at the DOS prompt. Ho do
make it so you have to use a user name and password to get in.
Thanks
Running on Win2k Advance Server.
--
MySQL General Mailing List
For list
Hi all,
Is there a command similar to "SHOW CREATE TABLE. . ." that will
output the commands to fully duplicate a table; data and all? I want
to retrieve the command and write it to a text file.
Basically what I need is a "SHOW" on "CREATE TABLE copy SELECT * FROM
original", but SHOW doe
Hi,
I have a table with consumer products. I have a row "product name" and
"brand".
If I do a full-text search in boolean mode for a term like "apple ipod" I get
results like:
Apple iPod (brand: Apple)
TuneDock for Apple iPod (brand: Belkin)
Since both of these terms mat
http://dev.mysql.com/doc/refman/4.1/en/control-flow-functions.html
ifNULL()
=C=
www.calevans.com
sol beach wrote:
The subject says it all!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The subject says it all!
HI David,
The following error is generated calling the previously defined stored
procedure p0() in phpmyadmin:
Error
SQL query:
call p0(
)
MySQL said:
#1312 - PROCEDURE tr.p0 can't return a result set in the given context
Any suggestions would be greatly appreciated
-Original Message--
Hi Dave,
The DELIMITER statement is a command to the mysql client not an SQL
statement. This is why phpAdmin is objecting. Here are a listing of the
mysql client commands
http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html
Regards
David Logan
Database Administrator
HP Managed Services
Windows XP
phpMyAdmin 2.7.0-rc1
MySQL 5.0.16-nt running on localhost as [EMAIL PROTECTED]
The DELIMITER statement works in the command line, but not in phpmyadmin
(see error below)
mysql> DELIMITER //
mysql> use mysql //
Database changed
mysql>
PHPmyadmin ===
DELIMITER
I just wanted to thank you for such a thorough response, it has helped me a
lot as I've always ignored the existence of joins.
Thanks,
Matt
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> The sequence you use to JOIN a set of tables is sometimes determined
> completely by the log
Hello.
What table engine do you use for your tables? InnoDB usually
is the best choice if you have lots of concurrent updates and inserts.
"PaginaDeSpud" <[EMAIL PROTECTED]> wrote:
> I'm getting locking issues due to tables very often updated/insert.
>
> It's splitted into two tables,
- Original Message -
From: "Jeff" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 29, 2005 11:42 AM
Subject: Insert query problem
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets(id,from,department,subject,body,lastac
Colin
Currently executing a stored procedure also requires select permissions on
the mysql.proc table. This is a current implementation requirement. This
should disappear when we have INFORMATION SCHEMA support.
Reggie
> -Original Message-
> From: Colin Shreffler [mailto:[EMAIL PROTECT
Thanks for everyone's input. Essentially, I summed up all the NEGs and
non-NEGs in a view and then use the 'if' logic to filter out the numbers.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You can use backticks ( ` ) to escape the names:
INSERT INTO `tickets` ( `id` , `from` , `departement` .
hth,
melanie
From: "Jeff" <[EMAIL PROTECTED]>
To:
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it keeps compaining that the
Many Many wrong SQL syntax error check your symbol (') becareful it 'very
important .
You can do that.
Cheer!!
From: "Jeff" <[EMAIL PROTECTED]>
To:
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it keeps compaining that there is a
Jeff wrote:
tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
tus,created,fromname,lastpostname,attach,ct,uniq,notify,replyto)
values(null,'jmckeon','1','test','test
test',unix_timestamp(now()),'"[EMAIL PROTECTED]"
<[EMAIL PROTECTED]>','Medium','Open',unix_timestamp(now())
Nevermind, found that usig `from` works.
Jeff
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 29, 2005 11:43
> To: mysql@lists.mysql.com
> Subject: Insert query problem
>
>
> All,
>
> I can't get this query to run, it keeps compaining that there i
"Jeff" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:42:34 AM:
> All,
>
> I can't get this query to run, it keeps compaining that there is a
> problem:
>
> The Query:
>
> insert into
> tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
> tus,created,fromname,lastpostname,atta
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
tus,created,fromname,lastpostname,attach,ct,uniq,notify,replyto)
values(null,'jmckeon','1','test','test
test',unix_time
Dewald Troskie wrote:
I'm relatively new to the MySQL / Web development - database
environmeent, having moved from Microsoft SQL. Just two questions ?
1. I have an ASP.Net page that commits data to a MySQL database. I have
several check boxes on the page. What data type do I define my fields
The sequence you use to JOIN a set of tables is sometimes determined
completely by the logic of the JOIN. You should perform all of your CROSS
JOINs and INNER JOINs first (a comma is equivalent to a CROSS JOIN but
starting with 5.0.12 the comma has a LOWER evaluation priority than an
explicit J
In article <[EMAIL PROTECTED]>,
sheeri kritzer <[EMAIL PROTECTED]> writes:
> On 11/28/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>>
>> > Part of me agrees with you, on a "Pure SQL level". but then why would
>> > anyone ever use ENUM or SET?
>>
>> I wouldn't :-)
>>
>> IMO, they're abomination
Hi,
I'm relatively new to the MySQL / Web development - database
environmeent, having moved from Microsoft SQL. Just two questions ?
1. I have an ASP.Net page that commits data to a MySQL database. I have
several check boxes on the page. What data type do I define my fields in
the database as
31 matches
Mail list logo