create

Hello, I am using the Apache CXF 2.5.0. Whenever I try to create the service, I get a ClassCastException: CatalogueService catalogueService = null;…

$dbhost = 'localhost'; $dbuser = 'root'; $dbpass = ''; $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' .…

I'm creating a stored function like this CREATE FUNCTION getVendorID(IN venname VARCHAR(255)) RETURNS INT BEGIN DECLARE a INT; SELECT vendorid FROM…

I am trying to create new signed certificates on a Corporate Firewall 2008 Smoothwall machine and I am getting an error that says Error - Unable to…

DROP PROCEDURE IF EXISTS CreateTopic; CREATE PROCEDURE CreateTopic ( i_forum_id INT, i_user_id INT, i_title VARCHAR(255), i_language VARCHAR(50),…

I'm looking for a little help with this table. First: The table isn't being accepted by mysql. I'm getting a 150 error, which doesn't tell me much.…

Hi I have a problem between a database in PostgreSQL and SQLite. I need to work (single user) I had to create the database in SQLite, and luckily I…

I"m able to put a file up to a remote FTP with a modified version of... $File = "D:\Dev\somefilename.zip" $ftp =…

Hello all, I'am new to mysql and i want to know what KEY (not primary key) means in the query below : CREATE TABLE `users` ( `id` int(11) NOT NULL…

I'm not sure this is possible, but the code I tried using first is: mysql_query ("CREATE TABLE My_table as ( SELECT * FROM CPE LEFT JOIN…

Hi there, i create a database for e-commerce i have one thing doing it wrong and i don't know why .. apparently one of my table (succursaleProduit)…

I'm receiving the following error when trying to create a function in mySQL 5.1: Error Code : 1064 You have an error in your SQL syntax; check the…

Hello, I'm trying to create Mysql database for Drupal according to these instructions " First, you must create a new database for your Drupal site…

Just getting into SQLite and I understand it does not use datatypes the same way as other languages. I'm building a database and it has to store…

According to CREATE VIRTUAL TABLE syntax , IF NOT EXISTS clause is not available . How should I handle the case when the virtual table already…

Hi, I have a PHP script that creates 70 empty tables. However, it's taking nearly 30+ seconds to create them. What is causing it to take this long?…

Hi, is there a mysql equivalent of SHOW CREATE TABLE in postgres? Is this possible? If not what is the next best solution? I need the statement…

What is wrong with this statement? CREATE TABLE `CSV_DB`.`bavaria_test` ( `Schule`, `Stasse`, `Ort`, `Tel`, `Schulgliederung`, `Integrationsklasse`,…

Hi all, i'm trying to create a temp table from a parent table: This is the code that i execute with pgAdmin III ( or by JDBC in Java ): CREATE TEMP…

I have searched a while and can't find an answer to my problem. I have a table that looks like this: date name status 2011-01-01 m1 online…