I have run the 'show variables' query on my database and see that the
default character set is latin-1, and 'character_sets' includes 'hebrew'.
So I tried the following command
alter database presale default character set hebrew;
only to be awarded with a 'you have an error in your SQL syntax' mes
Hello everyone,
I need help with MySQL coding in php please if anyone can help.
I have 3 tables:
-users, where the user info is stored.
-awards: contains the list of all the awards for each user
-award_types: contains different types of award
The tables are at the bottom of the page.
What I need
* Rick ([EMAIL PROTECTED]) wrote:
> i guys!! im newbie, how can i backup a mysql database? what do you recommend
> me?
>
man mysqldump
--
.''`. Carl B. Constantine
: :' : [EMAIL PROTECTED]
`. `'GnuPG: 135F FC30 7A02 B0EB 61DB 34E3 3AF1 DC6C 9F7A 3FF8
`- Debian GNU/Linux -- The
> -Message d'origine-
> De : Rick [mailto:[EMAIL PROTECTED]
> Envoyé : Saturday, December 27, 2003 6:33 AM
> À : [EMAIL PROTECTED]
> Objet : backup
>
>
> i guys!! im newbie, how can i backup a mysql database? what
> do you recommend
> me?
>
mysqldump to begin
>
> --
> MySQL General
* Ville Mattila
> I have a table containing weather reports of different types and cities.
> The structure is following:
> - type
> - city
> - time
> - report
>
> Which kind of query should I use to select the latest reports of
> specified cities. I mean, if I had three different types of repor
On 27 Dec 2003, at 21:04, daryl hansen wrote:
I can't find anything in the manual about proper syntax for this when
creating a table. All I want is my "Price" field to equal the total of
my "Adults" and "Children" fields. Can someone please draw me a
picture?
CREATE TABLE Cart (
ID bi
On Sat, Dec 27, 2003 at 05:40:46PM +0100, Plinio Conti wrote:
Yes, a cron job will make the solution more robust.
I'm new to *classic* client-server DB apps and I'm still amazed for a
so standard issue I have to find tricks.
Particularly I wonder at this: standard SQL commands exist to assign
(GRA
Hello everybody ! I have question regarding the MySQL core certification. Does
anybody have any general insights on taking the exam ? I am studying from the
manual, but I am pretty nervous about the exam as I don't know how much in
depth the questions will be or even if studying from the manual
On Fri, 2003-12-26 at 19:26, Angus March wrote:
> I'm trying to use the API to write to a MEDIUMBLOB, but I'm getting a very
> vague error: something about a problem "near '' on line 1". I'm forumating
> the query string w/
>
> sprintf(query, "INSERT INTO support_files (session_id,file_type,file_b
> On Sat, Dec 27, 2003 at 11:09:54AM -0500, Angus March wrote:
> > > On Fri, Dec 26, 2003 at 09:35:42PM -0500, Angus March wrote:
> >
http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_query
> > > > The quote I'm thinking of is:
> > > > You must use mysql_real_query(
Hello there,
I am having a bit of trouble to get a ssl enabled client working on windows. For
testing purposes i was trying to compile mysqldump useing ssl. it compiles and loads
okay but right after i enter the password i get a debug assertion failed in file
dbgheap.c on line 1044. (the server
At 12:44 AM 12/27/2003, Michael Stassen wrote:
You're welcome. I did suggest some (not very elegant) SQL in my first
note. I take it that didn't turn out to be useful. It's possible that if
you were to describe why not, someone could make a better suggestion. Of
course, I suppose you may hav
--- Chris Elsworth <[EMAIL PROTECTED]> wrote:
> Use SQL_CALC_FOUND_ROWS.
> Documented in
> http://www.mysql.com/doc/en/SELECT.html
>
> You run your first query with SQL_CALC_FOUND_ROWS,
> then once you're
> done with it, you run another ("SELECT
> FOUND_ROWS()") and you get the
> total resultcoun
i guys!! im newbie, how can i backup a mysql database? what do you recommend
me?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
* Alaios
> with myIsam? Does not check about integrity?
That is correct, the myisam table handler does not support foreign key
constraints. It does of course support foreign keys, but not foreign key
constraints, consequently the foreign key itegrity is not checked for myisam
tables.
> Mysql 3.2?
Angus,
On Sat, Dec 27, 2003 at 11:09:54AM -0500, Angus March wrote:
> > On Fri, Dec 26, 2003 at 09:35:42PM -0500, Angus March wrote:
> http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_query
> > > The quote I'm thinking of is:
> > > You must use mysql_real_query()
Yes, a cron job will make the solution more robust.
I'm new to *classic* client-server DB apps and I'm still amazed for a so standard
issue I have to find tricks.
Particularly I wonder at this:
standard SQL commands exist to assign (GRANT) and remove (REVOKE) privileges,
but there is not a SQL c
> On Fri, Dec 26, 2003 at 09:35:42PM -0500, Angus March wrote:
> > > Angus,
> > >
> > > On Fri, Dec 26, 2003 at 08:26:38PM -0500, Angus March wrote:
> > > > I'm trying to use the API to write to a MEDIUMBLOB, but I'm getting
a
> > very
> > > > vague error: something about a problem "near '' on line
with myIsam? Does not check about integrity? Mysql
3.2?
What u will use for your application Innodb or MyISAM?
--- Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Hi,
>
> > Hi there. I heave heared that mysql doesnot
> support
> > foreign keys?
>
> It does, but only with the "InnoDB" table type.
>
On Sat, Dec 27, 2003 at 02:08:08PM +, Abs wrote:
> hi
> i was trying to group my results 10 per page ($p per
> per page). if i use limit, then there's no way of
> knowing how many there are left so i can't give page
> numbers as:
> << first 2 3 4 last >>. perhaps running the query
> twice, firs
hi
i was trying to group my results 10 per page ($p per
per page). if i use limit, then there's no way of
knowing how many there are left so i can't give page
numbers as:
<< first 2 3 4 last >>. perhaps running the query
twice, first time wihtout limit to see how many there
were and the 2nd just fo
--- Mike Johnson <[EMAIL PROTECTED]> wrote: >
> For the record, there's a syntax error in there --
> the closing curly brace is missing.
>
> echo "{$row["Password"]}\n";
>^
>
> Also, I've never tried this syntax with
> double-quotes. Do the curly braces keep the PHP
> par
On Fri, Dec 26, 2003 at 09:35:42PM -0500, Angus March wrote:
> > Angus,
> >
> > On Fri, Dec 26, 2003 at 08:26:38PM -0500, Angus March wrote:
> > > I'm trying to use the API to write to a MEDIUMBLOB, but I'm getting a
> very
> > > vague error: something about a problem "near '' on line 1". I'm
> for
Hi,
> Hi there. I heave heared that mysql doesnot support
> foreign keys?
It does, but only with the "InnoDB" table type.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
MySQL Gener
On 27 Dec 2003, at 08:59, daryl hansen wrote:
How do I make "Field3" a calculation, which equals 2 if fields 1 & 2
where values set to "1"? Any pointers in the right direction would be
sincerely appreciated.
Take a look at 6.3.1.3 and 6.3.1.4 in the MySQL documentation for
logical operators a
Please excuse me if I do not use the correct terminology for what I am
trying to descibe. I am new to mySQL and am using FileMaker and Lass to
export Filemaker data for use with mySQL. How do you make a field that
is the sum of two other fields in the same record? I have riffled
through the myS
This is a new 4.0.17 source install on Panther, and this is as far as I
got.
> sudo /usr/local/mysql/bin/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
Got
27 matches
Mail list logo
