MySQL Database Forum

Greetings, I'm trying to execute a sql file in the command line for sql 5.5 on a windows 7 computer. My sql file is on my c drive in the directory "john". My sql file is named mysql-start.sql. How do I execute the source command to run this sql file? This is something I am learning from a free online database class from Stanford. Here is how...

I am a newbie in the world of MySQL. In fact I enabled it in my Linux box only because it is required to run WordPress (the blogging software). I was trying to plan ahead and figure out a way to backup (and restore) a database, should my Linux machine ever goes belly up. I disovered that the databases are stored in subdirectories under...

Recently, I began using a different MySQL verver (i.e. different machine as well as different version#, going from 4.12a to 4.1.9 max). The following query used to work: select firstname, lastname, from associates where username like 'nancianne' but now fails with: "You have an error in your SQL syntax; check the manual that corresponds...

Here is what I did: - I had a perfectly working compressed table: ccc in database ddd - uncompressed it: # myisamchk -u history200310 - recovering (with sort) MyISAM-table 'ccc' Data records: 13786290 - Fixing index 1 - then tried to access it

--Apple-Mail-2--68472726 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed Can not make mysql connection - error log: 030708 08:53:48 mysqld started

I got this error #1030 - Got error 28 from storage engine when i'm trying to access in table in my database.........or when i'm trying to edit particular entry from any table this error #1030 - Got error 28 from storage engine will come so anyone can tell me the solution of this error..........is it from my side or from server side????? ...

Hi, I just migrated a MySQL database from my test server to my production Server with success. This database ia a backend for a .net application Im running. Now the problem is that when I try to connect to the database on the server(new one) I get the following error: Connection Failed: Can't connect to MySQL server on 'localhost' (10060) ...

Hi, i am wondering how did a website like facebook, myspace or whatever social networking site store their images? do they store them in a DB or roughly like files? thankyou in advance and cya!

Anyone can explain the following? Table definition: CREATE TABLE testdate ( SalesDate DATETIME, SalesTotal DOUBLE, PRIMARY KEY (SalesDate) )

Hai All, This is my create statement CREATE TABLE `dbname`.`tablename` ( `vh_id` int(10) unsigned NOT NULL, `gh_utc` time NOT NULL, `gh_mydate` date default NULL, `gh_serverdate_time` timestamp NOT NULL default CURRENT_TIMESTAMP, KEY `FK_geo_gpsdata_2` (`vh_id`)

I have this kind of code : Declare a number; s1 number default 0; Begin a:=1; loop s1:=s1+a; exit when (a=100);

Hi all I inherited a server running MySQL 4.* from a previous developer. Now, the records on this database might be what I want, or they might just be test data. I think my only chance of finding out if this is the real thing is to find the date and time of the last insert into the database. How can I do that?

Hi, I was storing integer values like 5000 and 10000 in a column which was defined as varchar. i was trying to use statement like 1.select * from mytable where mycol between '5000' and '10000'; but was not working but 2. select * from mytable where mycol between 5000 and 10000;

I know there is a way to create a temporary column as part of a basic Select Statement search that shows the result of mathematical calculations done in that search, but I can't remember the syntax and googling it has been a wash out. I have a list of classes in a database. I need to list all classes with less than 12 students in them, that's...

Hello I live in Brazil and here we use comma (,) as decimal separator and period (.) as thousands separator. How can I show my values in MySQL using the Brazilian way? MySQL shows this: 123,456.00 I need it this way: 123.456,00

I have a mysql table, with a field called DATE, how do i get it to automatilly put the date on it every time a new recored it put on the table Date and time would be good, Tahnks

Hello, I am trying to perform a LEFT JOIN on a table which may or may not have matching rows. If there are no matching rows, it returns NULL's for all the missing fields. Is there anyway of returning the default values for that table instead of NULL's, in a portable way?

I'm a newbie to MySQL and am really confused about when I should be using the Command Line Client and when the DOS prompt. I'm using Windows XP and I've just installed MySQL 4.1.10. I can use the Command Line Client to logon as 'root'. It prompts me for a password and then I can create databases, etc. from the mysql prompt. However, if I...

Hi, I have a mysql table where in i have a field called patient_id which i do an auto increment and its the primary key !! since this number goes on patient card also simply 1,2 will not be gud . Is there a way to prefix some text to it like patient1, patient2 something like that!!!

I am trying to read a mysql dump file that I was given from a mysql dump file into my mysql server, I am using the following command at the mysql command line and get the following error: mysql> items < c:\bookings\items.mtsql ERROR: Unknown command '\b'. ERROR: Unknown command '\i'. Does anyone know what this means?

hi friends, i have a problem.i m using phptraid or php4 with mysql and phpmyadmin with apache in window XP my local machine.i hve used phpmyadmin for table creation,deletion,updation and insertion.it work fine earlier,but now when i try to do any operation with a table,its shown a error message,that table is read only. for ex: let i have a...

I want to retrieve all records from one table and insert them into another table. Can this be done in one statement? I appreciate if anyone out there can help me out. Thanks in advance! Alex Shi

how can i display both image and other information in the web page using php? i'm using mysql database. I do displaying the image only but i want to display both other information from the database and the image from the database also in one web page... how can i do this? pls help..... thanks.

I know this has been asked before and yes, I have read the section in the documentation about it. But, my question is: If I have setup mysql with strict_trans_tables, will MySQL allow "null" defaults in "not null" columns? If the answer is yes, will that information be reflected when I ask for metadata (column information, etc.)? Currently,...

Hi, 1. I want to calculate size of the record by mysql queries. Is it possible.. 2. What is the best way to calculate table record size which consists of Text type. Regards, @wahab.