RSS News Sources

gyl

ekojx

hesqm

bftvetq

?10???

???,????,????

Hi

I'm interested what's the maximum recommended Mysqli database name and password lenght? I'm using Direct Admin.

I found article http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

so I'm correct that i can add new mysql database name with max 64 characters? Are there any contraindications to use long database name and password?
Can I use alpha and numeric characters as well when setting database name?
What's about reccomeded password lenght?

Thanks in advance for the answer.

Regards

hi friends ,

can anybody please tell me is mysql supports triggers or not ? please asap.

Hello,
I saw in some situation a weird 'where' clause specified in the select/update query, something like "select points from users where id = id and name = 'john'" and the query is running fine, 'where id=id' - what is this for? It's a mysql optimization or it's just a innocent mistake? Is this recommended for use?

Jacob Kruger

hi friends ,

please anyone can you please tell me how can i write stored procedure here ?

Grupo_IOE_-_Universidad_de_Alcalá

hi friends,

i am new to mysql please tell me how can i create triggers in mysql ?

I would like to uninstall MySQL 5.5 community edition from windows command prompt or any other option other than uninstalling from Add/Remove programs.could you please provide me with the commands or other options to uninstall MySQL from windows 2008 R2 operating system

MySQL Version: 5.1.60-community
I have this error on Glassfish:
java.sql.SQLException: Can't create/write to file '\tmp\IMPSUB_de80d009527fb473ba387cbcda838776.csv' (Errcode: 2)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)

I am on Windows, but the file given looks like a linux file.
The variable tmpdir is set, as revealed by:
show variables like "tmpdir";
which gives:
| tmpdir | C:/TEMP |

Any ideas?

Thanks

How to clear screen of mysql command prompt in both windows and linux environment.

Thank You

Dear friends,
I am studying SQL and still have to understand a lot.

I am trying to write a query that will retrieve the two highest values in a date field.

SELECT dateadded
FROM `italy`
GROUP BY dateadded
ORDER BY dateadded DESC
LIMIT 2;

but this is not givine me the two most recent dates but only the first two values.

Changing the DESC clause to ASC does not seem to achieve what I need.

Any ideas ? Thank you in advance

<?php

$sql = mysql_connect("localhost","UGA","CHAKA";
if (!$sql) {
die('Could not connect. Probably has something to do with this: ' . mysql_error());
};

ini_set('display_errors', 'On');
error_reporting(E_ALL | E_STRICT);

$dtbs = mysql_select_db("information_schema", $sql);
if (!dtbs) {
die ("Can't use database: " . mysql_error());
};
$result = mysql_query("SELECT * FROM DESCRIPTION WHERE CHARACTER_SET_NAME='hebrew'");

echo $result;

?>

For some reason, when i'm browsing to the php file i'm getting either a 500 Server Error or a blank page..
I'm the absolute beginner with PHP, the most I look for debugging posts and tutorials the more I see how grand PHP is, so.. I don't even know where to begin.

Any reply would be great at this point, stuckism. =]

The exciting and choked with suspense plot, the additional reason for you to download Battleship and luxuriate in it. fancy it not solely throughout the 2 hours and 10 minutes once you can anticipate the primary time however conjointly afterwards also. the best resolution to the trend being foreseen is to download Battleship Movie, and luxuriate in the amazing movie with its superb storyline. Moreover the probabilities of this rage to subside are slim, whereas the celebs of the mega plot can stay on high.



http://downloadbattleshipmovie.metroblog.com/

I am lost in a query, Can somebody advice me please.

This is my data in 1 colomn:

2834-P&PPREPACK

i Want to create a extra colomn.

my argument has to be:

Search for '-' position and give me only numeric data (2834) in a new colomn.

Please dont send me links,
but give me an explanation so i understand and not RTFM....

Kind Regards,

Ivan