Hi,
I'm getting the above error when trying to configure MySQL, after I type the following:
c:\mysql\bin\mysql mysql
I don't have the faintest idea what to do. (I have another questio...
I get this error:
ERROR 1064 (42000) at line 39: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near '...
Dear Experts,
I've been using MySQL for some time now, but I haven't really explored the more advanced features. Regarding field types for currency, when should I use a decimal and when sho...
Hi,
Can anyone please tell me the equivalent syntax in MySql for the following?
*** isnull(col_name,' ') *** (Microsoft SQL Server)
Since the query,
*** select isnull(col_name,' '...
I have a column that has comma separated data:
1,2,3
3,2,1
4,5,6
5,5,5
I'm trying to run a search that would query each value of the CSV string individually.
0<first<5 and 1<second<...
Hi,
When i am inserting date in just created table it returns following error: Duplicate entry '1' for key 1. The primary key is set to auto_increament. What could cause the problem and where...
Ello everybody,
Anyone know how to do this code in php to mysql
Hi,
Please kindly assist how can we resolve this error? mysql 5
Thanks.
Error Code : 1093
You can't specify target table 'member' for update in FROM clause
(0 ms taken)
(1 row(s) ...
Hello EE Community,
I am in the middle of setting up a virtual private server site and would like to use MYSQL Administrator instead of phpmyadmin to save time when needed on my Vista (clie...
I am running MySQL 4.1 on Windows XP professional. I am trying to connect to MySQL administrator. But it is giving the following error when I try to connect:
Could not connect to the specif...
I'm using this code to select people (EXEC) from a database which works fine. But I get php warnings in error_log:
PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL ...
I am new to this SQL stuff. can any one spot why I am getting the following error?
Error code 1064, SQL state 42000: You have an error in your SQL syntax; check the manual that correspo...
Hello experts, hope you can help me with this problem:
I'm trying to use the create function statement inside a delphi program using Zeos DBO to connect to a MySQL 5.0.41 server. here's the...
Dear Members:
I'm experiencing the same issue as a previous question: "Title: Unable to connect to the database: Could not connect to MySQL" but I can't seem to find any posting of a possib...
Server = MySQL 3.23
Idea : To get the time difference between two fields
select sttime, endtime, (period_diff(endtime, sttime)) as a from worklog
where id > 2000 limit 10;
+-------------...
I am a Database Programmer, but in Access and SQL Server.
I have two questions:
I have access to the PHP myAdmin and can see that the database has six tables. I also have ftp access. W...
Hi all
How do i define a currency format in mySql
I have imported a Access database table to mySql
Got a collum containing prices with 2 decimal after a comma... like this 7,25 eur...
Hello:
I am working on a login script. (Was working before). User enters login information which then signs them in. However my page "Loged In" returns the following error message four time...
I need to know if it is possible to OUTER JOIN multiple tables at the same time.
this would be like OUTER JOINing 2 queries together
this code works (but is a pain to update and takes foreve...
I am trying to import a few large SQL files into MySql using MyPHPAdmin. Of course this is not successful because it says that the file size limit is Max: 32,768 KiB. A found a suggestion whi...
I am attempting to add a column to a table with data in it. Nothing
I have seen says you can't butI get an error that says it could not save
the table as some other name. I am assuming it cr...
What is the SQL command to list all tables in a database?
What is the SQL command to list all columns in a table?
If i change the code be low mysql_query("SET CHARACTER_SET_RESULTS=utf8") to
mysql_query("SET CHARACTER_SET_RESULTS=tis620") what will happen when i update form php code
if (EW_USE_M...
How can I make Entity relationship diagram for my Mysql tables. Is there any tools for that?
When you run a sql script file in command line with MySQL you can redirect the output of the query in a file but not the errors apparently:
>mysql -uuser -ppassword < sql_script_file > outp...
